Insert csv data into polished xls file

  • Thread starter Thread starter ob2s
  • Start date Start date
O

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
 
ob2s said:
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 ?
Click to expand...

Read the csv file, copy the data, & Paste Special/ Values into the formatted
XLS.
 
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.
 
Back
Top