Can you embed a password with the "Call Shell" command when calling an Excel workbook that is password protected? I can use the "OpenWorkbooks" command and embed a password but I am experiencing problems with this retrieval method that I don't experience with "Call Shell".
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Calling Microsoft Excel Workbook From Visual Basic Within Access
- Thread starter JimA
- Start date
ComputorMike
MIS
Hi Jim
Workbooks.Open FileName:=MyExcelFullPath, UpdateLinks:=0, ReadOnly:=True, password:=MyPassword
Hope this helps
Mike
Workbooks.Open FileName:=MyExcelFullPath, UpdateLinks:=0, ReadOnly:=True, password:=MyPassword
Hope this helps
Mike
- Status
Similar threads
- Locked
- Question
- Locked
- Question
