|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
November 6th, 2003, 10:26 AM
|
|||
|
|||
|
Read a text file and copy data to excel in new column
I am trying to read a text file every half hour named Datacap.txt. It has 12 numbers all in a row in it. I would like to read that data and copy to a new column in a excel file named DC.xls every time I would run a batch file program. Could anyone help me on this? Thank you.
|
|
#2
November 7th, 2003, 06:44 AM
|
|||
|
|||
|
You can probably do most of the VBA code with the macro recorder. Using the recorder open the text file in excel and copy the contents and paste into the next empty COL in the target sheet. Now you have most of your code. All you have to do now is determine up front where the first empty COL is and modify the recorder code to paste in that COL.
Chuck
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Read a text file and copy data to excel in new column |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
