Open Lotus Notes with Excel Macro

[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.

 

[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...

 

[Bill Sharpe]

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

 

[Steve]

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