DougDodge
asked on
Excel VBA to copy range from closed workbook to active workbook
Looking to use VBA to copy range columns A:W from a closed workbook in worksheet "Worksheet1" to my active workbook, worksheet "Worksheet1" range columns A:W
The source workbook has a different name each time it is looked for, as it is renamed after the last update.
The source workbook has a different name each time it is looked for, as it is renamed after the last update.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you don't want to open the workbook there's some code eamples using ADO here