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

  • Thread starter Thread starter Colleyville Alan
  • Start date Start date
C

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?
 
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?
 
No.

--
Regards,
Tom Ogilvy

Colleyville Alan said:
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
Click to expand...
 
Back
Top