Excel 97 Macro Problems

Tractor Boy

New Member
Joined
Mar 21, 2004
Messages
3
I am currently doing coursework on my school computers using Excel 2000. I was hoping to continue my work using Excel 97, the version that I have on my old computer (The Microsoft Works edition I have on my current PC doesnt seem to be compatitable). I've saved my school work (excel 2000) onto a floppy disk and have succesfully got it to load up on my version of Excel 97. However, when I try to work a macro, I get an error message reading "This program has performed an illegal operation and will be shut down...".

This is what it says when I click the 'Details' button in the pop-up menu...

EXCEL caused an invalid page fault in
module EXCEL.EXE at 015f:3039b60a.

Registers:

EAX=0062f570 CS=015f EIP=3039b60a EFLGS=00010206

EBX=00000000 SS=0167 ESP=0062f544 EBP=0062f5a4

ECX=00000001 DS=0167 ESI=008b3b80 FS=0e8f

EDX=0000000b ES=0167 EDI=0062f590 GS=0000

Bytes at CS:EIP:

00 83 f8 20 75 15 39 7d fc 74 10 68 00 08 00 00

Stack dump:

303a1d5a 008b3b80 008b3c18 0062f570 00000000 008b3b80 00000001 0000009a 0000006e 0000011b 000000b1 0000009c 00000070 0000011b 000000b1 0000009b

Could you shed any light on what the problem may be?

Many Thanks
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Hi!
This maybe an issue of BV compatability. your xcel 97 might not using VB 6.0 as in xcel 2000.
You may better post your code for the people here to see and suggest. the register error is very hard to guess. its not for human consumption.
 
Upvote 0

Forum statistics

Threads
1,223,275
Messages
6,171,127
Members
452,381
Latest member
Nova88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top