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

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" <(E-Mail Removed)> wrote in message
news:uU%(E-Mail Removed)...
> 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
>
>
>

Thanks, i'll try

"NickHK" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:uU%(E-Mail Removed)...
>> 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
>>
>>
>>
>
>