VbaRobot – Bots do 4You

VbaRobot
BOTS DO 4YOU

“fast & simple automation”

Try our FREE BOTs
with full functionality

Go to Install

VbaRobot key features

We selected the main features of VbaRobot that may interest you.

Microsoft 365

- system designed in Access
- tested in Microsoft 365
- own useful functions
- many examples
- extensive VBA library

VBA library

SAP

- own useful functions
- functions and example from Open Source pages:
SAP for Windows
SAP Analysis in Excels

SAP Gui Scripting API

SQL Server

- no relationships in VbaRobot database
- easy transfer to SQL Server
- needs only ODBC conn. string

Import Access Database

IT security

- works under locked screen
(monitor can be off)
- simple instalation
- setup by Trusted Locations

Lock your screen

VbaRobot = RPA + VBA

VbaRobot is RPA tool written in VBA (Visual Basic for Application) and using this language to program robotic processes, which ensures their full compatibility. VbaRobot is a desktop computer application designed mainly to automate office work and perform tasks in Excel, Word, Access, Outlook, IE, etc.
Read articles on RPA and VBA:
1. RPA and VBA dilemma: Why Do I Need Robotics When I Have Macros? (2020.07.17/10 mins read )
2. Why RPA is not VBA? (2019.10.09/10 mins read )
3. Interesting RPA Blog – Ashling Partners

Own functions library

We have prepared a special set of functions that greatly facilitate the automation of office processes. Most of the functions are used in
> 20 examples attached to the downloaded files.
In addition, below we have added 4 simple cases of bots with a brief description and videos.

Simple Bots cases :

Case 1

Update excel pivot + Send email

In this case Bot will open Excel file, update Pivot and add it to email body. All using only one function (1 line in VBA code): OutlookMailHTML_AddExcelPivotFromFile(...)

Case 2

Update PowerQuery + Chart + Send email

Bot update PowerQuery, add Table,Chart to email body by functions : OutlookMailHTML_ AddExcelTableFromFile(...) OutlookMailHTML_AddExcelChartObjectFromFile(...)

Case 3

Update Access Query + Send email

In this case Bot will open Access file, update Query, add it to email body with Excel style. All using one function: OutlookMailHTML_AddAccessQueryFromFileExcelStyle(...)

Simple Bots cases - on video

Case 1: Update Excel Pivot + send email

Case 2: Update PowerQuery + Chart + send email

Case 3: Update Access Query + send email

All cases in one capture

Frequently Asked Questions

How long does it take to install?

It takes a few minutes, no need to restart your computer, read the info on Free/Pricing page and follow the four steps on the Install page.

Do I need to ask IT dep. to install VbaRobot?

Depends on your company’s security policy. The VbaRobot system does not require any changes to the computer settings or to anti-virus programs, configuration should be made mainly in the “Trust Center” in Microsoft office applications. Following the instructions on the Install page is enough.

How can I learn VbaRobot quickly?

It is best to follow the instructions in the file “ReadMe before first use of VbaRobotServer.txt” and by modifying more than 20 examples.

How long can the robot run without stopping?

Theoretically endless, in practice the bots worked for several weeks without any breaks.

Contact us

www.vbarobot.com/contact/

Meet us in the social media
View 24 our examples + 19h non-stop work on YouTube