How to use Invoke VBScript and Get/Set Excel Settings

Learn Video Tutorials
, , , , , , , , , ,
1

How to automate excel using the background?

You can work with excel in the background. If you wonder how?! - with the help of visual basic scripting.

When it comes to Automation it is an essential to make our bots stable as possible and there is nothing more stable than the background automation. When we avoid clicking in the UI we are avoiding possibilities this bot to crash due to loading screens and unexpected pop-ups.
Excel is a program used in every company and to be able to automate excel in the most stable way it will bring your bots to the next level.

If you wonder how, you can extract valuable information from excel like:
image
custom decimal separator, thousand separator and UseSystemSeparator and many more settings.

Here is a YouTube video how you can do it: