Skip to content

A command line tool that traces a shape, then generates VBA macro that draws the shape in an Excel workbook.

License

Notifications You must be signed in to change notification settings

VB6Hobbyst7/BitmapTracer

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

BitmapTracer

This is a command line tool that traces a shape, then generates VBA macro that draws the shape in an Excel workbook.

Assumes Python 2.7 is available from the command line. Currently this only handles black and white shapes. (See MapOfTexas.bmp)

Demo:

Here's a bitmap image of Texas.

Texas

At the command line, pass the .bmp file to trace.py:

C:\Location> python trace.py MapOfTexas.bmp > macro.bas

The newly created .bas file will contain a macro that can be imported into an Excel workbook as a VBA module. The macro draws the outline of the bitmap image as an Excel shape.

Here's what the result looks like in Excel:

Screenshot

Future plans: Introduce a classifier to convert raw images into black and white bitmap files.

About

A command line tool that traces a shape, then generates VBA macro that draws the shape in an Excel workbook.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Visual Basic .NET 81.9%
  • Python 18.1%