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 |
Runtime Error
-----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. |
All times are GMT +1. The time now is 04:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com