topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Thursday March 28, 2024, 7:30 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: DONE: Batch format editting in multiple sheets in multiple excel files in folder  (Read 9578 times)

retz

  • Participant
  • Joined in 2014
  • *
  • default avatar
  • Posts: 7
    • View Profile
    • Donate to Member
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

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 1,832
    • View Profile
    • Donate to Member
what fonts and sizes?

retz

  • Participant
  • Joined in 2014
  • *
  • default avatar
  • Posts: 7
    • View Profile
    • Donate to Member
Times New Roman / 12

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

Target

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 1,832
    • View Profile
    • Donate to Member
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
« Last Edit: July 27, 2014, 09:43 PM by Target »

retz

  • Participant
  • Joined in 2014
  • *
  • default avatar
  • Posts: 7
    • View Profile
    • Donate to Member
Will do.. Thank you so very much!!!!!

retz

  • Participant
  • Joined in 2014
  • *
  • default avatar
  • Posts: 7
    • View Profile
    • Donate to Member
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

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 1,832
    • View Profile
    • Donate to Member
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
« Last Edit: July 27, 2014, 09:36 PM by Target »

retz

  • Participant
  • Joined in 2014
  • *
  • default avatar
  • Posts: 7
    • View Profile
    • Donate to Member
Still gives me the same message...

Target

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 1,832
    • View Profile
    • Donate to Member
sorry, I'm working blind here cos I can't test...

try this...

EDIT: redundant attachment removed
« Last Edit: July 27, 2014, 09:43 PM by Target »

retz

  • Participant
  • Joined in 2014
  • *
  • default avatar
  • Posts: 7
    • View Profile
    • Donate to Member
Nop, it gave me the same message as before... Thanks for trying though, I really do appreciate it mate!!!

Target

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 1,832
    • View Profile
    • Donate to Member
sorry, just had an AHA!! moment (that bit of code was unnecessary for this routine...)


retz

  • Participant
  • Joined in 2014
  • *
  • default avatar
  • Posts: 7
    • View Profile
    • Donate to Member
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

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 1,832
    • View Profile
    • Donate to Member
you're most welcome :Thmbsup:

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Well done, Target.   :Thmbsup:  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

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 1,832
    • View Profile
    • Donate to Member
thanks skwire :Thmbsup: