ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Object references (https://www.excelbanter.com/excel-programming/420686-object-references.html)

Don[_31_]

Object references
 
Office 2003

I have the following Excel code snippet in a macro
which did run fine until I had to do a major reinstallation.
Now it hangs on the fs= bit with the error message
Compile Error. Can't find the Project or Library.
I believe I'm missing a Reference under Tools/Reference,
but have no idea which one(s).
Can anyone help?

Set fs = CreateObject("Scripting.FileSystemObject")

donwb



Jim Cone[_2_]

Object references
 
The reference you need is "Microsoft Scripting Runtime"
--
Jim Cone
Portland, Oregon USA


"Don"

wrote in message
Office 2003
I have the following Excel code snippet in a macro
which did run fine until I had to do a major reinstallation.
Now it hangs on the fs= bit with the error message
Compile Error. Can't find the Project or Library.
I believe I'm missing a Reference under Tools/Reference,
but have no idea which one(s).
Can anyone help?

Set fs = CreateObject("Scripting.FileSystemObject")

donwb



Don[_31_]

Object references
 
Many thanks Jim
donwb

"Jim Cone" wrote in message
...
The reference you need is "Microsoft Scripting Runtime"
--
Jim Cone
Portland, Oregon USA


"Don"

wrote in message
Office 2003
I have the following Excel code snippet in a macro
which did run fine until I had to do a major reinstallation.
Now it hangs on the fs= bit with the error message
Compile Error. Can't find the Project or Library.
I believe I'm missing a Reference under Tools/Reference,
but have no idea which one(s).
Can anyone help?

Set fs = CreateObject("Scripting.FileSystemObject")

donwb






All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com