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)
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?
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses