Thread: Runtime Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
michael michael is offline
external usenet poster
 
Posts: 28
Default Runtime Error

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