View Single Post
  #8   Report Post  
Old March 7th 11, 08:46 PM posted to microsoft.public.excel.programming
Nasir[_2_] Nasir[_2_] is offline
external usenet poster
First recorded activity by ExcelBanter: Dec 2010
Posts: 9
Default 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.

Clif McIrvin

(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
1) ScanWorkbooks
2) ProcessWorkbooks
3) FormatWorksheet

When I run ScanWorkbooks it stops at this line giving error....Sub or
Function not defined

If xOpenWorkbook(LongName:=LongName)

I need your help please