VbaRobot
BOTS DO 4YOU

“fast & simple automation”




Try our FREE BOTs
with full functionality

VbaRobot key features

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

image

Microsoft 365

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

VBA library
image

SAP

- tested in R3/S4 Hana
- own useful functions
- few SAP examples
- functions and example for SAP Analysis in Excels

SAP Gui Scripting API
image

SQL Server

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

Import Access Database
image

IT security

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

Lock your screen

Where can You use VbaRobot?

This could be quite comprehensive list but there are many possible solution for your company. Try to identify the most time-consuming processes. Based on our experience, VbaRobot is best suited to the following areas:

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, SAP, 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.


4 simple Bots cases :

Case 1

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

Case 2

Update PowerQuery + Chart + Send email

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

Case 3

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(...)

Case 4

Case 4

Extract data from SAP + send email

In this case Bot will go into SAP transaction, load parameters, save results in Excel file and send it by email.

4 simple Bots cases - on video

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

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Cookie Policy for VbaRobot

This is the Cookie Policy for VbaRobot, accessible from www.vbarobot.com

What Are Cookies

As is common practice with almost all professional websites this site uses cookies, which are tiny files that are downloaded to your computer, to improve your experience. This page describes what information they gather, how we use it and why we sometimes need to store these cookies. We will also share how you can prevent these cookies from being stored however this may downgrade or 'break' certain elements of the sites functionality.

For more general information on cookies, please read "What Are Cookies". Information regarding cookies from this Cookies Policy are from the Privacy Policy Generator.

How We Use Cookies

We use cookies for a variety of reasons detailed below. Unfortunately in most cases there are no industry standard options for disabling cookies without completely disabling the functionality and features they add to this site. It is recommended that you leave on all cookies if you are not sure whether you need them or not in case they are used to provide a service that you use.

Disabling Cookies

You can prevent the setting of cookies by adjusting the settings on your browser (see your browser Help for how to do this). Be aware that disabling cookies will affect the functionality of this and many other websites that you visit. Disabling cookies will usually result in also disabling certain functionality and features of the this site. Therefore it is recommended that you do not disable cookies. This Cookies Policy was created with the help of the Cookies Policy Generator from CookiePolicyGenerator.com.

The Cookies We Set

Third Party Cookies

In some special cases we also use cookies provided by trusted third parties. The following section details which third party cookies you might encounter through this site.

More Information

Hopefully that has clarified things for you and as was previously mentioned if there is something that you aren't sure whether you need or not it's usually safer to leave cookies enabled in case it does interact with one of the features you use on our site.

However if you are still looking for more information then you can contact us through one of our preferred contact methods:

Close window