Perhaps your PC doesn't have the scripting files. You can download the
version for your Excel from:
http://msdn.microsoft.com/library/de...ist/webdev.asp
HTH


wrote in message
ups.com...
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?