Is there a method call that will load a .csv data table in a Excel workbook
template where that template will already contain code to manipulate data?

The Workbooks.OpenText does a good job of formatting but creates an
arbitrary workbook. Is there a way to force it to use a particular template
when it creates the workbook?

The only way i can think of is to use Workbooks.Add (WorkBookTemplate), and
then have a macro on one of the sheets to read line by line the .csv file and
populate the data in a formatted way.

Any suggestsions?
Thanks!

I think the Opentext method followed by a copy/paste is pretty
straightforward. Of course reading in a line at a time is viable too. The
only other option to read data directly into a worksheet is the Data, Import
External Data command (as it's called in Excel 2002 and 2003; Get External
Data in 2000). You might have a look at that.

Jim

--
Jim Rech
Excel MVP
"Bing" wrote in message
...
Is there a method call that will load a .csv data table in a Excel
workbook
template where that template will already contain code to manipulate data?

The Workbooks.OpenText does a good job of formatting but creates an
arbitrary workbook. Is there a way to force it to use a particular
template
when it creates the workbook?

The only way i can think of is to use Workbooks.Add (WorkBookTemplate),
and
then have a macro on one of the sheets to read line by line the .csv file
and
populate the data in a formatted way.

Any suggestsions?
Thanks!