[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2011-04-20
8
Medium Priority
?
200 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
0
Comment
Question by:TIMFOX123
  • 5
  • 3
8 Comments
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35435712
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
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35435767
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
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35435795
Could you confirm which OS are you using? Let me try the above with the taskbar as well :)

Sid
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:TIMFOX123
ID: 35437002
xp

0
 
LVL 30

Expert Comment

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

Sid
0
 

Author Comment

by:TIMFOX123
ID: 35437802
Yes

thank you
0
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 2000 total points
ID: 35437850
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
 

Author Closing Comment

by:TIMFOX123
ID: 35440148
Great job !!

thx
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question