Can Excel Macro DoubleClick Icon?

A

Al

is it possible for an Excel Macro to doubleclick an icon
{or shortcut} located on my Desktop?

When doubleclicked, the icon initiates a monarch process
which transfers information from a mainframe download
format to an excel spreadsheet.

Thanks in advance.
 
F

Frank Kabel

Hi
instead of this (I doubt this is possible) you could use the SHELL
method to start a different program
 
A

Al

Thanks Frank. Could you please give me an example of
shell code that would start a different program?
 
F

Frank Kabel

Hi
just have a look at the VBA help for the shell command. It includes an
example
 
Top