Previous Topic Next Topic

Excel macro to open another application

Closed
unos - 23 Mar 2010 à 06:26
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 24 Mar 2010 à 05:45
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.
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
23 Mar 2010 à 15:37
use shell command like

taskID = Shell("excel.exe ""C:\Users\haadi\Downloads\WO sample.xlsm""", 3)
unos
24 Mar 2010 à 00:16
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
24 Mar 2010 à 05:45
depends on how application is written. You can pass the parameters to the application as you launch it

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses