I have a macro which when SS is run first time on a coworker computer it installs two folders and creates a desktop shortcut of the folders and of the Excel workbook. This works fine if the SS is an XLSM, but if it is a template, XLTM when first opens it does the folder shortcuts well, but the SS shortcut is not correct. Is there a way to do this?
Thanks!
Not really, you'll need to save the template being blank, then put the shortcut to that. I think
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Perhaps your code needs to be updated to only create those folders and shortcuts after the workbook itself has been saved? This simple test on the ActiveWorkbook.FullName shows how to detect the existence of the .xlsm extension. Newly opened new workbooks don't have that until after you've saved it once. Can you adapt this?
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Might be onto something? Do I put this in at the start of the sub which does the creating of folders, etc? Thanks.Originally Posted by JBeaucaire
Perhaps your code needs to be updated to only create those folders and shortcuts after the workbook itself has been saved? This simple test on the ActiveWorkbook.FullName shows how to detect the existence of the .xlsm extension. Newly opened new workbooks don't have that until after you've saved it once. Can you adapt this?
Please Login or Register to view this content.
Tried it at the beginning of the sub and got an error in this line, MkDir "C:B620_signed", which I did not before adding your script. What I cannot figure out is when I open a regular Excel, the shortcut properties point to where the program originate, whereas when I run the same macro from a template, the shortcut target location is desktop! Weird?
Last edited by thecdnmole; 09-27-2014 at 08:51 AM.
Upon further research I have found that when you open a template, what is actually opening is a regular spreadsheet, which would explain why the shortcut and link is for that instead of the template! Now my question is, how do I instruct the macro to make a shortcut of the excel file, which is a template and then save that shortcut to the desktop. This is slightly different than what I was doing by making a shortcut of the workbook that was opened. Any help would be appreciated! Thanks!!
I'm confused. IF you open a template it usually opens a new workbook with no name yet. So my belief is your macro should do nothing yet. Then, when you save the workbook for the first time and name/location for the new workbook finally does exist, THEN you would create the folder/shortcut. Am I missing something?
The creation of shortcuts is done upon opening the spreadsheet. Would it work better if I did it when closing? I found this macro on the internet and it more or less work, just doesn't put anything in the cell "start in" in the shortcut properties.
Is there code I can put in to populate that in the link properties?Please Login or Register to view this content.
desktop_link.JPG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks