Macro to run multiple macros across multiple workbooks


I have written 8 macros, 7 of them need to be called in order (1,2,3,4,5,6,7) on a sheet, when thats done i need it to loop through all of the sheets sheets in the workbook doing the same.

The macro #0 needs to be called first and only needs to be called once on each workbook.


When its done with that workbook i need it to loop through all of the workbooks in the folder doing the same thing... THIS IS THE BIT I NEED WRITING

I have already writen the 8 macros and writen the macro to loop through the sheets but i am having difficulty making it loop though all the workbooks in a folder.

For setup speeds sake i only want to have to add the 8 macros to one workbook, and run it from there, not add each macro to each workbook of them as this would take a long time.

I need the macro to be modular so i can make changes to any of the 8 macros if needed. I would also like the 8 macros to be called externally rather than one very long macro combining them all.


Please see the attached file for the 8 macros (.txt files) ive already writen, plus the macro that calls them in order on each sheet, plus the data (please note at the moment each workbook data is just a copy of each other, but when i run them they will all have unique sets of data).

Please indicate how long this will take you in your bid. ( i think its a pretty simple task but i just cant seem to get it ..)

If you've got any questions please dont hesititate to ask

UPDATED .... the attached file didnt seem to come across please see it below, cheers

UPDATE AGIAN... trying for the 3rd time to attach the file dosnt like to work for some reason, if its still not there you can get it from www.pudle.co.uk/data+macros.zip


Kemahiran: Pemprosesan Data, Excel, Visual Basic

Lihat lagi: run macro across multiple workbooks, run multiple macros, macro run multiple macros, macro across multiple workbooks, run multiple workbook macro, run macro multiple workbooks, writing sheets, writing macros, sheets add, difficulty writing, writing on multiple, simple macro, sake, run, run sheet, make loop, macro, across multiple, file multiple files, add macros, simple multiple, macro add, data processing setup, txt processing, simple questions task

Tentang Majikan:
( 12 ulasan ) london, United Kingdom

ID Projek: #1530730

Dianugerahkan kepada:


Excel expert. Please see your messages. Thanks

$8 USD / jam
(65 Ulasan)

11 pekerja bebas membida secara purata $7/jam untuk pekerjaan ini


You will need my function which available in your pmb now.

$9 USD / jam
(85 Ulasan)

Ready to [login to view URL] your attachment,please.

$8 USD / jam
(52 Ulasan)

I've done it, please check the PMB for detail, looking forward to working with you, Cuong NH

$5 USD / jam
(30 Ulasan)

Many years experience in Excel-VBA. Please check your PBM. Thanks!

$8 USD / jam
(14 Ulasan)

Please see PM for detailed proposal. Thanks!

$7 USD / jam
(9 Ulasan)

For this project, I would create an Excel macro add-on that would: 1.) Use the VBA "Windows File/Folder Dialog" to allow you to select the target folder containing the files. 2.) Loop through each XLS or XLSX file in Lagi

$7 USD / jam
(7 Ulasan)

I have written many macros like this before, if you award me the bid I can turn it around for you today.

$10 USD / jam
(0 Ulasan)

I work for a multinational CMMI-5 company (can give proof if required) into MIS REPORTING and have extensive knowledge of macros. I can do this. Do let me know if you are interested.

$8 USD / jam
(1 Ulasan)

i always ready to start

$8 USD / jam
(0 Ulasan)

Sir, i am capable of doing this job.

$4 USD / jam
(0 Ulasan)

I have Profit and Lose and Balace sheet with macro and meniu.

$8 USD / jam
(0 Ulasan)