Export Tables To Excel Spreadsheet

[HaydenMB]

Hi,

I am trying to create a new routine that creates a new excel workbook and then copies three tables into three different worksheets in the same workbook.

The only problem is that I cannot change to other worksheets. I have created the code to open and create the workbook and copy the data but I cannot change the worksheet to allow me to copy the other data into it. also is there a way (I know there is) to rename the worksheet?

Many Thanks,
Hayden

 

[DougP]

maybe a look at your code would be nice

DougP, MCP

 

[oharab]

To select another worksheet:

I assume you have a variable WB set to the open book-

WB.sheets("Sheet2&quot.select

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------