Macro code error message.

[ginny777]

Hi I have a macro that I have been using, (written with help from Mr. Excel).

I have used it on the first computer, copied it to a second and used it, and now I am trying to use it on a new (older) computer. When I try to run it on this last computer I get the error message: "Compile error: user-defined type not defined" Can anyone help with why this is happening only on this one computer? Thanks for any suggestions.

Here is the beginning of the code with the line in question in red.:

Sub XL_to_text()
Dim i As Long, j As Long, k As Long, l As Long, lastrow As Long
Dim oFS As FileSystemObject
Dim oTS As TextStream
Dim FilesName As String

 

[Hermanito]

Are you using the same versions of Windows and Office on all three PCs?

I suspect it is a missing reference...
Check Tools/References on a PC where the macro works and compare that with the PC where the macro doesn't work... you should be able to find the missing reference that way... add it and you should be fine...

 

[ginny777]

Thank you for your response.

The first computer had '07, the second and third have '03

I can't find "Tools/References" anywhere, nor do I find reference to that in any of my VBA books. Can you tell me where to locate that?

Thanks.

 

[ginny777]

Never mind question above, I was looking for it in excel, not the VB editor.

I am not where I can access the offending computer right now, I'll let you know if it worked as soon as I can.

Thanks again.

 

[Hermanito]

sorry, I assumed everyone knows where to find Tools/References
Next time I will mention VB editor alongside...