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
|