how to create programmatically a table?
 

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

how to create programmatically a table?
 

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" wrote in message
...
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

how to create programmatically a table?
 

Thanks, i'll try

"NickHK" schreef in bericht
...
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" wrote in message
...
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