|
The macro/VBA functions let you automatically build barcode strings in
Excel, Access and Word. These functions are easy to use, and fully tested
in Office 97, 2000 and XP. Our Font products are fully MS Office Compatible –
we carefully design the fonts to make them meet every requirement of
Microsoft Office. NO more strange characters when using our barcode font
package!
The VBA source code is part of Morovia Font Tools which can be
downloaded separately from this page. This VBA source code is also
included in every Fontware package, demo and retail versions. To
download the most recent version of Morovia Font Tools, click
here.
The VBA source code can be located in your Excel sample which comes
with every Fontware package, or you can find it under the FontTools
directory. The FontTools directory is usually located at c:\Program
Files\Common Files\Morovia\MoroviaFontTools
folder. In addition to VBA source code you can also find source code for
VBScript, C/C++, Crystal Report and etc.
 Open the spreadsheet you want to add barcode functions to. Click
Tools, Macros, Visual Basic Editor. In the Visual Basic Editor window,
click on File, Import File, and select the file MoroviaFontTools.vbs and open
it. This will add a new module, MoroviaFontTools, to your spread sheet. You
do need the correct function for your application. All function
definitions can be found here.
After you import the module you are ready to use any functions. To allow the
cell display the barcode, you need to choose the correct typeface. Some
adjustment to the cell height and width may be needed to accommodate the
barcode symbol.
To use VBA Functions in Access, first open a database. Choose
database objects, click on Modules, then press New… button. Visual Basic
Editor window appears. Import the file by click on File | Import File.
This adds a new module, MoroviaFontTools to your database file. All
functions are available now. These functions can be used in the source
field for controls in a report. You may need to adjust the control size
so as to accommodate the barcode image.
Microsoft Word cannot call VBA functions directly. However, you can
use Excel as data source and take advantage of mail merge feature of
Word. Update (thank Paul Edstein): Microsoft Word 97 and later versions
support VBA. We plan to release some samples in the support web site in
the near future.
Place your data in Excel in a special column, and then apply the
barcode functions to produce the results. Put the results in another
column. Pass the second column to Word in the Mail Merge. Note that the
barcode symbol is not displayed correctly in the Word. Instead, only the
data printed by the mail merge will be in the correct form.
The Barcode samples come with every font package. Simply open the
sample file and play a little bit - it is actually very simple and easy
to print a barcode from Microsoft Office with Morovia Fonts! If you
encounter any problems, visit this page
to contact us. |
