How to return a result from VBA function?

As You may know, in general in programming to return a result from function there is Return statement. Even Visual Basic has it. Unfortunately there is no such thing in VBA. In this article I’m going to show You how to return a result from VBA function.

Continue reading “How to return a result from VBA function?”

How to destroy Scripting Dictionary?

I love dictionaries! This is amazing object to create magical list of anything and to find any in just a second! But after they are not in use anymore, how to set them to nothing? How to destroy Scripting Dictionary?

Continue reading “How to destroy Scripting Dictionary?”

Google Chrome automation with Selenium Basic

In my previous article I showed You how to scrap websites using good old buddy Internet Explorer. It is ok, but in case of more complex Java Script frontend sites our good old buddy might be not enough. In this post I will show You what You need to do to create web automation using Chrome with Selenium Basic.

Continue reading “Google Chrome automation with Selenium Basic”

Add signature to your automated emails

Tired of issues connected with email automation in Outlook application? Here is another one! In todays article we are going to get rid of it and learn how to add signature to your automated emails.

Continue reading “Add signature to your automated emails”

Update PowerPoint chart data from Excel

We all know that in general Excel application is for calculations and PowerPoint is for visual presentation. So all the data is prepared in worksheet, based on which all the charts in PowerPoint are created. In this article I will show You how to update PowerPoint chart data from Excel using VBA.

Continue reading “Update PowerPoint chart data from Excel”

Prevent formatting text as date by Excel

How many times You just wanted to type some numbers diveded with slash, dot or hiven and Excel was converting into date automatically and You didn’t want that at all? In this article I will show You how to prevent formatting text as date by Excel.

incel #excel - zapper-nunczako-vat - Wykop.pl
Continue reading “Prevent formatting text as date by Excel”