Can I create a explorer link to my excel spread sheet while still in excel ?

What I do now ( with every spread sheet I create

Save it under a name
find it in explorer
create a short cut
copy the short cut to my task bar.


What I want to do is:
while in the excel spreadsheet, create a shortcut to my task bar.

Just so you know, I create the short cut, use it and after I submit the spread sheet, I delete the link from my task bar but keep the spread sheet.  The link means " please finish this sheet :

thx
TIMFOX123Asked:
Who is Participating?
 
SiddharthRoutCommented:
I believe that the path of 'Quick Launch' is similar to this

C:\Documents and Settings\[USERNAME]\Application Data\Microsoft\Internet Explorer\Quick Launch.

I am in Vista right now so I cannot test it.

Try replacing

Line 12 in the above code
ShortCutPath = "Desktop"

with that path.

Sid
0
 
SiddharthRoutCommented:
I can can help you create a shortcut to your file from Excel itself on the desktop if that will help which you can then move to taskbar?

Sid
0
 
SiddharthRoutCommented:
Paste this macro in a module.

Now when you run it, it will create a shortcut of the current Excel file on the desktop :)

Hope this helps.

Option Explicit

Sub CreateShortCut()
    '~~> This will Create a ShortCut of your current workbook in our desktop
    '~~> Please ensure that the workbook is saved as a precautionary measure
    Dim VbsObj As Object, MyShortcut As Object
    Dim TargetPath As String, ShortCutPath As String, ShortCutname As String
    
    Set VbsObj = CreateObject("WScript.Shell")

    TargetPath = ActiveWorkbook.FullName
    ShortCutPath = "Desktop"
    ShortCutname = ActiveWorkbook.Name
    ShortCutPath = VbsObj.SpecialFolders(ShortCutPath)
    
    Set MyShortcut = VbsObj.CreateShortCut(ShortCutPath & "\" & ShortCutname & ".lnk")
    MyShortcut.TargetPath = TargetPath
    MyShortcut.Save
End Sub

Open in new window


Sid
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
SiddharthRoutCommented:
Could you confirm which OS are you using? Let me try the above with the taskbar as well :)

Sid
0
 
TIMFOX123Author Commented:
xp

0
 
SiddharthRoutCommented:
Ok. Just so that my understanding is clear, you want to place the shortcut in the 'Quick Launch' in the taskbar?

Sid
0
 
TIMFOX123Author Commented:
Yes

thank you
0
 
TIMFOX123Author Commented:
Great job !!

thx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.