LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Manipulating ranges in a different file Lenchik Links and Linking in Excel 2 October 18th 08 04:01 AM
Manipulating ranges in a different excel file Lenchik Excel Worksheet Functions 3 October 13th 08 03:51 AM
Help with manipulating text in Excel 2003 Big UT Fan Excel Discussion (Misc queries) 4 April 9th 08 07:33 PM
Manipulating Text File Edmund Excel Programming 3 July 5th 06 01:44 PM
Manipulating text file data Kingdbag Excel Programming 3 February 24th 06 02:38 PM


All times are GMT +1. The time now is 05:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"