| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro convert CSV -to- XLS without parsing line by line
Is there anyway I can import a "," delimited CSV file as a .XLS Workbook without parsing the CSV line-by-line? My CSV is a derivatives trading-data dump & has 4775 records per day with 14 columns of text, numeric & currency fields. I need to run this macro on 60 such CSV files everyday for 60day Moving Average securities analysis. TIA !! Regards, BR -- Manager, International Private Banking, International Banking Group, ICICI Bank East Wing 8th floor South, ICICI Towers, Bandra Kurla Complex, Mumbai India 400051 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro code to put series name next to individual line in line grap | Charts and Charting in Excel | |||
| Parsing line breaks into separate cells | Excel Discussion (Misc queries) | |||
| How do I convert a line chart to a vertical line chart in Excel | Charts and Charting in Excel | |||
| How to convert a dotted line to a solid line in a line graph | Charts and Charting in Excel | |||
| coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
Threaded Mode
