Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
use GetObject to start an instance of Excel. Assume you return the
reference to xlapp set xlWkBk = xlApp.Workbooks.open( Filename:="C:\Myfile.xls", Password:="ABCD") -- Regards, Tom Ogilvy wrote in message ... I'm using VB script (not VBA) to manipulate the excel file, that is why I need the GetObject procedure -----Original Message----- 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) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
GetObject-question | Excel Programming | |||
Controlling Reflection1 from Excel using getObject | Excel Programming | |||
Invoking Excel via Getobject(From Access) to invoke Excel Macro | Excel Programming | |||
Is there a better option than Getobject to access a .xls? | Excel Programming | |||
Excel Getobject error | Excel Programming |