Hi All,
New user here. I routinely create input files (.txt format) for a hydrology program written in fortran, and I was wondering if how difficult it would be to create VBA code that would automate that process, bearing in mind that I know almost nothing about VBA. I have some background in C++, but nothing too extensive. Essentially, I want the program to read multiple rows in excel, then extract data from multiple cells in each row and insert the data into multiple lines of text at specified locations (see example below). My guess is that someone has already done something similar, and I was wondering if anyone had a "goby" for code that I could edit for my particular purposes. I tried to search the forums (keywords: create .txt file), but I’m not sure if there are keywords more appropriate. Any help would be greatly appreciated.

Data to be read from .xls file:
[A1] [B1] [C1] [D1] [E1] [F1] [G1]
400 0.003 0.7 0.200 0.3942 SB100 0.211

Output to .txt file:
"COMPUTE LT TP LCODE=1 UPLAND/LAG TIME TRANSITION METHOD
LENGTH=[A1] FT SLOPE=[B1] K=[C1]
Kn=[D1] CR=[E1]
COMPUTE NM HYD ID=1 HYD NO=[F1] DA=[G1] SQ MI
PER A=50 PER B=30 PER C=15 PER D=5
TP=0.0 MASSRAIN=-1"