Thread: GetObject
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default GetObject

if you are using Excel VBA, use

Workbooks.open Filename:="C:\Myfile.xls", Password:="ABCD"

You don't need to use GetObject and that would be the long way to do it.

--
Regards,
Tom Ogilvy

"Michael" wrote in message
...
How can I use GetObject to open an Excel file that has
password protection without getting the Excel dialog popup
(I have the password and can supply it but GetObject
doesn't appear to accept any paramaters other than the
file name)