VbaRobot installation procedure

Please go through the following four points to complete installation:

1) Change settings & check your Office application:
  • change settings in Trust Center in Office applications -> follow the steps below:
  • create folder on your C drive: “c:\VbaRobot”,
  • open ACCESS and go to: Options-> Trust Center-> Trust Center Settings-> Trusted Locations-> Add new location,
  • enter location “c:\VbaRobot\” and mark “Subfolders of this location are also trusted”, confirm OK, do the same for EXCEL, WORD. It should looks like below:
  • open EXCEL and go to: Options-> Trust Center-> Trust Center Settings-> Macro Settings: in mark “Trust access to the VBA ….” as on below pic (to allow running macros from external app like ACCESS), confirm OK, do the same for WORD. It should looks like below:
  • If you still have problems with running macros mark additionally in ACCESS, EXCEL, WORD, OUTLOOK “Enable all macros … ” in Macro Setings section. You can also add the following settings in ACCESS, EXCEL, WORD (not mandatory): in Message Bar section mark “Never show information about blocked content”, and in EXCEL in section External Content mark “Enable all Data…”, “Enable automatic updates …” and  “Enable all Linked data …”.
  • open OUTLOOK and go to: Options-> Trust Center-> Trust Center Settings-> Programmatic Access: The “Antivirus status” must be “Valid”, if the status is different, you must update your anti-virus application! If not, Outlook will generate below popup window while trying to send email by VBA. If the setting “Never warn me about suspicious activity (not recommended)” is available then you can turn it on and that’s OK for VbaRobot.

read more about Outlook settings on https://support.microsoft.com

  • open Internet Explorer and add www.w3schools.com to “Allowed sites” (it’s used in example process “PN_ExampleInternetExplorer_API”) :
  • check if your Office (not Windows !) installation type is 32 bits or 64 bits:
  • you can find procedure on Microsoft site: (click below link):
  • … or you can find on other site: (click below link):

ONLY 64 bits Office can by used with VbaRobot system !

If you have 32-bit Office, you’ll need to reinstall the 64-bit package.

2) Download 7-zip package and get “6×8 Comp stamp” from VbaRobotServer file:
  • download one appriopiate 7-zip package depend on availability of SAP system:
  • standard package (most of users): VbaRobot64,
  • or extended package for users having SAP installed:  VbaRobot64_SAP (our example requires access to ME91F trans.).
  • extract 7-zip package to folder “c:\VbaRobot\” (you must use this folder to run our examples correctly!),
  • open file “VbaRobotServer.accdb” and copy “6×8 Comp stamp” from window  “UnlockKeys” (point 2).

(*)“6×8 Comp stamp” format is: “xxxxxx-xxxxxx-xxxxxx-xxxxxx-xxxxxx-xxxxxx-xxxxxx-xxxxxx” , “x” can be one of 0-9,A,B,C,D,E,F.

3) Get by email “6×4 BusinessKey” to unlock VbaRobot system:
  • go to promotion page:
  • type in”4×4 Promotion code” 7777-7777-7777-7777, type in “6×8 Comp stamp” from VbaRobotServer, type in other info + tick privacy and click “SEND ME PROMOTION BUSINESS KEY” to generate “6×4 BusinessKey” by email
  • promotion BusinessKey will be send out immediately on your email address.

(*) “4×4 Promotion code” format is: “xxxx-xxxx-xxxx-xxxx” , “x” can be one of 0-9.
(*) “6×4 BusinessKey” format is: “xxxxxx-xxxxxx-xxxxxx-xxxxxx” , “x” can be one of 0-9,A,B,C,D,E,F.

4) Activate VbaRobotServer:
  • after receiving your “6×4 BusinessKey” by email open again “VbaRobotServer.accdb”, window “UnlockKeys” should appear -> follow the steps below:
  • go to point 1 on window: read and accept the terms in End User Licence Agreement (EULA),
  • go to point 4 on window: mark one of checkbox to unhide field: “BusinessKey”,
  • enter your “6×4 BusinessKey”,
  • you can check the license expiration date by clicking “Check Key”,
  • click green button “Open VbaRobotServer….”.
  • if everything OK VbaRobotServer front page should appear, installation is completed!
  • before using VbaRobotServer read info in file “ReadMe before first use of VbaRobotServer”.

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