how to create programmatically a table?

[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

 

[NickHK]

You need to use SQL statements ?
If so you will need to use ADO or DAO, although I have not use these types
of SQL on Excel, but I suppose it should work.

But you say this is written in Excel.
So why not just :
Dim NewWS as worksheet
set newws=ThisWorkbook.Worksheets.Add
newws.range("A1").value="New data"

But depends what you mean by a "table" ?

NickHK

 

[Britt]

Thanks, i'll try

You need to use SQL statements ?
If so you will need to use ADO or DAO, although I have not use these types
of SQL on Excel, but I suppose it should work.

But you say this is written in Excel.
So why not just :
Dim NewWS as worksheet
set newws=ThisWorkbook.Worksheets.Add
newws.range("A1").value="New data"

But depends what you mean by a "table" ?

NickHK