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?

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?

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.
--
HTH...

Jim Thomlinson


" wrote:

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?

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

Thanks alot!