Export to a range of cells in Excel

[WelshyWizard]

Hi all,

I'm looking to export 3 tables into the same excel spreadsheet. Ideally I would like each table on a seperate worksheet but if I had to have them all on one I would settle for that.

I know I could export them to three seperate spreadsheets and use a macro to combine them in Excel but I didn't really want to.

Anyone got any idea if this is possible? I can't find any tips anywhere.

Cheers.

Today is the tomorrow you worried about yesterday - and all is well.....

 

[jlockley]

You want each of three tables to export into a distinct worksheet in the same Excel file, I think.
These tables do or do not have the same format? Are they linked?
Is this a one time exercise, or do you have to write a script to export them repeatedly?

The simplest way to do this is probably just to export each into a separate excel file and cut and paste them into a common file.

 

[TonyMcGuire]

Working with Excel spreadsheets?

You might want to look at Vladimir's library for that.

http://cust.east.ru/~menkin/excel.htm

Since it uses OLEAuto, you need Excel.

Tony McGuire

http://www.wjcitycouncil.com

"It's not about having enough time; we have the rest of our lives. It's about priorities.