LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 5th 04, 02:41 PM posted to microsoft.public.excel.programming
external usenet poster
First recorded activity by ExcelBanter: Jan 2004
Posts: 1
Default System error &H8007007E (-2147024770). The specified module could not be found

Did anyone get this error message when running VbA in an Excel Workbook?

Here's how I get it:

I open an Excel 2000 Workbook using Excel XP. The workbook has code in the
Open event. When the workbook opens, I get the error. Then it gives me a
"Insufficient memory" message.
If I hit a button that has code under it, even if I stick a breakpoint at
the very beginning of the sub, I get both errors then it stops at the break
point. If I stop the execution, again there's those two errors.

Any idea what's causing this behavior?

Here' my config:
WinXP with auto-update activated
Office XP Pro
The workbook has been saved with Excel 2000 and it's using
mscomctl2.ocx(I've installed the ocx on Excel 2000 computers)


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Module error Phanindran U[_2_] Excel Discussion (Misc queries) 1 August 20th 07 09:09 AM
Counting instances of found text (Excel error? Or user error?) S Davis Excel Worksheet Functions 5 September 12th 06 04:52 PM
error "module not found" Amit Excel Discussion (Misc queries) 1 May 13th 05 01:24 PM
How do I get rid of "Compile error in hidden module" error message David Excel Discussion (Misc queries) 4 January 22nd 05 12:39 AM

All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017