Help! Application Error >_<

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Al

My colleague has passed a Excel program to me and I start developing in my computer.
After I have finished adding some code I passed it back to colleagues' machine but when they click on some buttons created before they got Application Error like
the instruction at "0x6504e339" referenced memory at "0x0000000c". the memory could not be "read"

The program can be ran on my machine well, but not the others. I bring it back home and it can still be ran sucessfully.
I doubt as the window version(2k professional) and excel version of my computer should be the same as my colleagues.

I search on google and they said it may be related to different privleges of the user opening the file
But it seems all of us are logged to the winodw system as Adminstrator.

Any ideas?
please help !
thx a lot!!!
 
Hi Weiweiwei,
My colleague has passed a Excel program to me and I start developing in my computer.
After I have finished adding some code I passed it back to colleagues' machine but when they click on some buttons created before they got Application Error like:
the instruction at "0x6504e339" referenced memory at "0x0000000c". the memory could not be "read".
Click to expand...

Two things to try:

1. Rob Bovey's code cleaner at www.appspro.com
2. On the other machine, try to open the workbook with macros disabled.
Check in the VBE of any references are marked missing (Tools, references)

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Hi,
In addition to what Jan said :
If you have older version of excel, change the command button
"TakeFocusonClick" to false.
I had that kind of problem as well. To solve it (temporarily, because the
problem reappeared a few times), delete the button and create a new one with
the same name (it helped in my case). No explanation find so far, but the
problem dissapeared after a while.
Regards,

JY


WEIWEIWEI said:
Hi All

My colleague has passed a Excel program to me and I start developing in my computer.
After I have finished adding some code I passed it back to colleagues'
Click to expand...
machine but when they click on some buttons created before they got
Application Error like:
the instruction at "0x6504e339" referenced memory at "0x0000000c". the memory could not be "read".

The program can be ran on my machine well, but not the others. I bring it
Click to expand...
back home and it can still be ran sucessfully.
I doubt as the window version(2k professional) and excel version of my
Click to expand...
computer should be the same as my colleagues.
 
hi Ja

thx a lo
I have ran the code cleaner and it seems the problem is solve

what is the magic of the code cleaner btw..

anyway million thx!



----- Jan Karel Pieterse wrote: ----

Hi Weiweiwei
My colleague has passed a Excel program to me and I start developing in my computer.
After I have finished adding some code I passed it back to colleagues' machine but when they click on some buttons created before they got Application Error like
the instruction at "0x6504e339" referenced memory at "0x0000000c". the memory could not be "read"
Click to expand...


Two things to try

1. Rob Bovey's code cleaner at www.appspro.co
2. On the other machine, try to open the workbook with macros disabled.
Check in the VBE of any references are marked missing (Tools, references

Regards

Jan Karel Pieters
Excel MV
www.jkp-ads.co
 
Hi WEIWEIWEI
thx a lot
I have ran the code cleaner and it seems the problem is solved

what is the magic of the code cleaner btw..?
Click to expand...

When you edit code, the Visual Basic editordoes not do a good cleaning
job after itself. Codelines you ave deleted somehow remain "in the
background".

After a lot of editing, a lot of rubbish thus piles up, which Rob's
code cleaner removes.


Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Back
Top