Winston,

There is no way to determine whether a workbook has a macro
or not without attempting to open it.
If you set your security level to "Medium", you'll be prompted
to "Enable Macros" if one is found in the workbook.
Be aware though that getting the prompt doesn't necessarily
mean that there "are" macros in the workbook. An empty module
or some errant code in the workbook will also trigger the prompt.

John

"Winston Lee" wrote in message
...
Hi All:
I have a lot of Excel files. I hope to demarcate
the Excel files that have macro. Is there any tools or how
to program ?


Thanks
Best Regards