Link to home
Start Free TrialLog in
Avatar of Fordraiders
FordraidersFlag for United States of America

asked on

file reader syntax not working

vba.

I'm trying to append text file, but cant get this to work ?
This:
Set writeFile = objFSO.OpenTextFile(TextBox3.Text, ForWriting, True) '<--outgoing file
To This ?:
Set writeFile = objFSO.OpenTextFile(TextBox3.Text, Forappending, True) '<--outgoing file


Thanks
fordraiders
ASKER CERTIFIED SOLUTION
Avatar of Pratima
Pratima
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Fordraiders

ASKER

yes, read all that from the link already.

I had:
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set writeFile = objFSO.OpenTextFile(TextBox3.Text, ForAppending, TristateFalse) '<--outgoing file

Invalid procedure call or argument
ok set "microsoft scripting runtime" and worked.