If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Mr. Excel HTML Maker no longer working

Thread starter wheath
Start date Aug 4, 2016
Tags

html html maker mr. excel

ZVI

MrExcel MVP

Mar 16, 2017

ifeelalone said:
It doesn't working for me. I'm using ms excel 2016 64bit with windows 8 os. I followed the instructions - unblocking the file, tweaking on trust center settings and stuff. Good thing the forum tool add-in works on me

For compatibility with 64bit versions of Excel it is required to replace in the module modMain this code line in the top:

Rich (BB code):

Private Declare Function LockWindowUpdate Lib "user32" (ByVal hwndLock As Long) As Long

by those lines:

Rich (BB code):

#If VBA7 Then
  Declare PtrSafe Function LockWindowUpdate Lib "user32" (ByVal hwndLock As LongPtr) As Long
#Else
  Private Declare Function LockWindowUpdate Lib "user32" (ByVal hwndLock As Long) As Long
#End If