Going from one excel spreadsheet into others

Closed
Neil - Dec 5, 2011 at 01:50 PM
 Blocked Profile - Dec 6, 2011 at 12:05 AM
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 ?
Related:

1 response

Blocked Profile
Dec 6, 2011 at 12:05 AM
Greetings,

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.
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse

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.

Moderator
0