Going from one excel spreadsheet into others
Closed
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 ?
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:
- Going from one excel spreadsheet into others
- Excel mod apk for pc - Download - Spreadsheets
- Google spreadsheet right to left - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Insert gif into excel - Guide
- Excel spreadsheet formulas - Guide
1 response
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
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