import from excel worksheet straight to table

[pb21]

I have written some code that scans a worksheet, populates an array and then i scan the array and populate a table with the data. I s it possible to put the data
straight into the table?

I wasnt sure how to do that.

ideas would be appreciated.

regards

 

[Bat17]

if you have a table in XL then you can use Transferspreadsheet to get the data. look in help for the syntax.

Peter