Using Windows XP, EXCEL Office 2003.
Each time I open an EXCEL workbook, I get the MICROSOFT VISUAL BASIC system
error '&H80004005 (-2147467259) unspecified error' message. I click on OK
about 17 times and then get another error message 'Compile error in hidden
module: This Workbook'. This happens each time I open an EXCEL file whether
it is a new one or not. Can anyone help me get rid of this, please?
Thanks
Yendorian
Mark Ivey - 10 Apr 2008 01:34 GMT
Have you tried running your code with Excel already opened?
Mark
> Using Windows XP, EXCEL Office 2003.
> Each time I open an EXCEL workbook, I get the MICROSOFT VISUAL BASIC
[quoted text clipped - 6 lines]
> Thanks
> Yendorian
Yendorian - 11 Apr 2008 14:09 GMT
Hi Mark,
I think I can only run the code when Excek is already open, can't I?
What is really worrying is that I get this message every time I open Excel
and before I enter any data or VBA.
Yendorian
> Have you tried running your code with Excel already opened?
>
[quoted text clipped - 10 lines]
> > Thanks
> > Yendorian
Mark Ivey - 10 Apr 2008 01:39 GMT
This may also help...
http://www.excelforum.com/showthread.php?t=361675
Mark
> Using Windows XP, EXCEL Office 2003.
> Each time I open an EXCEL workbook, I get the MICROSOFT VISUAL BASIC
[quoted text clipped - 6 lines]
> Thanks
> Yendorian
Alan - 22 Apr 2008 14:01 GMT
On Apr 9, 9:29 pm, Yendorian <Yendor...@discussions.microsoft.com>
wrote:
> Using Windows XP,EXCELOffice 2003.
> Each time IopenanEXCELworkbook, I get the MICROSOFT VISUAL BASIC systemerror'&H80004005 (-2147467259) unspecifiederror' message. I click on OK
[quoted text clipped - 3 lines]
> Thanks
> Yendorian
Hi,
It seems that your excel file is damaged or something. You may try
Advanced Excel Repair at http://www.datanumen.com/aer/ This tool is
rather useful in salvaging damaged Excel xls files. Hope this helps.
Alan