View Single Post
  #5   Report Post  
vertblancrouge
 
Posts: n/a
Default

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.

"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.