CreateTextFile with FSO 1

[devRyan]

Hi All,

Was hoping I could get some quick help. I'm trying to use the FSO to create a file, but can't seem to get it to work.
Could someone please tell me what I'm doing wrong?

I've got the Windows Scripting Library is referenced, so it recognizes my objects. Mainly though, I don't know what type to dim my actual file as.

Thank you.

Ryan

Dim fso As Scripting.FileSystemObject
Dim csvFile As File '<- Is this right?
Set csvFile = fso.CreateTextFile(strFile, False, False)

 

[SkipVought]

Did you check the methods for the File Object?

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[devRyan]

No, because I'm already pretty sure it's wrong. So what type should it be dimmed as?

 

[devRyan]

I've used the FSO extensively with asp and vbs, but not with vba, so have never had to worry about the files type.

 

[SkipVought]

If you have used FSO extensively, then you ought to know about objects and their properties and methods.

You need to check out the METHODS available to the File Object.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[devRyan]

 

[PHV]

Have a look here:

http://msdn2.microsoft.com/en-us/library/z9ty6h50.aspx

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886