Insert csv data into polished xls file

[ob2s]

Sorry for the noob question, but I have a program that creates csv data.
My collegue has made a wiz-bang spreadsheet with colors and titles (but
no formulas) that this data goes into. I need to figure out how I can
programmatically take the raw csv data and 'stick' it into the finished
XLS file or how to create the finished XLS file. Is there a template
function, or do i need a macro ?
Thanks

 

[David Biddulph]

Sorry for the noob question, but I have a program that creates csv data.
My collegue has made a wiz-bang spreadsheet with colors and titles (but
no formulas) that this data goes into. I need to figure out how I can
programmatically take the raw csv data and 'stick' it into the finished
XLS file or how to create the finished XLS file. Is there a template
function, or do i need a macro ?

Read the csv file, copy the data, & Paste Special/ Values into the formatted
XLS.

 

[ob2s]

that sounds like how you do it by hand. can i do it programmatically

 

[Dave Peterson]

How about if you record a macro when you do it manually?

You may end up with code that works fine. If you don't post back with your more
specific questions.