Compile error in hidden module: Module1.

[eoinymc]

Hi there,

I have a report that I created in Excel 2007, but now when I open it in recently installed Excel 2010, I am getting the following error when I open it.

"Compile error in hidden module: Module1.
This error commonly occurs when code is incompatible with the version, platform, or architectutre of this application. Click "Help" for information on how to correct this error."

Has anyone got any ideas as to why this is happening?

Thanks,

Eoin

 

[eoinymc]

I've figured out that it is...

Declare Function GetSystemMetrics32 Lib "User32" _
                Alias "GetSystemMetrics" (ByVal nIndex As Long) As Long

I'll start another thread to ask anyone do they know how to get the monitor size in Excel 2010.

Thanks,

Eoin