Why are you using GetObject in the first place?

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Mon, 5 Oct 2009 13:24:02 -0700, Edward
wrote:

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.