How do I run a macro program for multiple workbooks at one time?

[Marcelino]

How do I run a macro program for multiple workbooks at one time?

Basically I'm looking to run a query where I ask the cpu to tell me if two
cells have content or not. I want to run or creat a query program with Macro
to do this for me. I open to any suggestions including looking at using
something other than a macro. But I want to avoid manually looking at each
workbook if possible.

[Anne Troy]

Marcelino: These two macros ought to be able to get you started.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=305
http://www.vbaexpress.com/kb/getarticle.php?kb_id=9
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Marcelino" <[email protected]> wrote in message
news:[email protected]...
> How do I run a macro program for multiple workbooks at one time?
>
> Basically I'm looking to run a query where I ask the cpu to tell me if two
> cells have content or not. I want to run or creat a query program with
Macro
> to do this for me. I open to any suggestions including looking at using
> something other than a macro. But I want to avoid manually looking at
each
> workbook if possible.