ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can Excel Macro DoubleClick Icon? (https://www.excelbanter.com/excel-programming/301036-can-excel-macro-doubleclick-icon.html)

AL

Can Excel Macro DoubleClick Icon?
 
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.

Frank Kabel

Can Excel Macro DoubleClick Icon?
 
Hi
instead of this (I doubt this is possible) you could use the SHELL
method to start a different program

--
Regards
Frank Kabel
Frankfurt, Germany


Al wrote:
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.



AL

Can Excel Macro DoubleClick Icon?
 
Thanks Frank. Could you please give me an example of
shell code that would start a different program?

-----Original Message-----
Hi
instead of this (I doubt this is possible) you could use

the SHELL
method to start a different program

--
Regards
Frank Kabel
Frankfurt, Germany


Al wrote:
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.


.


Frank Kabel

Can Excel Macro DoubleClick Icon?
 
Hi
just have a look at the VBA help for the shell command. It includes an
example

--
Regards
Frank Kabel
Frankfurt, Germany


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

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

--
Regards
Frank Kabel
Frankfurt, Germany


Al wrote:
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.


.




All times are GMT +1. The time now is 03:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com