ClassFactory Run-time Error

G

Guest

I have a macro-filled workbook which was developed in Excel 2002 and
distributed to 50 users around the state running various versions of Windows
and Excel. This workbook has worked perfectly for all 50 users for over a
year, until about a week ago. One user running Excel 2003 suddenly began
getting a run-time error on the following line of code:
Set FSCall = CreateObject("Scripting.FileSystemObject")

The run-time error is number -2147221231 and reads "ClassFactory cannot
supply requested class." I thought this message looked suspiciously like a
missing file or component, so I had the user re-intall both Windows and Excel
- no luck?

Does anyone have any other ideas?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MSCOMCT2.OCX registration error "ClassFactory cannot supply requestedclass" 1
VBA error when trying to create a word object in code 2
Automating Word 1
Scripting.FileSystemObject stopped working 7
"Scripting.FileSystemObject" suddenly stopped working 3
Getting ClassFactory error when clicking the "user accounts" icon 1
run-time error 2147417848 1
Open Workbook (VBA) 3

Top