View Single Post
  #7   Report Post  
Old March 7th 11, 02:34 PM posted to microsoft.public.excel.programming
Clif McIrvin[_3_] Clif McIrvin[_3_] is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2011
Posts: 203
Default Macro to run on all files in a folder but exclude sheets with Pivot Table, Pivot Charts and Charts

"Nasir" wrote in message
On Mar 6, 5:15 am, "Clif McIrvin" wrote:
"Clif McIrvin" wrote in message



I cannot make it work
There are three differenct macros now..
I wanted to have one macro for my purpose..pardon my ignorance please


Hi Nasir .... I won't attempt a detailed tutorial of what and why behind
the code I offered; but I will try to answer any specific questions you

Start with AB's (Thank you AB!) reply to your post - launch
ScanWorkbooks which will call the other procedures as needed.

These newsgroups are a good place to ask questions --- there are many
here who are happy to help others learn. All we ask in return is for you
to try and understand our suggestions; and to ask specific questions
when we leave you confused.

Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)