Thread: Quick Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
N.F[_2_] N.F[_2_] is offline
external usenet poster
 
Posts: 65
Default Quick Question

Using the help menu from excel im trying to create a simple text file using
the following:

Sub CreateAfile
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.CreateTextFile("c:\testfile.txt", True)
a.WriteLine("This is a test.")
a.Close
End Sub

I have several named cells which Im trying to use to generate the text file
in the following format: " First_named cell " & " " & "Second_named cell"
&" "& Third &" " & "Fourth"