VBHTML Maker choking..

[Zack Barresse]

Okay, so not sure where to put this question, and this forum seemed somewhat appropriate.

I have been using JPG's VBHTML Maker Add-in for quite some months now, without consequence either. But in the last couple of months, it's been choking on me. The steps I take:

Select text in my VBE
Right click it
Select Convert Selected .. to HTML

The app will become Visible = False (as it should) but hangs in the VBE whilst the mouse icon is still the hourglass. I stop the code manually and it's stuck in a redundant loop, although I'm unsure how it gets into the loop at this point. I can stop the code and must manually (from a Standard Module of a Standard Excel file) make the Application.Visible = True, along with the mouse icon; or Close the instance of Excel (either manually by ending the process or making visible and shutting down correctly).

The strange part is it's quite sporadic. It will be fine for a week, then up and decide to choke. I can't seem to find any similarities in my working environment during these episodes, so I'm unsure as how to proceed. But am wondering if anybody else has had the same issue anytime?

I'll be investigating further and posting any findings, thanks for reading.

 

[Juan Pablo González]

Well, all that comes to mind is, it's all your fault Zack... No, really... I have no clue what might be going on. What I would suggest is in the 'Init' function, comment this line:

LockWindowUpdate (VBEHwnd)

that line locks the screen updating of the VBE. You may have to run the 'Start' sub again to reset the buttons. At least that way you could Ctrl + break and see where it is hanging...

 

[NateO]

The only thing I have noticed is that huge procedures take a while to process, which is to be expected. You might want to streamline your code Zack.

 

[Zack Barresse]

The only thing I have noticed is that huge procedures take a while to process, which is to be expected. You might want to streamline your code Zack.

You know the funny thing, it was only two subs with one line each - 6 lines! So I don't think that was the issue. Good point though.

Thanks Juan, I'll be looking into this further to see if I can find what exactly is causing this to happen for me. I'll keep you appraised.