We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

TIMFOX123
TIMFOX123 asked
on
Medium Priority
223 Views
Last Modified: 2012-05-11
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
Comment
Watch Question

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
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
Could you confirm which OS are you using? Let me try the above with the taskbar as well :)

Sid

Author

Commented:
xp

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

Sid

Author

Commented:
Yes

thank you
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Great job !!

thx
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.