Open Lotus Notes with Excel Macro

S

Steve

I can open Lotus Notes with
Shell ("C:\Temp\Batch\LotusNotes.bat") which runs the following
C:\Lotus\Notes\notes.exe "=%userprofile%\application data\notes\notes.ini"

Is there a way to pass it my password from within excel vb or in the batch
file? I'm trying to update an excel spreadsheet overnight as it is a long
process but can't seem to pass it the password.
 
S

Sheeloo

This is really a Lotus Notes question...

/UserID-youruserid
/Password-yourpassword

If it works then you can add these switches from your VBA at the time of
calling the batch file...
 
B

Bill Sharpe

Sheeloo said:
This is really a Lotus Notes question...

/UserID-youruserid
/Password-yourpassword

If it works then you can add these switches from your VBA at the time of
calling the batch file...

SendKeys in VBA?

Bill
 
S

Steve

Thanks Bill
Finally got the chance to play with it and managed to get it to work fine.
Thanks again for the suggestion.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top