Hi,

I have recorded a macro to copy from a sheet in a workbook and paste into another workbook to use for an access upload into one of our systems. I am trying to figure out how to have the macro of the location of the workbook being copied change as the file name changes. The filename that changes is the ("13-9999-quotation.xls") in the code I have listed below.

Please Login or Register  to view this content.
Thank you,
Sandi