troubleshooting Question
How to export a worksheet objust to a folder?
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.
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.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.