Macro to run on all files in a folder but exclude sheets withPivot Table, Pivot Charts and Charts
On Mar 7, 6:34*pm, "Clif McIrvin" wrote:
"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.
(clare reads his mail with moe, nomail feeds the bit bucket :-)
Hello Clif and AB
Thanks for the reply
I posted the 3 macros in a module
When I run ScanWorkbooks it stops at this line giving error....Sub or
Function not defined
I need your help please