Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
xl2003 why does 'rel. reference' icon not appear on macro start Derek Maggs Excel Programming 0 October 11th 06 05:17 AM
Clicking Taskbar Icon will start macro Kryer Excel Programming 0 January 17th 06 02:40 AM
Executing a Macro From a Desktop Icon SidBord Excel Programming 1 April 25th 04 07:19 AM
Icon in menue to start macro Arne Lindberg Excel Programming 1 November 29th 03 10:39 PM
Running a macro from a desktop icon shortcut Sofia Excel Programming 2 July 15th 03 08:01 PM


All times are GMT +1. The time now is 11:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"