DonationCoder.com Software > Finished Programs

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

(1/3) > >>

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

Navigation

[0] Message Index

[#] Next page