Hi, I have several workbooks being returned to me to validate, I built them so that an individual could attach both a word document and an image as separate objects added into the workbook with a macro. The macro identifies the name of the file and enters this name into cell A1.
Using this name, I now need to export that attached object to a folder called C:\ArchiveAttachments\
How can I do this, I can only think that I would a) need to use the name to identify which attached object to export, or b) use the name to identify the Object Number to export. Then I need to actually export it to the folder whether by opening it first or not. Any advice will be appreciated.
Our community of experts have been thoroughly vetted for their expertise and industry experience.