Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Discretely open workbook with password?
Hello,
I'm using Excel/Access 2003. I have an Access form that will transfer Excel spreadsheets into Access using TransferSpreadsheet. The Excel spreadsheet I need to import is password protected, and I have the password. Does anyone know what the code would look like that would open the workbook, using the password I already have, so that I can successfully transfer the spreadsheet into Access without any sort of manual prompt for a password? I have tried simply transfering a protected workbook and it's not taking. So I'm assuming I must first open the workbook before I can transfer. Suggestions are welcome! Thanks, -Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Discretely open workbook with password?
While password to modify is not set, this works for me:
Sub Openpwddbook() Workbooks.Open Filename:="e:\book5.xls", Password:="123" End Sub -- Regards, Halim "scottydel" wrote: Hello, I'm using Excel/Access 2003. I have an Access form that will transfer Excel spreadsheets into Access using TransferSpreadsheet. The Excel spreadsheet I need to import is password protected, and I have the password. Does anyone know what the code would look like that would open the workbook, using the password I already have, so that I can successfully transfer the spreadsheet into Access without any sort of manual prompt for a password? I have tried simply transfering a protected workbook and it's not taking. So I'm assuming I must first open the workbook before I can transfer. Suggestions are welcome! Thanks, -Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password to open workbook | Excel Discussion (Misc queries) | |||
I know my password, yet it will not open my workbook | Excel Worksheet Functions | |||
need to open my workbook not asking for password so i can do so | Excel Discussion (Misc queries) | |||
Open workbook with password in VBA | Excel Programming | |||
Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming |