Opening excel file on certain worksheet?

**Sin** · 01-04-2010, 02:49 PM

Hello friends.
First of all I would like to wish happy new year to everyone!
Now I will go straight ahead to my problem, and hopefully find someone who will be able to help me.

I have huge excel file with 30 worksheets in it, which is linked into autocads drawing.
That drawing has 30 specific spots(or links) and every time you click on certan one it should open its own worksheet within excel file.

Now can someone pls tell me the way how to tell excel which worksheet to open?
Is there any wildcard or some other way which will allow me to achomplish that?

Best regards

Sin

**JBeaucaire** · 01-04-2010, 03:58 PM

Press F1 in Excel and type HYPERLINK into the search box to bring up Excel's tutorial on using the HYPERLINK() function.

**Sin** · 01-04-2010, 04:33 PM

THx for the reply.
Hyperlink function seems to work within the excel, but what I need is something, that would open excel file on certain worksheet but function would be called outside of excel.
I need something like this : C:\\desktop\test.xls -[wildcard that would tell which sheet to open].
I hope you got the point, what I am talkin about?

**JBeaucaire** · 01-04-2010, 04:52 PM

1) Highlight a cell or a range of cells on a worksheet
2) Press CTRL-C to copy into memory
3) Minimize everything
4) Right-click on the Desktop and select PASTE SHORTCUT
5) Go back and close your document
6) Close Excel

7) Now double-click your new desktop shortcut and it should open the doc to the correct spot