chiello
Well-known Member
- Joined
- Jan 18, 2005
- Messages
- 848
Ciao everybody,
I have downloaded and installed the Converting VBA code into HTML - COM add-in by bykin.
The generation of HTML file works fine (the color of the fonts, the color of the background and the font are the same as the VBE in appearance).
Unfortunately, bykin "HOW TO USE THIS Add-in:" instructions finish here and steps to post VBA code on the board are not described.
What I have tried to do is to copy the HTML code of the generated file onto the board.
The result is shown below with a stupid sample code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>VBAProject_Modulo1.htm</title>
<style type=text/css>
<!--
body {background-color: #ffffff; color: #000000; font-family: "Courier New"; font-size: 10pt}
.keyword {background-color: #ffffff; color: #000080}
.comment {background-color: #ffffff; color: #008000}
-->
</style>
</head>
<body>
<nobr>
<div> <span class="keyword">Sub</span> Macro1()</div>
<div> <span class="comment">'</span></div>
<div> <span class="comment">' Macro1 Macro</span></div>
<div> <span class="comment">'</span></div>
<div> </div>
<div> <span class="comment">'</span></div>
<div> <span class="keyword">If</span> 1 = 1 <span class="keyword">Then</span></div>
<div> AA = 1</div>
<div> <span class="keyword">Else</span></div>
<div> AA = 2</div>
<div> <span class="keyword">End If</span></div>
<div> <span class="keyword">End Sub</span></div>
</nobr>
</body></html>
Please HELP!!
I have downloaded and installed the Converting VBA code into HTML - COM add-in by bykin.
The generation of HTML file works fine (the color of the fonts, the color of the background and the font are the same as the VBE in appearance).
Unfortunately, bykin "HOW TO USE THIS Add-in:" instructions finish here and steps to post VBA code on the board are not described.
What I have tried to do is to copy the HTML code of the generated file onto the board.
The result is shown below with a stupid sample code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>VBAProject_Modulo1.htm</title>
<style type=text/css>
<!--
body {background-color: #ffffff; color: #000000; font-family: "Courier New"; font-size: 10pt}
.keyword {background-color: #ffffff; color: #000080}
.comment {background-color: #ffffff; color: #008000}
-->
</style>
</head>
<body>
<nobr>
<div> <span class="keyword">Sub</span> Macro1()</div>
<div> <span class="comment">'</span></div>
<div> <span class="comment">' Macro1 Macro</span></div>
<div> <span class="comment">'</span></div>
<div> </div>
<div> <span class="comment">'</span></div>
<div> <span class="keyword">If</span> 1 = 1 <span class="keyword">Then</span></div>
<div> AA = 1</div>
<div> <span class="keyword">Else</span></div>
<div> AA = 2</div>
<div> <span class="keyword">End If</span></div>
<div> <span class="keyword">End Sub</span></div>
</nobr>
</body></html>
Please HELP!!
