So I am working on a script that pulls several excel workbooks together into one. Some of my source workbooks have 'update" scripts embedded in them and before i copy the worksheets to the new master file, I want to run the 'update' script
'Copy Evoke LV - Sundries into LV CA-0
Workbooks.Open Filename:= _
"\\mhf.local\PrdtMgrPriceLists\Accessories and Sundries\Met West\Current Updated Version\CURRENT CAN West - Sundries.xlsm"
Call SundriesUPDATE
Sheets("Sundries").Select
Sheets("Sundries").Copy After:=Workbooks( _
"CURRENT CAN West - Price List.xlsm").Sheets(9)
FYI - Windows 10 - Excel 2010 V14.something or other.
"CURRENT CAN West - Price List.xlsm" = New Master
"CURRENT CAN West - Sundries.xlsm" = Needs to be copy and pasted into new Master
"SundriesUPDATE" = update script in Sundires.xlsm file
M
Bookmarks