Writing to a file w/o quotes 1

[RichS]

How do you write to a file so that each line does not have a beginning and ending quote?
What I have is:

' Open the file
Open "C:\VBFormControls\" & Me.Name & "_Controls.txt" For Output As #1

' Include all the Control types to add ToolTips to
For Each ctl In Controls
If (TypeOf ctl Is TextBox) Or _
(TypeOf ctl Is ComboBox) Or _
(TypeOf ctl Is ListBox) Or _
(TypeOf ctl Is VSFlexGrid) Or _
(TypeOf ctl Is ListView) _
Then
sLine = ctl.Name & ".ToolTip = """
Write #1, sLine

End If
Next

Close #1



In the file I get "Some text" rather that just:

Some text

 

[DrJavaJoe]

Use Print # instead of Write #.

 

[RichS]

Thanks!! I could not for the live of me remember how to do that. I new it was something simple. (Hate it when that happens.)

Rich

 

[ZenToasty]

You might also consider using the Scripting runtime (scrrun.dll) instead. You can use the FileSystemObject and TextStream objects to read/write lines and they don't have quotes...