Question

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 !

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