--------------------------------------------------------------------------------------------

A COM Add-in for Visual Basic Editor
[Converting VBA code into HTML] Version 1.40

Copyright(C) 2002-2003 bykin  All Rights Reserved.

--------------------------------------------------------------------------------------------
English Version text is written by Colo, special thanks to Nate Oliver.
--------------------------------------------------------------------------------------------
------------------------------------------------
ABOUT THIS Add-in:
------------------------------------------------
This is a COM Add-in that converts VBA code into HTML, it works with Microsoft Office
Applications(Access, Excel, FrontPage, Outlook, PowerPoint, Publisher, Visio, Word) that
incorporate VBA via the VBE(Visual Basic Editor).
With this utility, you can conveniently print out the code with color that can not be done
via the VBE alone.
The generated code is in an HTML format, you can use then code for presentations,
e.g.,upload the code to a website.

------------------------------------------------
OPERATIONING ENVIRONMENT:
------------------------------------------------
The utility is functional with applications where VBA Vers 6.x is included.
Eg.Office2000, Office2000XP
It does NOT work on Office97, Publisher2000.

------------------------------------------------
ABOUT FILES:
------------------------------------------------
When you unzip the file named Vba2html.zip, the following files will be extracted to the
Vba2html folder.
  Vba2html.dl_		The source file of this Add-in file.
  Install.exe		The program for registration this Add-in.
  Uninstall.exe		The program for releasing this Add-in.
  ReadMe.txt		This text file.

------------------------------------------------
HOW TO INSTALL/UNINSTALL THIS Add-in:
------------------------------------------------
-INSTALL
Please double click Install.exe and follow the prompts.
If a previous version is installed, the previous version will be over-written automatically.

-UNINSTALL
Please double click Uninstall.exe and follow the prompts.

-NOTES
*Please make sure to quit all applications that are equipped with the VBE, the Registration
 program cannot execute when applications that are equipped with the VBE are running.

*Please leave Vba2html folder and all associated files for releasing and re-Registration.
 If you would like to completely delete this Add-in, after running Uninstall.exe,
 delete all unzipped files including the parent folder.

*If you get error messages and could not INSTALL/UNINSTALL, please make sure to review
 the following:
 1) The program for install and the source file should be located in the same folder.
 2) All applications that include VBA are not running.
    Note: VBA may also be included in applications other than the Office applications
    previously mentioned.
 3) Any application should NOT be opened from an internet browser such as 
    Microsoft Internet Explorer.
    In this case, you would need to close the browser once.

------------------------------------------------
HOW TO USE THIS Add-in:
------------------------------------------------
After the Registration is complete, [Converting VBA code into HTML] command bar will be
added in the VBE menubar when you start a voluntary application.
The default position would be at the left end of the 2nd row of the command bar.
(Usually you can see the command bar of [Converting VBA code into HTML] just under the
menu bar.)
Select a module from the project explorer (tree view window), then click the button on
the [Converting VBA code into HTML] command bar, a dialogue will be shown.
After setting the appropriate settings, click the [OK] button, the HTML file will then
be generated. The color of the fonts, the color of the background and the font will be
the same as the VBE in appearance.

------------------------------------------------
ABOUT SETTINGS:
------------------------------------------------
[Enable Style Sheet]
  Set attributes like font by using Style Sheet(CSS=CascadingStyleSheet).

   -Font Size
     The fonts size will be used in the HTML file.(Can be changed.)
     The size will be shown that selected in the VBE option menu. 
     The default size would be 10 points.
     If you would like to change the font size, you can adjust the output to a range of
     6 to 24 points.

   -Specify class with <style> tags
     Specify class with <style> tags in the HEAD element in the HTML file.(default settings)
     When the associated check box is not checked, <style> tags will not be used, styles
     would be specified in inline. In this case, the generated file size will larger.
     * If you are using Netscape Communicator Ver4.x, please uncheck the style box.
       If checked, the output will not displayed correctly on Netscape.

[Disable Style Sheet]
  Set attributes without CSS. For this reason, there are the following restrictions.
    You cannot specify the fonts size.
    The specification of the back ground color will be ignored.
    (Usually the back ground color would be only WHITE color.)
    The author recommends you to choose this, only under the following circumstances.
    -You would like to edit the generated HTML.
    -You would like to paste the generated HTML source to the another HTML source.
     (In this case, please use the source code between <nobr> to </nobr>)

[Use normal color scheme]
  HTML will be generated with normal color scheme without using your VBE's setting.
  You cannot chose this when the present setting is same as normal color scheme of the VBE.

[End Procedure Line]
  Add horizontal line between procedures.
  Default setting is same as your VBE's setting.(Can be changed.)

[The target project]
  The name of the project that contains module with the code to be converted.

[The target Module]
  The name of module with the code to be converted.

[Save As]
  Stands for the full path of HTML file that will be generated.(Can be changed.)

    -The default folder for saving files is the folder for saving the target project.
     However in case the concerned folder is NOT on the HD or Removable Disks
     (network folder, CD-R and so on) and unsaved project, the default folder would be
     My Documents folder.

    -The default file name would be...
     [In case The project file has been saved]
        Project file name + under score(_) + module name + .htm
     [In case The project file has NOT been saved]
        Project name + under score(_) + module name + .htm
     (Eg)
      The folder for saving project = C:\Test\
      The project file name = Sample.xls
      The module name = Module1
      In the case of above, the saving path that will be shown as default would be
      C:\Test\Sample_Module1.htm

      Restrictions regarding saving the file are as follows:
      1)You can change path to a Local Hard Drive or removable disk only.
      2)The filename is limited to 256 characters or less.

------------------------------------------------
NOTES:
------------------------------------------------
- This Add-in is for VBA Ver6.0 and later exclusive use.
  You cannot use this in VBA of the older versions, such as Office 97 (VBA Ver5.0).
  Operation on VBE included in applications other than Office has not been tested,
  please use this functionality at your own risk.

- Regarding font and bg colors: [code, comment, key word and discern characters] will be
  converted. Syntax Errors (RED) will NOT be converted.
  Please make sure to compile to remove error lines before running this add-in/converting
  your code.

- Since the interpretations of HTML differ depending on the browser to be used,
  the resulting display may be amusing.
  (This add-in has been tested on Internet Explorer Ver5.0 and later versions of the same
  application.)
  When you upload this code to a web site, please confirm through some browsers before
  making it available (of possible).
  Especially with respect to the background color, I recommend that you use the standard
  setting of code.

- In a HTML code generated by this add-in, you need to scroll for viewing the character
  which overflowed on the screen of a browser.@Moreover, the overflowed part would be
  omitted at the time of printing.
  When all text cannot be printed, please insert return code into the suitable position of
  a source code.
 
------------------------------------------------
LICENCE AND DISCLAIMER:
------------------------------------------------
This program is distributed as FREEWARE by bykin, the author. All credit to bykin.

------------------------------------------------
EXEMPTION FROM RESPONSIBILITY:
------------------------------------------------
The authors shall not take any responsibility whatsoever regarding any damage generated
caused by using this Add-in.
It is presented as-is freeware and the user shall bear sole responsibility/burden of risk.

------------------------------------------------
RE-DISTRIBUTION:
------------------------------------------------
Conditional Re-distribution is acceptable as long as the author and the contents are not
changed. Unapproved reproduction is forbidden.
The author must be given notice and approve in advance.

------------------------------------------------
VIRUS CHECK:
------------------------------------------------
This Add-in has been checked by Virus Buster2003.

------------------------------------------------
DEVELOPMENT ENVIRONMENT:
------------------------------------------------
WindowsMe - OfficeXP Developer / Windows98 - Excel2000

------------------------------------------------
HISTORY:
------------------------------------------------
7th Jun. 2003	English version Released.

------------------------------------------------
A MESSAGE FROM THE AUTHOR:
------------------------------------------------
I was dissatisfied with the facts, -VBE can print a code only in monochrome- Must change
the font size into the degree of printing when font size legible on a screen differs from
font size to print. So...I decided to make an add-in!
The most difficult part with creating this add-in is handling KEYWORDs (The dark blue
characters by the default settings of VBE). KEYWORDs are difficult, they're NOT the same
as the KEYWORDs described in the helpfile. Some functions (UBound etc.) are dark blue for
no apparent reason. (In this case, parenthesis' charachters are also dark blue.)
The KEYWORD color of model conversion function like CLng function or CStr function is
almost dark blue, but CDec is NOT...
I thought the judgment standard of the KEYWORD was opaque, this Add-in has been made so
that the conversion is faithful to the VBE appearance as much as possible.
Incidentally, the color scheme that I would recommend to end-users is to change only
keyword color to BLUE from DARKBLUE. By using this setting, keeping the standard image,
I could clearly recognize the KEYWORD both on screenand the print-outs.
My personal settings are set to the aforementioned color scheme. Please give it a try.
To change the color scheme, select Tools > Option > Editor Format from the main menu of VBE.

I received great cooperation from 2 VBA guys - Colo and Nate Oliver with the release of the
English version. I would say thanks a million to them. It is a great honor that this add-in
will be used by VBA programmers around the world.

------------------------------------------------
CONTACT INFORMATION:
------------------------------------------------
If any errors occur or you have any suggestions, please email to bykin at
bykin@candypot.net

--------------------------------------------------------------------------------------------
	YOU MUST AGREE TO THIS BEFORE USING THE PROGRAM
--------------------------------------------------------------------------------------------