Going from one excel spreadsheet into others

 Blocked Profile -
Hi everyone,

Another newbie here.

I have one main excel spreadsheet and I need a macro that looks in a specific folder with 48 individual excel spreadsheets in it.

each one of the 48 spreadsheets has a button to clear that sheet for the start of the next day.

I would like to create a macro that automatically looks in the specific folder, opens each one of the 48 excel files, presses the clear sheet button that I created and goes through all 48.

can anyone help me ?

1 reply


Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must copy, modify and repost your message respecting the politeness charter.

We trust that you understand.