Not sure if this is even possible but I have a macro that is stored in my personal macro workbook (Personal.XLSB). This macro opens a file and checks a few things and does a little formatting and then I am good to start using it. I have a little icon for it it on my ribbon, that is where I usually launch it from.
My only complaint is having to open up excel and choose a blank workbook before I can launch my macro. I considered changing the start up options but I like them the way they are except for this one file. I was wondering if I could launch a macro from a shortcut. I was able to create this shortcut, C:\Users\farrissf\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB, which once put in a shortcut and executed launches excel without a sheet and I can click my my icon on my ribbon and the file opens up and runs the macro.
You would think that I would be satisfied with that, but i wondered if there is a way launch excel and run the macro with one shortcut. I tried VBscripting but I could not get the syntax right, now I am wanting to make this shortcut work.
Here is what I have tried so far:
C:\Users\farrissf\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB!module2.open_topas
The macro is in module 2, the name of the sub is open_topas. Any ideas?
Bookmarks