Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
manipulating text file from excel via vba
Hello!
I am trying to add two columns of a Excel data to a text file with a macro. The text file contains two columns: one with month/year and the other with interest rates. The Excel data is just a column of interest rates (360 periods).I want to add those interest rates to the end of the text file in the interest rate column and then add dates int he other column. I've tried to open the text file in Excel and then change it, but that complicates things because the date formats don't transfer correctly. I guess an alternative if anyone could help me would be to put entries in as strings. But then how do I make sure the entries get added at the end of the columns? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manipulating ranges in a different file | Links and Linking in Excel | |||
Manipulating ranges in a different excel file | Excel Worksheet Functions | |||
Help with manipulating text in Excel 2003 | Excel Discussion (Misc queries) | |||
Manipulating Text File | Excel Programming | |||
Manipulating text file data | Excel Programming |