Hi Experts,

I have tried looking but have not found if there is a way to have a Macro copy all embedded files on a Specific Excel Tab and save to a location on the C: drive. The files will be PDFs that are embedded. I need to be able to click a button and take all of the files and save them to a local directory(in PDF format, native format). If the Macro could clear the directory before the new save that would be great but can live if that is not possible. If someone has a way to do this I would really appreciate any help. Please let me know if you need any more info. Thanks in advance for any help.