DONE: Batch format editting in multiple sheets in multiple excel files in folder

[retz]

I'm not a coder, but I'm pretty sure there must be a way to get this done.... So the problem/task is the following:

I have a folder containing many excel files, which contain many sheets. My goal is to batch edit the formatting (font/size) of all sheets in all excel files without having to manually and individually do it for each excel file and each sheet contained in each said excel file. is there a way to do this??

Now, this here is a plus, but only if it's possible, on a separate folder I also have many excel files with many sheets, now, each sheet has a title on cell A1 which I would also like to format edit (font/size) since they are the title to each different subject represented in each different sheet, is it possible to batch edit the formatting in a specific cell for all files and its sheets??

Thank you whoever you are!!!

[Target]

what fonts and sizes?

[retz]

Times New Roman / 12

and for the title cells A1 in all the files and sheets Times new roman / 14

[Target]

try this (excel vba macro)

tests OK here, but YMMV so try it on some test files first

any problems let me know

EDIT: redundant attachment removed

[retz]

Will do.. Thank you so very much!!!!!

[retz]

Well, I got a strange message about updating the code to x64 bits which is my operating system... I will attach here a screen capture...

[Target]

ahh, I only have x32 at work...

don't know if this will work or not (I can't test it) but try this (x64 only if anyone else wants to try it)

EDIT: redundant attachment removed

[retz]

Still gives me the same message...

[Target]

sorry, I'm working blind here cos I can't test...

try this...

EDIT: redundant attachment removed

[retz]

Nop, it gave me the same message as before... Thanks for trying though, I really do appreciate it mate!!!

[Target]

sorry, just had an AHA!! moment (that bit of code was unnecessary for this routine...)

[retz]

Oh hell yeah!!!! it worked like a frigging charm, you're the man!!!!!!
Thank you so very much, you have saved me so many hours worth of fool errands..

[Target]

you're most welcome

[skwire]

Well done, Target.    I'll move this to the finished section.

Oh hell yeah!!!! it worked like a frigging charm, you're the man!!!!!!
Thank you so very much, you have saved me so many hours worth of fool errands..

If you have the means, don't hesitate to toss some DC credits Target's way.  =]

[Target]

thanks skwire