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..

-retz (July 27, 2014, 09:56 PM)

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

[Target]

thanks skwire