This web site is to assist those who want to work with the lesser known applications that can be controlled by VBA.
There is plenty of help on the internet for Microsoft Excel, less for Microsoft Word, less for Adobe Acrobat and even less for SQLite and many ,many others.
Over the years I have accumulated a considerable number of tips on the use of VBA.
It is going to take a long time to publish these tips but I have to start sometime.

There are 2 types of applications that support VBA.
Primary VBA applications are those in which you can write and save VBA code within their files.
Secondary VBA applications that are designed to support VBA but you cannot write or save VBA code within these applications.
Any Primary VBA application can open and manipulate another Primary or Secondary VBA application using VBA.

Primary VBA Programs that support VBA are;

AutoCAD
CorelDraw
Corel PhotoPaint
Microsoft Access
Microsoft Excel
Microsoft Outlook
Microsoft PowerPoint
Microsoft Publisher
Microsoft Visio
Microsoft Word

Secondary Programs that can be Controlled by VBA are;

Adobe Acrobat Professional
Adobe Illustrator
Adobe PhotoShop
CDDBControl
CMD Prompt
Globalscape CuteFTP
GhostScript
Microsoft Internet Explorer
Microsoft Speech Object Library
Microsoft VBScript Regular Expressions
Microsoft Windows API
Microsoft Windows OLE File Propert Reaser
pdfTK
Nuance PDF Professional
SQLite
Visual Basic Scripts
Xpdf
Windows Script Host Object Model

These secondary level applications cannot run VBA themselves but can be controlled via VBA from primary applications.
Most have scripts that VBA can access.
There maybe other Adobe products, such as Indesign, that support VBA but I have not investigated them.



Sites that I have found useful are;

Pearson Software Consulting mainly for Excel VBA tips but some can be applied to CorelDraw VBA.

Stephen Bullen's site. This guy is brilliant! It is mainly Excel orientated. He often uses other languages within VBA to access windows components.

The Word MVP Site for Microsoft Word on the internet.

Susan J. Dorey in her section Tools. Is very good for Word & Access VBA, particularly Word. There is not much on Word VBA on the internet.

Karl Heinz Kremer's site showing how to control Acrobat using VBA is a good starting point if you have this need.


My email address is corel-vba@mail.com.

Issue date 2021_09_25