View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew Ofthesong Andrew Ofthesong is offline
external usenet poster
 
Posts: 4
Default Name of workbook

Hi, if i have 2 open workbooks: wb1 and wb2, and i have a macro in wb2 named
"MacroOnWb2"

How can i make a reference to worbook wb2 independentlly if i',m running the
macro having wb1 as active workbook or wb2?

PD: supouse i perhaps rename the workbooks, so "workbooks("wb2")" is also
not the ebst idea...