Open Lotus Notes with Excel Macro

  • Thread starter Thread starter Steve
  • Start date Start date
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.
 
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...
 
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...
Click to expand...

SendKeys in VBA?

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