filesystemobject not defined??

[djbitchpimp]

I am trying to use a filesystemobject in a macro for excel. Basically I
want to open a new file, output some data to it, then close it.

The Visual Basic editor is complaining "User-defined type not defined"

I have done some research on the message boards and the commonly
suggested solution is Tools >> references >> check Microsoft Scripting
Runtime

BUT

for some reason the references option is greyed out.

Anyone have any suggestions?

 

[Roy Harrill]

Perhaps your PC doesn't have the scripting files. You can download the
version for your Excel from:
http://msdn.microsoft.com/library/default.asp?url=/downloads/list/webdev.asp
HTH

 

[Guest]

This might be a silly question but is your code still executing. Ensure it is
not by Clicking the stop button in the VBE and the reference option should
become available.

 

[djbitchpimp]

Not silly at all. That is exactly what happened - I never stopped the
code from running!

Thanks alot!