topic Re: GetObject command in VBA Forum

GetObject command

Anonymous — Fri, 26 May 2000 18:22:05 GMT

I am trying to use the following command to retrieve the currently active
Excel workbook.
Set ExcelServer = GetObject(, "Excel.Application")
ExcelServer.WindowState = XlWindowState.xlMinimized

According to the help file: "If the pathname argument is omitted, GetObject
returns a currently active object of the specified type" I find that if I
have an instance of Excel running and I execute the command it returns an
empty excel window, but not the current workbook, which is what I want.

What am i missing?

Re: GetObject command

Anonymous — Fri, 26 May 2000 18:34:04 GMT

Getting the aplication doesn't necessarily get you the document. GetObject(,
"AutoCAD.Application") won't yield the active document in a running instance
of AutoCAD. See if you can use the ActiveWorkbook property to get your
document reference.

--
Visit AcadXtreme for a chance to win a copy of AutoCAD LT 2000
Contest ends 5/26/00
http://www.acadx.com

"John Wilde" wrote in message
news:ef1cfbe.-1@WebX.SaUCah8kaAW...
> I am trying to use the following command to retrieve the currently active
> Excel workbook.
> Set ExcelServer = GetObject(, "Excel.Application")
> ExcelServer.WindowState = XlWindowState.xlMinimized
>
> According to the help file: "If the pathname argument is omitted,
GetObject
> returns a currently active object of the specified type" I find that if I
> have an instance of Excel running and I execute the command it returns an
> empty excel window, but not the current workbook, which is what I want.
>
> What am i missing?
>

Re: GetObject command

Anonymous — Fri, 26 May 2000 19:02:22 GMT

This works for me

'Set oExcelBook = oExcelApp.Workbooks.Add
Set oExcelSheet = oExcelApp.ActiveWorkbook.Sheets("Sheet1")

Gary