Problem with VBAHTMLMaker & Office 2010 64-bit system

[skyking]

Hi all,

Recently, I got a file VBAHTMLMaker.xla from one of our member Peter. Follow the addin installation procedure. When I check the box next to VBAHTMLMaker, An error message pops up:

Compile error:
The code in this project must be updated for use on 64-bit systems.
Please review and update Declare statements and then mark them with PtrSafe attribute.

I am running 64-bit systems for windows 7 & Office 2010.

Also, I am not that good in handling this. Can someone points out how to do this?

Thanks in advance.

skyking

 

[Andrew Poulsom]

This may help you:

http://www.jkp-ads.com/Articles/apideclarations.asp

 

[skyking]

Andrew,

Thanks for your info. Follow your link and I download and instal Office Code Compatibility Inspector. I also follow the instruction to Displaying the Developer tab, Enable VBA project access. Again, I follow the instruction to open VBHTMLMaker.xla and on the Developer tab, the Inspecting VBA code section just gray out. I can't go any futher. By examing Excel Title, it seems VBHTMLMaker.xla didn't open. Can you please help me again?

skyking