If you open your "gearpump bearings lub.xls", you could select the worksheet in
code:

option explicit
sub auto_open
application.goto worksheets("sheet1").range("a1"),scroll:=true
end sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

vertblancrouge wrote:

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.

--

Dave Peterson