Engineering and software development have one thing in common: 
problem-solving!

Laptop Top Header

Our top articles


Check these VBA geocoding functions that can be used to retrieve the latitude and the longitude of a given address. The functions using the Google Geocoding API to get the necessary data from Google servers, so a valid API key is required.

Our recent articles 

Mesoscale Modeling Of The Impacts Of Congestion And ITS Measures On Vehicle Energy Consumption And Greenhouse Gas Emissions Over Urban Road Networks

An executive summary of my Ph.D. thesis dealing with mesoscale modeling of GHG emissions in urban road networks.

read more

Learn how to add records from an Excel worksheet into an existing Access table both manually and through VBA code.

Do you know how to extract chart data with VBA? If not, in this article you will learn how to avoid cases where you receive a chart but not the actual data.

What readers say

Tyler k.

After banging my head against the wall for weeks trying to figure out a better way to do things, I came across your script mWritePDFForms that takes a PDF template and creates one re-populated file per spreadsheet row. It is amazing!

Neil G.

I am writing out of the blue to say thanks – years ago, you wrote code to copy and paste charts into PowerPoint, I stumbled on it recently, and it has been a Godsend. An epic little bit of coding that I use all the time now, so I thought I would personally thank you!

Detlef H.

I'm a newbie in VBA. Your tutorials are the best on the web. Thanks a lot!

Emina C.

Thank you so much for this code! It works wonderfully, and it is the best I have seen so far.

Our Stats

170+

Articles Published

1000+

Emails Answered

700+

Comments Answered


Our main categories


Do you know how to extract chart data with VBA? If not, in this article you will learn how to avoid cases where you receive a chart but not the actual data.

Read More

Face detection in Excel? Sounds crazy, isn’t it? However, a combination of Artificial Intelligence, C#, and VBA can do this in a few seconds!

Read More

Do you know how to enhance the functionality of VBA by using an external C# console application? Sure, it is not easy but can work wonders!

Read More

Do you know how to scrape a web page and get information from all the images that it contains? Are you interested in learning how to retrieve the width and the height from a given image URL? The two macros have the answers.

Read More

Do you need a personalized solution?

If you cannot find a tutorial that fully covers your needs, contact us!

Learn how you can get a free API key from Google. A step-by-step tutorial with many images that will show you exactly how to obtain an API key, as well as how to use it in VBA. The tutorial is updated based on the latest Google API changes (summer 2018).

A collection of some useful resources related to hydroelectric studies. The files and the links will help you learn more about the potential and the advantages of small hydropower plants.

Do you know anything about pressure vessels? If not, then this short presentation will give you a good start on this enormous engineering topic.

About

Hi, I am Christos Samaras, a Mechanical Engineer by profession and a Software Developer by obsession! I hold a Ph.D. degree in Mechanical Engineering, and I develop software for more than ten years.


I founded this site in 2011 to help you solve your engineering and programming problems. If you need to contact me, check this page.


I hope you enjoy your stay here!

Tips for solving Engineering & Software problems

Join our monthly newsletter and get some great tips straight to your inbox!

>