| 0 |
Subject: OT: Excel 97 macro help
Posted by: The Beezer
- Leader [191202817] Mon, Oct 22, 16:23
Calling out to all the Excel gurus out there...
I'm having an issue when I attempt to run a macro in Excel 97 under Win98. A message is coming up stating, "EXCEL caused an invalid page fault in
module VBA332.DLL", and then forces a shutdown of Excel.
Microsoft's support site doesn't have any info on this dll file, and web searches have only turned up a reference to a "VBA setup kit" that I was unable to find on download.com. I'm stumped. Any help would be greatly appreciated. |
| 1 | Challenger
ID: 23934149
Mon, Oct 22, 16:28
|
Run your macro thru the "step" mode and see were the error is 1st. Then maybe you can see what it is trying to do and then maybe you can solve the problem.
|
| 2 | The Beezer
Leader
ID: 191202817
Mon, Oct 22, 16:33
|
Should have been clearer on that. The error comes up as soon as I press either F5 or F8, so it's merely reading the sub line of the macro, and it's happening on all of my macros, which had never shown a problem before. That's one thing that's making it difficult to troubleshoot, because it doesn't even complete 1 line of execution before failing.
Thanks for the quick reply, Chal. Hope this info helps a bit more.
|
| 3 | Challenger
ID: 23934149
Mon, Oct 22, 16:55
|
Never had that problem, so I did a search on google.com and it seems the problem is common. But not knowing you system and programs, I'll provide you the link and maybe something there will help you.
http://www.google.com/search?q=VBA332.DLL&btnG=Google+Search
Hope this helps & Good luck!
|
| 4 | Dr. Doom
ID: 16142182
Mon, Oct 22, 18:08
|
Beezer,
I have had some weird stuff like this in the past as well. What you might try is exporting (delete) your VB code and re-importing it.
I have tried this in the past with some success. You might want to this anyway as Excel spreadsheets seem to grow in size as you use you macros over time even if no new data is added.
|
| 5 | The Beezer
Leader
ID: 191202817
Mon, Oct 22, 19:05
|
Good suggestions, guys. Unfortunately none of the sites that I found from Challenger's link, nor exporting, deleting, and importing my code helped. Not a huge concern, as I will just need to borrow the Office 97 CD from work again and reinstall, and it's not an immediate concern. I'm just lazy. :) Thanks for the assistance.
|
| Rate this thread: | If you wish, you may rate this thread on scale of 1-5. Ratings should indicate how valuable or interesting you believe this thread would be to other users of this forum. A '5' means that this thread is a 'must read'. A '1' means that this is a complete waste of time. If you have previously rated this thread, rating it again will delete your previous rating. If you do not want to rate this thread, but want to see how others have rated it, then click the button without entering a rating, or else click here. |
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|