'Dim fsoHandle As FileSystemObject' fails

[Guest]

'Dim fsoHandle As FileSystemObject' fails

I have converted all code from DAO to ADO and changed the referenced libraries. Is this a DAO thing, or if not where would I get the reference ???
How would I convert it

Its being used in writing and reading a log file.

 

[Cheryl Fischer]

Make sure that you have a reference set to the Microsoft Office xx.x Object
Library. If you have that, then you might want to try:

Dim fsoHandle As Object
Set fsoHandle = CreateObject("Scripting.FileSystemObject")


hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

'Dim fsoHandle As FileSystemObject' fails.

I have converted all code from DAO to ADO and changed the referenced

libraries. Is this a DAO thing, or if not where would I get the reference
???

 

[Douglas J. Steele]

Actually, Cheryl, FSO comes from the Scripting Runtime library (scrrun.dll).
No reference to the Office Object Library should be required.

David: either add a reference to the Scripting library, or use the
late-binding approach Cheryl recommends.