ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I run a macro program for multiple workbooks at one time? (https://www.excelbanter.com/excel-programming/332970-how-do-i-run-macro-program-multiple-workbooks-one-time.html)

Marcelino

How do I run a macro program for multiple workbooks at one time?
 
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[_2_]

How do I run a macro program for multiple workbooks at one time?
 
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" wrote in message
...
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.





All times are GMT +1. The time now is 04:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com