how to create a table programmatically in excel?

[Britt]

Hi,

I want to create a table programmatically in excel. How can o do this
("create table ....")??
And then, how to put it in specific cells in the worksheet, and possibly
put it into sheet2 of the same worksheet?

Thanks for gelp
Britt

 

[Scott M.]

You don't need to make a table in Excel because Excel worksheets are nothing
but giant tables already.

What you need to do is simply place the data you want in the cells you want.
You do this via the Excel Object Model.

Try an Excel VBA newsgroup.

 

[Paul Clement]

¤ Hi,
¤
¤ I want to create a table programmatically in excel. How can o do this
¤ ("create table ....")??
¤ And then, how to put it in specific cells in the worksheet, and possibly
¤ put it into sheet2 of the same worksheet?

Yes, with some limitations you can use Jet SQL:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp

For working with Excel and ADO.NET see the following:

How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET
http://support.microsoft.com/kb/316934


Paul
~~~~
Microsoft MVP (Visual Basic)