Excel VBA - Own Type Question

[Bretthawk]

Hi everyone,
Need your assistance please.
I'm maintaining a piece of VBA (Excel) and can't seem to compile - Compilation fails on this statement:

Dim tf As New TextFile
tf.Filename = Left(dnFile, Len(dnFile) - 4) + ".out"
tf.openToWrite

My question is this: Where is 'Textfile" defined? Is that a user-defined type?

Thanks
Brett

 

[kjv1611]

If your question is dealing with VBA code, you need to ask in the appropriate forum:
forum707

In the mean time, I think you need to look at various ways of dealing with text files from VBA. Try this search, and try the below link as a starter:

http://zo-d.com/blog/archives/programming/vba-writing-to-a-text-file-ms-project-excel.html

And best I can remember, best I can find, yes, "TextFile" must be some user-defined type. If it is not, then your simply missing a reference in your VB Editor. To select the correct one, go to Tools - References, and find the one related. If you don't know what it is, I'd look for anything to do with text. You could use the Object Browser to search for it, View - Object Browser.