Updating Code for 64bit Office

Hi, I am new to using VBA and so far have been able to muddle my way through creating userforms to enter data into spreadsheets by reading all the different forums and copying and altering various bits of code. Worked fine at home setting everything up until I got to the office and found that most of our computers run the 64 bit version office 2010. Can anyone help me with altering the following code to make PtrSafe so that the rest of the code will run on either 32bit or 64 bit office.

Any help or advice greatly appreciated !

Please Login or Register  to view this content.

For those who are interested, here are the Windows 64 API function calls...

Please Login or Register  to view this content.

Hi Leith,

Thanks heaps .. I had managed to get it 90% right under my own steam albeit with a few errors but your code worked a treat.

Much appreciated

[SOLVED]

Hello D.A.S,

You're welcome. 90 percent isn't bad, but the API isn't very forgiving. Usually a single mistake is all it takes to crash your code or machine.

The basic rule is, as Izandol pointed out, all handles and memory pointers are LongPtr typed. There are 1 or 2 exceptions to this where a LongLongPtr type is used. The return value needs to checked against the API's function description. If you are unsure, check with MSDN. Generally, you can locate the function description by typing the function name into your browser bar. The writeup will tell you what type of variable is returned by the function.

Hello D.A.S.

This is a great quote!

I know I am many clicks away from being competent with basic VBA but only one click away from total annihilation of anything I am working on.

I think I'll have it put on plaque as a reminder.