Hi,

I have this Excel Workbook that contains about 15 - 20
sheets, each containing data. On the first sheet is a
button that launches a macro to print the data out to an
XML format. Now, this has worked on several different
machines, but when it was run on one particular machine a
runtime error was generated:

Run-time error '-2147024770 (8007007e)':

Automation error
The specified module could not be found.

If you entered into the Debug mode, it took you to the line
containing the statement:

Set fs = CreateObject("Scripting.FileSystemObject")

I am at a loss. All the computers that use this run Excel
2000 and are run on Windows 2000. Any ideas as to the
reason for this runtime error? Any help would ge greatly
appreciated.

Thanks.

Michael

-----Original Message-----
Hi,

I have this Excel Workbook that contains about 15 - 20
sheets, each containing data. On the first sheet is a
button that launches a macro to print the data out to an
XML format. Now, this has worked on several different
machines, but when it was run on one particular machine a
runtime error was generated:

Run-time error '-2147024770 (8007007e)':

Automation error
The specified module could not be found.

If you entered into the Debug mode, it took you to the
line
containing the statement:

Set fs = CreateObject("Scripting.FileSystemObject")

I am at a loss. All the computers that use this run Excel
2000 and are run on Windows 2000. Any ideas as to the
reason for this runtime error? Any help would ge greatly
appreciated.

Thanks.

Michael
.


Your code is at a point where it is looking for the
Windows Scripting module (that contains the Scripting
object references you are trying to use) and probably is
not finding it on the suspect machine. My first thought
is that the required .dll file is missing on that
particular machine. With a bit of research you should
probably be able to find out the .dll file needed and see
if it is indeed missing, then put a copy on that machine
and I bet that would solve your problem.