View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] aidan.heritage@virgin.net[_2_] is offline
external usenet poster
 
Posts: 17
Default Selecting Different Workbook

IF the macro just updates the data on wb2, then why not simply open the
wb2 file (with Master being already open) then select the macro from
the macros list and run it - if it is set up to run on the active
workbook, it will run on wb2 as this was active when the macro was
called!