Hi,
I am reading data from a row in a excel and need to write it to a
preexisting template file at specified points/lines. Would this be
possible as I am not very familiar with VB.

Simplistically, let's say i read data from the columns (A-F) of row 1:

A B C D E F
X Y Z 1 2 3

and need to write x,y,z,1,2,3 to specified lines of a text file after
doing some formatting to it (preceding x,y,z with certain characters)

File:
[__Header__]
ProductName = "lala "
ProductVersion = 1.1
Version = 120
Type = "type"

PATH=\"C:\\PATHNAME\\XY.TXT\"

data
data

%NAME = \"X\"

data
data

DURATION=2

etc.


Many Thanks :)


--
pouk
------------------------------------------------------------------------
pouk's Profile: http://www.excelforum.com/member.php...o&userid=24961
View this thread: http://www.excelforum.com/showthread...hreadid=385179