I am unable to do my Import, when I run my macros I received two errors, running excel 2003

40 pts.
Tags:
Microsoft Excel
Microsoft Excel 2000
Microsoft Excel error messages
Microsoft Excel macros
I Need some ones' assistance with this error that I am getting in my excel spreadsheet: "compiler error in hidden module: ChroniclesExport " This error is only when I'm running the MACRO's function. The MACRO has been checked by other colleagues at my work and is running fine on some PCs & but it fails to run for me and my co-worker. We received this error in our PCs and it is showing the same error. We have troubleshooted in different ways and also we removed and reinstalled the program MS EXCEL 2003. Also the Macro security has been set to Low!!! Thanks in advance !

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hello everyone I have the answer to my problem now, I am posting this for those that don’t have an answered or are having the same problem I was having too for running this macro staff!!

I started by trying and running through the following steps on your computer and see if that helps?

Download comdlg32.ocx from http://windowsxp.mvps.org/comdlg32.htm

and put it in C:\windows\system32

Then run regsvr32 c:\windows\system32\comdlg32.ocx from Start>Run

The errors I saw have been reported before, and it’s usually due to this file being missing.

Hope this will help everyone that is having the same problem as me

Ivanzamu

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following