Reading ranges and copying data from Excel when it is not open

[Colleyville Alan]

Is there a way in code to copy data out of an Excel file even if Excel is
not up and running? If Excel were open, I'd copy, say, the first 30 rows
and paste the info to PowerPoint. Then, since rows 1-5 are for column
headings, I'd hide rows 6-30 and copy a new range which would look involve
30 rows, but since rows 6-30 were hidden would be 1-5 and then 31-55 as a
contiguous block.

I am trying to do this in VBA without opening Excel and instatiating
objects, etc. Is it possible? What VBA commands would I use?

 

[Tom Ogilvy]

You would need to treat the excel file as a database and use ADO to get your
data.

http://www.erlandsendata.no/english/vba/adodao/index.php

should give you some sample code.

 

[Colleyville Alan]

Thanks for the reply, but I have the data already. In fact, I am writing
the data from Access to an Excel workbook without ever opening Excel. I
need to use the CopyPicture method to create an enhanced metafile so that I
can paste it to PPT with formatting intact (the worksheet is too big to
embed in Excel). I can open Excel to do this, but I'd like to skip that
step. Is there a way to do this?

 

[Tom Ogilvy]

No.

--
Regards,
Tom Ogilvy

Thanks for the reply, but I have the data already. In fact, I am writing
the data from Access to an Excel workbook without ever opening Excel. I
need to use the CopyPicture method to create an enhanced metafile so that I
can paste it to PPT with formatting intact (the worksheet is too big to
embed in Excel). I can open Excel to do this, but I'd like to skip that
step. Is there a way to do this?


as

 

[Colleyville Alan]

Thanks.

No.

--
Regards,
Tom Ogilvy

that