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!