Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default Open excel file and reffer to specific worksheet

Sheets("Sheet3").Select
--
Gary''s Student - gsnu200755
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
force excel workbook to open to a specific worksheet Wenster Excel Discussion (Misc queries) 1 June 24th 09 04:53 PM
Is there a way to open an excel file to a specific worksheet? Nicholas Excel Discussion (Misc queries) 1 December 5th 06 10:29 PM
Open an Excel file to a specific spreadsheet Fatmosh Excel Programming 6 January 26th 06 01:14 PM
How do you open a specific worksheet using an Excel Driver? Murphy Excel Programming 0 May 28th 04 11:12 PM
From HTML open a specific worksheet within a excel file esoller Excel Programming 2 May 18th 04 09:41 PM


All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"