Code update for 64 bit

[rizmomin]

Hello:

I have been using below code in VBA module on 64 bit system without any problem.
Now I ma trying to use the same code for another 64 bit system but it giving error as attached.
Please help me with this issue.

Let me know if any questions..
Thanks
Riz

Please Login or Register  to view this content.

[ranman256]

64 bits sys must have the PTRSAFE word in function declaration

Please Login or Register  to view this content.

[rizmomin]

Hi ranman256:

Can you please explain me where in the above code i need to add your code.
Thanks a lot
Riz

[TMS]

I think you might be confusing 64 bit Windows and 64 bit Excel. I suspect the first system is using 32 bit Excel and the second is using 64 bit Excel. Bothe computers can be running 64 bit Windows.

Regards, TMS

[rizmomin]

Hi TMS:

You are absolutely correct.
Both PC's are 64 bit.
One has 32 bit Office and other has 64 Bit office.
The above posted code works with no problem for 32 bit office computer.
I need to change the code so that it can be used for both pc.
Let me know if any questions.
Riz

[rizmomin]

Hello ranman256 and others:

I have done some progress with the below code and now i am getting 1 error as attached at IF Win64 Then..
I believe we need a statement for Office 64 bit ie IF Office64 instead of Win64 but does not work.
Please help to rectify.
Thanks
Riz

Please Login or Register  to view this content.

[Arkadi]

the if statements in Declare function must have the "#" in front just like ranman256 posted.

[Arkadi]

Maybe try this updated code:

Please Login or Register  to view this content.

[rizmomin]

Hi Arkadi:

Works great.
Thanks a lot
Riz