I have a workbook that is saved under many different file names that users use to update sales forecasts. From time to time,
I have to update the workbooks to make changes. Instead of opening each workbook, making the change and saving/closing, I
created a macro to open each workbook, perform a macro (below listed as "Personal.xls!Macro10") and save/close.
What I need to do within the "Personal.xlsMacro10" is toggle between a workbook I'll call "Test.xls" and the workbook I've
opened. Without adding this step into each line of code for each named workbook, can I use VBA to copy a worksheet in
"Test.xls", switch to "116.xls" (this example) without calling out "116.xls" ? I tried 'Thisworkbook' but that didn't work.
This would save me hours of time if someone can assist. Thanks
' dailysalesfix Macro
Application.ScreenUpdating = False
ChDir "U:AccSalesDAILY SALES & MDS2007 SPRINGENT01"
Workbooks.Open Filename:= _
"U:AccSalesDAILY SALES & MDS2007 SPRINGENT01116.xls", UpdateLinks:=3
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines