How do I open a specific worksheet using windows exp...

V

vertblancrouge

We use a home software at work to manage our shop maintenance actions and
sometimes, we attach an excel workbook to compile data. We can also print the
Excel workbook automatically when we print the desired maintenance action. It
then prints the workbook in it's last configuration (most of the time, the
wrong worksheet).

I want to add a command to the link in the home software so that the Excel
workbook always opens on the correct worksheet. The links in the home
software act exactly the same as if you type an address in windows explorer.

More precisely I want to open the worksheet "Data" when opening this link:
H:\Maintenance\Maintenance\MP2 attachment\gearpump bearings lub.xls

If this is not possible, can I configure this particular workbook to always
open on the desired worksheet?

We use Excel 2003 and Windows XP.

Thank you very much.
 
V

vertblancrouge

I found it more efficient to add a event when I open de workbook:

Private Sub Workbook_Open()
Sheets("Data").Select
End Sub


The event you proposed me was a little annoying. When I was working on a
worksheet different then the Data one, it would switch to that one every time
I saved. I still want to say thanks for making me discover the events in
excel. It sure gonna help!
 
V

vertblancrouge

I also find out that I can write the linki as:

gear pump bearings.xls#Data!A1
"Data" being the worksheet I want to open. I have to specify a cell
otherwise the link doesn't work.
 
Top