dim myStr as string
myStr = "this is mine " & activesheet.range("a1").text & " and this is mine"

maybe???



Brett Smith wrote:

I know about the Print# and the Input# and the Input# functions for Excel
when moving information to a text file from a spreadsheet. But, how do I set
it up so that I can concatanate string text(my own text) with the fields
coming from the spreadsheet? It is not going to be a a delimited file but a
custom format file that I want to blend in with my own stringed text. Please
help. Thanks!

Brett

--

Dave Peterson