Data-capture spreadsheet

[Blakey]

Hello guys,
I am getting this screen too. I am assuming there is no fix for this?
Shame im just starting out with Excel and thought this would be a good place to start.

try replacing the line with the following (Although it's super hard to see what you've posted as it's not saved as attachment, I guess its the sleep command)

Code: Select all

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

thank you,

the error says The code in this project must be updated for use on 64-bit systems.

does that make sense to anyone?

[MemphisFlash]

To fix the error from re-appearing, add PtrSafe to the first line of your function. Finally, refer to the compatibility between the 32-bit and 64-bit versions of Office 2010

[Blakey]

To fix the error from re-appearing, add PtrSafe to the first line of your function. Finally, refer to the compatibility between the 32-bit and 64-bit versions of Office 2010

Thank you so much for your quick reply.
Do forgive me, I am totally novice at excel. Could you go into more detail on how to 'add PtrSafe to the first line of your function'? Please

Thank you so much

[MemphisFlash]

this may help
as they say a picture paints a 1000 words
same procedure for excel as access shown in video

https://www.bing.com/videos/riverview/r ... ORM=VMSOVR

[ilovepizza82]

Does anyone still have this data-capture spreadsheet on his hdd or sdd ?
Could you re-upload it ?
Thanks in advance !

[Blakey]

this may help
as they say a picture paints a 1000 words
same procedure for excel as access shown in video

https://www.bing.com/videos/riverview/r ... ORM=VMSOVR

Thank you so much. This is perfect