Need to Customize Existing Excel Files in New Format

  • Thread starter Thread starter Nada
  • Start date Start date
N

Nada

Well,

I need to open old, existing excel files and when I do open it they al
should be in a new customized format; i.e. header/footer.

this is URGENT!!!:(


HELP!!!!!
 
Hi
not fully automatic but you may try the following:
1. Create a macro (store it in your Personal workbook)
Public Sub Change_Header_Footer()
Dim wkSht As Worksheet
For Each wkSht In Worksheets
With wkSht.PageSetup
.CenterHeader = Format(Now, "mm-dd-yyyy")
' enter your specific format here
End With
Next wkSht
End Sub

To get your custom style you may record a macro while changing one
header/footer and paste this code in the above procedure

2. Assign a button/toolbar to this macro and start it after opening a
workbook

HTH
Frank
 
just need some more help......

well i think that the button that you told be and the code....it just
sufficient.........

but is there anyway to create a template and have it open as a default
template when you open excel everytime....

there is a folder called 'XLStart' in which we can add workbook files:
'xls' but we cannot put template files which have customized
headers/footers: xlt....

cuase as a default 'book1' opens which is blank....but i want to
customize a template that opens as a defaullt everytime we open
excel.......

can this be done??
 
If you save that template file in your XLStart folder with a name of Book.xlt,
then it should be used each time you create a new workbook in excel.
 
Back
Top