Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start of macro via desktop icon no longer work
I start my Xl2007 application with an desktop icon.
The destination for the icon is the macro path e.g. c:\test\mymacro.xla. It worked for a long time. But after an unplanned crash it's not possible to start the application via desktop icon. When I try to start the program via icon I get the error message "can't find c:\program.xlsx". I've never created or heard about this file. If I open the application inside Excel (start Excel first) it runs. There is no change in the icon destination. I also tried to write the excel.exe path in front of the macro destination with no change. I have no idea what's the difference to open the xla within excel or to open it via icon. There is only Excel 2007 on the computer. OS is Vista. TIA Reinhard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start of macro via desktop icon no longer work
Have you tried adding double quotes?
"c:\test\mymacro.xla" But why are you using a shortcut to open an Add-in? Why not just start Excel and checkmark the Add-in so it is loaded automatically when Excel starts up? Gord Dibben MS Excel MVP On Fri, 23 Apr 2010 13:27:35 +0200, "Reinhard" wrote: I start my Xl2007 application with an desktop icon. The destination for the icon is the macro path e.g. c:\test\mymacro.xla. It worked for a long time. But after an unplanned crash it's not possible to start the application via desktop icon. When I try to start the program via icon I get the error message "can't find c:\program.xlsx". I've never created or heard about this file. If I open the application inside Excel (start Excel first) it runs. There is no change in the icon destination. I also tried to write the excel.exe path in front of the macro destination with no change. I have no idea what's the difference to open the xla within excel or to open it via icon. There is only Excel 2007 on the computer. OS is Vista. TIA Reinhard |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start of macro via desktop icon no longer work
Icon destination is ok, because it already run.
The *.xla is a complete application with its own GUI (ribbon bar). It's not the intention to start it with Excel, but as a independent application. The question is, how it is possible that the start icon suddenly losts its functionality with a strange error message. For sure the destination wasn't changed. Any idea? TIA Reinhard Have you tried adding double quotes? "c:\test\mymacro.xla" But why are you using a shortcut to open an Add-in? Why not just start Excel and checkmark the Add-in so it is loaded automatically when Excel starts up? Gord Dibben MS Excel MVP On Fri, 23 Apr 2010 13:27:35 +0200, "Reinhard" wrote: I start my Xl2007 application with an desktop icon. The destination for the icon is the macro path e.g. c:\test\mymacro.xla. It worked for a long time. But after an unplanned crash it's not possible to start the application via desktop icon. When I try to start the program via icon I get the error message "can't find c:\program.xlsx". I've never created or heard about this file. If I open the application inside Excel (start Excel first) it runs. There is no change in the icon destination. I also tried to write the excel.exe path in front of the macro destination with no change. I have no idea what's the difference to open the xla within excel or to open it via icon. There is only Excel 2007 on the computer. OS is Vista. TIA Reinhard |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start of macro via desktop icon no longer work
You've lost me with "It's not the intention to start it with Excel, but as a
independent application." Gord On Sat, 24 Apr 2010 08:55:20 +0200, "Reinhard" wrote: Icon destination is ok, because it already run. The *.xla is a complete application with its own GUI (ribbon bar). It's not the intention to start it with Excel, but as a independent application. The question is, how it is possible that the start icon suddenly losts its functionality with a strange error message. For sure the destination wasn't changed. Any idea? TIA Reinhard Have you tried adding double quotes? "c:\test\mymacro.xla" But why are you using a shortcut to open an Add-in? Why not just start Excel and checkmark the Add-in so it is loaded automatically when Excel starts up? Gord Dibben MS Excel MVP On Fri, 23 Apr 2010 13:27:35 +0200, "Reinhard" wrote: I start my Xl2007 application with an desktop icon. The destination for the icon is the macro path e.g. c:\test\mymacro.xla. It worked for a long time. But after an unplanned crash it's not possible to start the application via desktop icon. When I try to start the program via icon I get the error message "can't find c:\program.xlsx". I've never created or heard about this file. If I open the application inside Excel (start Excel first) it runs. There is no change in the icon destination. I also tried to write the excel.exe path in front of the macro destination with no change. I have no idea what's the difference to open the xla within excel or to open it via icon. There is only Excel 2007 on the computer. OS is Vista. TIA Reinhard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xl2003 why does 'rel. reference' icon not appear on macro start | Excel Programming | |||
Clicking Taskbar Icon will start macro | Excel Programming | |||
Executing a Macro From a Desktop Icon | Excel Programming | |||
Icon in menue to start macro | Excel Programming | |||
Running a macro from a desktop icon shortcut | Excel Programming |