Welcome Guest.   Make a donation to an author on the site July 28, 2014, 05:36:21 PM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
View the new Member Awards and Badges page.
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
Pages: [1]   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: DONE: Batch format editting in multiple sheets in multiple excel files in folder  (Read 494 times)
retz
Participant
*
Posts: 7

View Profile Give some DonationCredits to this forum member
« on: July 26, 2014, 08:26:16 PM »

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!!!
Logged
Target
Honorary Member
**
Posts: 1,389



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #1 on: July 27, 2014, 06:08:52 PM »

what fonts and sizes?
Logged

"Look wise, say nothing, and grunt. Speech was given to conceal thought" - Sir William Osler
retz
Participant
*
Posts: 7

View Profile Give some DonationCredits to this forum member
« Reply #2 on: July 27, 2014, 06:10:46 PM »

Times New Roman / 12

and for the title cells A1 in all the files and sheets Times new roman / 14
Logged
Target
Honorary Member
**
Posts: 1,389



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #3 on: July 27, 2014, 08:34:46 PM »

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:55 PM by Target » Logged

"Look wise, say nothing, and grunt. Speech was given to conceal thought" - Sir William Osler
retz
Participant
*
Posts: 7

View Profile Give some DonationCredits to this forum member
« Reply #4 on: July 27, 2014, 08:35:48 PM »

Will do.. Thank you so very much!!!!!
Logged
retz
Participant
*
Posts: 7

View Profile Give some DonationCredits to this forum member
« Reply #5 on: July 27, 2014, 08:46:58 PM »

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



* Capture.JPG (183.42 KB, 1919x1040 - viewed 7 times.)
Logged
Target
Honorary Member
**
Posts: 1,389



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #6 on: July 27, 2014, 09:11:52 PM »

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:02 PM by Target » Logged

"Look wise, say nothing, and grunt. Speech was given to conceal thought" - Sir William Osler
retz
Participant
*
Posts: 7

View Profile Give some DonationCredits to this forum member
« Reply #7 on: July 27, 2014, 09:25:06 PM »

Still gives me the same message...
Logged
Target
Honorary Member
**
Posts: 1,389



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #8 on: July 27, 2014, 09:35:09 PM »

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

try this...

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

"Look wise, say nothing, and grunt. Speech was given to conceal thought" - Sir William Osler
retz
Participant
*
Posts: 7

View Profile Give some DonationCredits to this forum member
« Reply #9 on: July 27, 2014, 09:38:54 PM »

Nop, it gave me the same message as before... Thanks for trying though, I really do appreciate it mate!!!
Logged
Target
Honorary Member
**
Posts: 1,389



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #10 on: July 27, 2014, 09:42:37 PM »

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


* DC_Fonts.zip (17.82 KB - downloaded 5 times.)
Logged

"Look wise, say nothing, and grunt. Speech was given to conceal thought" - Sir William Osler
retz
Participant
*
Posts: 7

View Profile Give some DonationCredits to this forum member
« Reply #11 on: July 27, 2014, 09:56:31 PM »

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..
Logged
Target
Honorary Member
**
Posts: 1,389



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #12 on: July 27, 2014, 10:08:42 PM »

you're most welcome Thmbsup
Logged

"Look wise, say nothing, and grunt. Speech was given to conceal thought" - Sir William Osler
skwire
Moderator
*****
Posts: 4,019



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #13 on: Today at 12:40:00 AM »

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.  =]
Logged

Target
Honorary Member
**
Posts: 1,389



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #14 on: Today at 01:28:42 AM »

thanks skwire Thmbsup
Logged

"Look wise, say nothing, and grunt. Speech was given to conceal thought" - Sir William Osler
Pages: [1]   Go Up
  Reply  |  New Topic  |  Print  
 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.067s | Server load: 0.06 ]