I assume you are trying to Add querytables.

A good start would be to open excel and add the tables manually while you
have the macro recorder turned on.

Tools=Macro=Record a new macro

After getting the tables set up, turn off the macro recorder and look at the
code.

This will give you the syntax of what you want to do. You can then modify
it to refer to your application.object and related Excel objects in your
automation code.

--
Regards,
Tom Ogilvy


"Ritu Khattar" wrote in message
...
I am trying to create two tabels on the same worksheet in
MS Excel using automation. If i use only ODBC connection
than i am able to create two tabels like in a normal
database but i need to specify the worksheet i need the
tabel in and also the cell range for that tabel which is
not possible through ODBC connection.

I really need some help in this..I have never done this
kind of thing before with Excel.

Can anyone of you please help!!!!

Thanks and Regards
Ritu Khattar