Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getObject and password protected workbook
Hi everybody,
I use an Excel file as my database and because of the security reasons I want to make it protected , I have a second file that is shared among users and this second file reads some data from the first file I use Set appExcelData = GetObject(filePath) to reference the first file , but when I password protect it , it asks the users for the password , how can I reference the first file and read its data with giving the password somehwere in my code? I know if I use open there is a parameter for password but I don't want to open the file. -- Best regards, Edward |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
password protected workbook | Excel Worksheet Functions | |||
How To Get Into a Password Protected Workbook | Excel Programming | |||
GetObject with Password | Excel Programming | |||
Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) | |||
Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming |