Question

Asked:
Asked By:
Jan 8 2009   5:54 PM GMT
IVANZAMU   35 pts.

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


Excel macros, Microsoft Excel, Excel error messages, Excel 2000

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 !

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Development and Microsoft Windows.

Looking for relevant Development Whitepapers? Visit the SearchWinDevelopment.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register