VB HTML Maker

[Juan Pablo González]

As you know, there is a new -free- addin available to download, the VB HTML Maker.

Its a simple xla, that will convert your VB code into HTML (Or BB) code so you can put it in this (And other) message boards.

There are two things that are bothering me, but time has not allowed me to dig more into them.

One. Comments...

The comment indicator is a good mark to notice when one comment starts, but that's not always the case, for example:

<font face=Courier New>
<SPAN style="color:darkblue">Sub</SPAN> Test()
    <SPAN style="color:green">'This will display the ASCII code</SPAN>
    <SPAN style="color:green">'of the comment indicator</SPAN>
    <SPAN style="color:darkblue">Debug</SPAN>.<SPAN style="color:darkblue">Print</SPAN> "The code is: " & Asc("<SPAN style="color:green">'") & ", enjoy !"</SPAN>
<SPAN style="color:darkblue">End</SPAN> <SPAN style="color:darkblue">Sub</SPAN>
</FONT>

The Asc("'") has a comment indicator, BUT should NOT be marked as a comment.

Two. Reserved words.

<font face=Courier New>
<SPAN style="color:darkblue">Sub</SPAN> Test2()
    <SPAN style="color:darkblue">If</SPAN> MsgBox("Please <SPAN style="color:darkblue">Select</SPAN> the correct one !", vbOKCancel, "Error") = vbCancel <SPAN style="color:darkblue">Then</SPAN>
        <SPAN style="color:darkblue">Exit</SPAN> <SPAN style="color:darkblue">Sub</SPAN>
    <SPAN style="color:darkblue">End</SPAN> <SPAN style="color:darkblue">If</SPAN>
<SPAN style="color:darkblue">End</SPAN> <SPAN style="color:darkblue">Sub</SPAN>
</FONT>

In this case, the Select shouldn't be treated as a reserved word, because it is part of a string.

The code in the program is NOT password protected, so if you feel like modifying it, improving it, fixing it, etc., please, FEEL FREE TO DO IT, and let's see if we can have a better AddIn for everyone.

Post your solutions/comments in here.

 

[dk]

Hi, Juan. I've been trying to get these to work. No luck yet. I went through the list and nothing is marked as missing. Actrually, though, I can't even get the VB HTML Maker to load. I get a message at Excel startup that says, "Access to the VB Project is not trusted".

As for the Spreadsheet HTML Maker, it seems to work, but I just get that error message at startup.

I'm going to keep working on it, but any ideas will be welcomed.

Todd

To fix the error message do this. Click Tools, Macros, Security. Then click the Trusted Sources tab. Make sure the Trust access to Visual Basic project is ticked. Close Excel and reopen.

Does that work?

 

[Todd Bardoni]

Thanks, Dan. This solved my problem! :D

 

[Juan Pablo González]

Ok people, looks like I've finally solved this problem. Check out the newest version of VB HTML Maker, which *should* work ok now...

 

[Ivan F Moala]

Ok people, looks like I've finally solved this problem. Check out the newest version of VB HTML Maker, which *should* work ok now...

Cheers Juan......will get it....

BTW, are you still up to testing the search addin ??

I now got it to search here , MSDN, Yahoo, Alta vista and of course google...in fact Google has the most options including searching your Favorite sites (Taken from your Browser), plus as well as selecting items to copy eg code etc, I have tried to automate this...still testing.

 

[XL-Dennis]

Seems I´m late for the thread...

But nice work Juan

Ivan,

Could You enlight me about the search add-in? It definetly looks cool :wink:

Kind regards,
Dennis

 

[Ivan F Moala]

Seems I´m late for the thread...

But nice work Juan

Ivan,

Could You enlight me about the search add-in? It definetly looks cool :wink:

Kind regards,
Dennis

Hi Dennis
Yes, I got side track off the Html2000, sorry
when I tried to finish some work for my site involving Userforms. Rather then
do a number of pages on different things I rolled some of them all into 2 projects, one of which was the above Addin.
It took some time to get the Google search to Work on other sites, but I got it going....in fact I Tested it on your Site , Tushars, Colos and a whole host of Sites.
I'm still trying to work around some others BUT it is very Functional.

 

[Juan Pablo González]

Yes Ivan.. still up for it ! and thanks Dennis, glad you liked it !

 

[XL-Dennis]

Yes, I got side track off the Html2000,

Why does this sound so familiar to me...Aha! I practice it myself

No rush and I believe things might get better solutions if we take it more slowly :wink:

Kind regards,
Dennis

 

[tusharm]

...I can't even get the VB HTML Maker to load. I get a message at Excel startup that says, "Access to the VB Project is not trusted".

Todd

Tools | Macro > Security... | Trusted sources tab | Check on 'Trust access to Visual Basic Project'

Keep in mind this enables access to the VBE for *all* add-ins and code in open workbooks and who-knows-what-else.

 

[mnatenshon]

That worked! Thanks....