How to create a Windows Shortcut to a specific Worksheet?

[jrwpmw]

I can easily of course create a shortcut on my desktop to a Excel file.

I can also create a hyperlink to a specific worksheet in a workbook - by using: ....filename.xls#worksheetname

However, when I try to create a shortcut to a specifc worksheet, it doesn't work. It will open the Excel file but not open the specific worksheet. The problem is that the windows shortcut seems to try to read the #worksheetname as part of the file.

With the #worksheetname in the shortcut, windows says file not found, with it off the shortcut works fine.

Any ideas? All I want to do is create a shortcut that opens to a particular worksheet?

Thanks as always!

 

[UniMord]

I was looking for the same thing a few months ago, but got nowhere.

Look at this thread: http://www.mrexcel.com/forum/showthread.php?t=538609

 

[jrwpmw]

Thanks, that is the exact same problem. I don't have any special characters, just a Defined Name to a cell on the worksheet, like .....#ISSUELOG

That works fine in hyperlinks, just not in a windows XP shortcut.

I an running office 2003 on XP.

If anybody else has any ideas it would be appreciated!

Thanks!

I was looking for the same thing a few months ago, but got nowhere.

Look at this thread: http://www.mrexcel.com/forum/showthread.php?t=538609

 

[UniMord]

jrwpmw,

I've updated the original thread to my question (http://www.mrexcel.com/forum/showthread.php?t=538609), with the solution I've come up with. I hope it helps you.

 

[brettdj]

You could also use a simple vbs to automate an Excel instance opening to the selected file location

1)Put the following code into NotePad, save the file somewhere convenient with a file name ending in vbs.
ie
MyFile.vbs

Change you Excel File path and sheet/cell position to suit

Set objXl = CreateObject("Excel.Application")
Set ObjWB = objXl.Workbooks.Open("C:\test\testfile.xlsm")
objXl.Goto ObjWB.Sheets(2).Range("A1")
objXl.Visible = True

2) Create a new shortcut, then point it at the MyFile.vbs you just created

Cheers

Dave

 

[UniMord]

Thank you, that's a winning approach, and puts my convoluted efforts to shame. I had no idea that you could even do this with a VBS file.

The advantages of your script are, that since it doesn't require a VBA macro to run, I can use it with a .XLSX file, and send it to users who don't have macros enabled.

I'm theorizing (and hoping!) that it is still possible that there is a possible use for the VBA/CMD solution, in the case where WSH/VBS is disabled (not unusual).