Importing a Excel file with password

C

CAM

Hello,

Thanks, to a gentlemen named Fred who helped me out earlier on
DoCmd.TransferSpreadsheet I was able to import data, but now I have an Excel
file that has a password. I know how to do a DoCmd.TransferSpreadsheet,
but I don't know how to code it so the password is read and the data gets
imported. Any tips or visit a website will be appreciated. Thank you in
advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Importing from Excel into Access 0
Create password protected spreadsheet with access 2
Delete old information when transferring to excel 6
Import Excel named range into Access 2
Excel Multiple Worksheets - TransferSpreadsheet VBA 0
VBA for Access, import Excell files into Access tables 5
Transferspreadsheet to import excel file with different column 5
Excel file is locked after Import 4

Top