OK.

Feel free to ignore the comments on the page I linked: "The problem with running legacy VBA code in 64-bit Office is that trying to load 64-bits into a 32-bit data type truncates the 64-bit quantity. This can result in memory overruns, unexpected results in your code, and possible application failure".

Much like my comment to the OP I would respectfully suggest you should read and make sure you understand the contents of that page.