Previous Topic Next Topic

Excel macro to open another application

Closed
unos - Mar 23, 2010 at 06:26 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 24, 2010 at 05:45 AM
hi experts,

I want to make a macro that open another application.

This application is having login module.
So is it possible that I store username and password in code.
And while run the macro it automatically open that application and login into that.

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 23, 2010 at 03:37 PM
use shell command like

taskID = Shell("excel.exe ""C:\Users\haadi\Downloads\WO sample.xlsm""", 3)
0
unos
Mar 24, 2010 at 12:16 AM
Thanks dear.

But my question is that my application is having login module. When I run application through shell function, it opens login window where I have to type username and password.

And my query is that whether I can store username and password in my code so that it will give username and password automatically and login to application?
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 24, 2010 at 05:45 AM
depends on how application is written. You can pass the parameters to the application as you launch it
0