Opening Excel from VBA

[Anonymous]

I am attempting to open Excel and load a spreadsheet that already exists at a predefined location. I don't want to make Excel visible, however. I just need to open this spreadsheet up and use normal methods for stripping data from the cells.

I know how to get the data from the spreadsheet if Excel is already open at runtime. However, I don't want Excel to be open at runtime. Rather I think I need to ise the "CreateObject" or "GetObject" to open Excel with a spreadsheet already loaded. How is this done?

Thanks for any help...

[Anonymous]

dim Excelapp as Excel.application
on error resume next
set Excelapp = GetObject(, "Excel.Application")
if err.number > 0 then
set Excelapp = CreateObject("Excel.Application")
end if

--
|
-+-------------------------------------------------
| Rob Starz
| Stardsign cad solutions
| AEC Designer / Consultant / Developer
| iC - AEC Information Center
| www.stardsign.com/aecic.html
| "can we make it any easier?!"

[Anonymous]

Rob, the code you displayed is what i'm using. However, no spreadsheet has been loaded. I need to load a specific spreadsheet into Excel so I can strip data from the cells for use in an AutoLISP program.....

[Anonymous]

Excelapp.Workbooks.Open "c:\MyFile.xls"

-- Walter -- http://www.ActiveDwg.com



"David_Lister" wrote in message
news:f0aa8d6.1@WebX.maYIadrTaRb...
> Rob, the code you displayed is what i'm using. However, no spreadsheet has
been loaded. I need to load a specific spreadsheet into Excel so I can strip
data from the cells for use in an AutoLISP program.....
>
>

[Anonymous]

Thanks Rob and Walter. Just curious though... ...I know that the Excel spreadsheet is opened and I have been able to acquire data from it easily, and this is how I want it to function. However, for troubleshooting purposes, is it possible to actually make the Excel Application visible (onscreen) during program execution. I tried using "Excelapp.Visible" (based on the above example) but this apparently gives me a compile error: Invalid use of property. Strange, I have used it before with no problems. Any ideas?

[Anonymous]

...sorry, let me answer my own question :

Excelapp.Application.Visible = True

[Anonymous]

Did you try it like this:

Excelapp.Visible = True

-- Walter -- http://www.ActiveDwg.com

[Anonymous]

Walter Wrote:

>Did you try it like this:
>Excelapp.Visible = True


No, I forgot the "= true" part. This method works as well. Thanks.



[Lisp programmer trying to give VBA a chance 🙂 ]