Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert csv data into polished xls file
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 ------------------------------------------------------------------------ ob2s's Profile: http://www.excelforum.com/member.php...o&userid=35031 View this thread: http://www.excelforum.com/showthread...hreadid=547749 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert csv data into polished xls file
"ob2s" wrote in message
... 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. -- David Biddulph |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert csv data into polished xls file
that sounds like how you do it by hand. can i do it programmatically ? -- ob2s ------------------------------------------------------------------------ ob2s's Profile: http://www.excelforum.com/member.php...o&userid=35031 View this thread: http://www.excelforum.com/showthread...hreadid=547749 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert csv data into polished xls file
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. ob2s wrote: that sounds like how you do it by hand. can i do it programmatically ? -- ob2s ------------------------------------------------------------------------ ob2s's Profile: http://www.excelforum.com/member.php...o&userid=35031 View this thread: http://www.excelforum.com/showthread...hreadid=547749 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
Analyze & Filter data in a notepad file | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
no data in excel file | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |