VBA/Macro to automate clicking multiple buttons

Hi

I have a task I perform weekly where I need to press an 'Update' button on 6 different spreadsheets. I just wondered how easy it would be for me to create a macro or some VBA to automate this?

It would need to open a file, press 'Update' on the first pop-up, then click the actual 'Update' macro button that updates the data in the sheet from a Pi-Datalink and then save the file, close the file and repeat the process for the other 5 files.

I'm wondering if anyone could help with that, as I have no experience with VBA.

Many thanks in advance.

The macro below assumed that you know the name of the sub which assigned to the "Update" button,
the name of the sub (for the update) are all the same on all of the six workbooks,
and all the six workbooks are in one folder without any other file.

Make a new workbook, put the macro in the workbook module :

Please Login or Register  to view this content.

From the macro above,
all the six workbooks are in drive D folder test,
and the macro name is test on all of the six workbooks.
Change the directory and the name of the "Update" button sub as needed.

When you open the workbook with that macro above,
it will open each of the workbbok di drive D:/test, run the test Sub on each wb, save then close it.