trystanhuwwilliams1
Programmer
Hi,
Don't know if this is possible, but here goes..
I want to open password protected Excel Workbooks from
an Access Form via the code below.
This works except that it won't allow a password to be entered in the code. Does anyone know is this can be done?
Also, I found a strange phenomenon which occurred whilst I was experimenting in this area. When I added the Microsoft Excel 9.0 Object Library to the VBA Access references, and then used the following code:
I found that this opened the Workbook virtually. I could access data using cell references etc without being able to physically see the workbook.
Could be useful to someone, I don't know.
Regards,
Trystan
Don't know if this is possible, but here goes..
I want to open password protected Excel Workbooks from
an Access Form via the code below.
Code:
strPath = "Dir\Path" & "\" & rs("file").Value
Application.FollowHyperlink strPath, , True, False
This works except that it won't allow a password to be entered in the code. Does anyone know is this can be done?
Also, I found a strange phenomenon which occurred whilst I was experimenting in this area. When I added the Microsoft Excel 9.0 Object Library to the VBA Access references, and then used the following code:
Code:
Workbooks.Open (strPath), , , , "password"
I found that this opened the Workbook virtually. I could access data using cell references etc without being able to physically see the workbook.
Could be useful to someone, I don't know.
Regards,
Trystan