Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook with macro
Hi all.
I have Excel 2003. I have several excel files in a folder. How determine if there are files with macro i.e. vba code and have a detailed list in a sheet? Example: a1 mary.xls has macro a2 john.xls no macro ... Regards, John. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook with macro
Hi John
See if this works for you: http://www.mvps.org/dmcritchie/excel/code/listfsubs.txt it's written for "all open workbooks". To open-perform-close all workbooks in a folder, see http://www.contextures.com/xlfaqMac.html#LoopBooks HTH. Best wishes Harald "Big John" wrote in message ... Hi all. I have Excel 2003. I have several excel files in a folder. How determine if there are files with macro i.e. vba code and have a detailed list in a sheet? Example: a1 mary.xls has macro a2 john.xls no macro .. Regards, John. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook with macro
Thanks Harald.
Best wishes, John. "Harald Staff" ha scritto nel messaggio ... Hi John See if this works for you: http://www.mvps.org/dmcritchie/excel/code/listfsubs.txt it's written for "all open workbooks". To open-perform-close all workbooks in a folder, see http://www.contextures.com/xlfaqMac.html#LoopBooks HTH. Best wishes Harald |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving macro from workbook to Personal Macro Workbook | Excel Discussion (Misc queries) | |||
How do I call up a line of code that references a cell/range in theactive workbook workbook where I am running my macro from? | Excel Programming | |||
Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
Excel Gurus = want a macro in 1 workbook to get info from another workbook = Read please | Excel Programming |