32 bit VBA on 64 bit pc

[Tim_Excel_]

Hi forum

I have written my macro on a 32 bit pc. I've added

#If VBA7 Then
    Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal ms As LongPtr)
#Else
    Private Declare Sub Sleep Lib "kernel32" (ByVal ms As Long)
#End If

in order to try and stop excel from asking for a PtrSafe attribute whenever the macro is executed on a 64 bit pc. However, these lines of code simply disappear whenever the file is opened on a 64 bit pc.

Is there any way I can make my file good to go on a 64 bit pc? Could I for example safe it on a 64 bit pc?

Thanks in advance

 

[RoryA]

Try sending it straight from Excel just to avoid any possibility of it being the wrong file. As I said I have not heard even a single report of this happening.

 

[Tim_Excel_]

Rory,

Will do, you'll hear from me when I get the chance

 

[Tim_Excel_]

I saved the file to a completely different file path, and then emailed it. It is positively the right file I sent.





Then I realised all the time I had been looking at another piece of code. Your solutions work, perfectly. I just did not realise there was another module that needed a PtrSafe attribute.




I have had better days

 

[RoryA]

It happens.

 

[GTO]

Glad you got it working and of course, Rory is right, it happens all too often