Thread: Open excel file and reffer to specific worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arne Hegefors Arne Hegefors is offline
external usenet poster
  
Posts: 244
Default Open excel file and reffer to specific worksheet
Hi! I have a macro that opens an excel file and activates it. How do I get it
to start at a certain worksheet?

Workbooks.Open "X:\SCD_RiskManager_Pos\RMDBII\test.xls" 'open file
Workbooks("test.xls").Activate 'ACTIVATE FILE
Reply With QuoteReply With Quote