If you are using Access, why use GetObject ?
Can you not use Automation or ADO/SQL to get the data ? Then methods for
supplying passwords etc are included.

NickHK

"dhiman" wrote in message
ups.com...
Hi Joel,

I tried doing it but even before opening the excel by using .open ; i
need to do getobject() to get a handle of the excel, it is asking for
the password then itself!! how do i get the handle of the excel??

please could you put in some more code??

Thx ..