Hi all
How to copy and paste 2 wbs from 2 locations into one then run macro 1 then auto save the combine wb into the same folder with wb1 , same name as wb1 but add specific text1 and time stamp at the end & (.csv )
After that, the macro will automatically redo copy and paste 2 wbs above into 1wb again then run macro 2 then auto save the combine wb into the same location with wb1 , same name as wb1 but add specific text 2 and time stamp at the end & (.csv)
Note: wb2 is always located at same path D:\Inspect folder\”inspectfile”.csv
To open inspectfile wb2 above , we have to open wb1 , go to cell A1 , get the text in cell A1 ( always in cell A1) then go to folder of wb2 (D:\Inspect folder\... ) and look for the inspecfile which has exactly name as text in cell A1 above to open
Thank so much for your help ,
Mark
How to copy and paste 2 wbs from 2 locations into one then run macro 1 then auto save the combine wb into the same folder with wb1 , same name as wb1 but add specific text1 and time stamp at the end & (.csv )
After that, the macro will automatically redo copy and paste 2 wbs above into 1wb again then run macro 2 then auto save the combine wb into the same location with wb1 , same name as wb1 but add specific text 2 and time stamp at the end & (.csv)
Note: wb2 is always located at same path D:\Inspect folder\”inspectfile”.csv
To open inspectfile wb2 above , we have to open wb1 , go to cell A1 , get the text in cell A1 ( always in cell A1) then go to folder of wb2 (D:\Inspect folder\... ) and look for the inspecfile which has exactly name as text in cell A1 above to open
Thank so much for your help ,
Mark
