fso.OpenTextFile Gives Invalid proc call or Argument error

[JohnBates]

Hi experts,

I'm using the following code in an ActiveX Task in SQL Server...

It gives a VBScript runtime error at the fspenTextFile stmt. The path to this existing text file is correct.
That's about all I can tell you.

Thanks for any help. John


Dim fso ' File System Object
Dim theFile ' TextStream
Dim sFileText 'String

Set fso = CreateObject("Scripting.FileSystemObject")
'the next line gives error Inv procedure call or argument
Set theFile = fspenTextFile("\\GM\C$\sys\paragon\gm\Files\Outbound\ACB_EnrollmentChanges.txt", ForReading, False)

 

[JohnBates]

this one has been resolved. John