Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open Lotus Notes with Excel Macro
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open Lotus Notes with Excel Macro
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... "Steve" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open Lotus Notes with Excel Macro
Sheeloo wrote:
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... "Steve" wrote: 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. SendKeys in VBA? Bill |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open Lotus Notes with Excel Macro
Thanks Bill
Finally got the chance to play with it and managed to get it to work fine. Thanks again for the suggestion. "Bill Sharpe" wrote: Sheeloo wrote: 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... "Steve" wrote: 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. SendKeys in VBA? Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lotus Notes - Unable to Copy Paste Special in macro | Excel Worksheet Functions | |||
open lotus notes | Excel Worksheet Functions | |||
Get Data from Lotus Notes Database into Excel | Excel Discussion (Misc queries) | |||
Has anyone sent emails from Excel via Lotus Notes? | Excel Discussion (Misc queries) | |||
Lotus Notes Doc LINK in Excel??? | Excel Discussion (Misc queries) |