Trying to get parentdevdir name of Reference attachments attached with relative path

Hi all,

I'm working on a macro where I want to be able to modify the attachname of certain reference attachments. Our configuration is set to bring in attachments using save relative path but my code needs to be able to determine what the value of parentdevdir for each of my reference attachments is but I am unsure how I can do this. Can anyone suggest how I can achieve this?

Thanks

Parents
  • Barry Lothian said:
    My code needs to be able to determine the value of parentdevdir for each of my reference attachments

    Add a VBA reference to the Windows Scripting Runtime DLL.  Scripting Runtime provides the invaluable FileSytemObject (FSO).

    The FSO gives you what you need to work with files and folders.  The File object has methods to extract bits of a file path and reassemble them.  Our article provides some examples.  You'll find more on Microsoft news groups.

     
    Regards, Jon Summers
    LA Solutions

Reply
  • Barry Lothian said:
    My code needs to be able to determine the value of parentdevdir for each of my reference attachments

    Add a VBA reference to the Windows Scripting Runtime DLL.  Scripting Runtime provides the invaluable FileSytemObject (FSO).

    The FSO gives you what you need to work with files and folders.  The File object has methods to extract bits of a file path and reassemble them.  Our article provides some examples.  You'll find more on Microsoft news groups.

     
    Regards, Jon Summers
    LA Solutions

Children