Class recently stopped working - RtlMoveMemory

[mc84excel]

I have a class module I downloaded from the internet some time ago. And it has been working fine for some time. However I tried using it today and it no longer works. Every time I run it now it crashes.

I have made no change to the original code so I am wondering whether it could be some change to the Windows environment?

When I step through it, it works up until the last line in the extract below (it then gives the "Excel has stopped working" message):

Please Login or Register  to view this content.

CastToObject code below:

Please Login or Register  to view this content.

Is there anybody who can lend a hand on this?

[Debraj Roy]

Just a blind-shot..

Remove PtrSafe and VarPtr, they both bit conversion keywords.. and you may not need them in your excel version..

[romperstomper]

What's the value of sizeof_ptr and how is it declared?

Posting more code will probably help.

[mc84excel]

Just a blind-shot..

Remove PtrSafe and VarPtr, they both bit conversion keywords.. and you may not need them in your excel version..

I'm running Excel 2010 32 bit edition on Windows 7.

I tried your suggestion:

First it ran into a 'Type not declared' error on

Please Login or Register  to view this content.

So I changed that back and continued to F8.

Then I got the usual 'Excel has stopped responding' crash message on the

Please Login or Register  to view this content.

line again.

Thank you for trying to help.

[mc84excel]

What's the value of sizeof_ptr and how is it declared?

Hi Rory, the value of SIZEOF_PTR = 4 and it is declared as follows (extracts below)

extract 1

Please Login or Register  to view this content.

Extract 2

Please Login or Register  to view this content.

Posting more code will probably help.

I was worried that posting the code may put forum users off from helping out on this thread...

The code is very heavy stuff - I have never seen any VBA code remotely like it. It's quote "a Virtual-COM module that creates native-code x86 COM objects in memory" unquote.

OK, I will upload the classes in the next post.

[mc84excel]

Here's the code. It's too big to paste into a single forum post so I have placed all 4 class modules into a workbook in order to upload.

The error is occurring in the Class Initialize event.

[mc84excel]

Curiouser and Curiouser.

While I haven't intentionally make any edits to the code, it occurred to me that I *may* have inadvertently done so.

Unfortunately I don't have copy of the original code (and the original web pages are down) but I had an August backup of the project I use it in. I exported/imported the code modules to the current version and reran the code. You guessed it - it no longer crashes now.

I guess the lessons learnt here are:

1. Always keep an unedited copy of code you didn't create yourself
2. Keep backups on any project that is undergoing frequent changes.