Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Scripting Excel Formatting over multiple files that exist in 1 folder
I'm thinking this shouldn't be this difficult... (but finding it to be so) My vbs script produces data to 35 separate Excel Workbooks in a common folder. Each Workbook has a different name (account number -currentdate-.xls). I have written the script to format the workbooks (which works great...
