removing date field from custom footer...

[z07924]

I have 1000's of excel files to convert to PDF. All these files have date field in the footer section.
How do I remove them (or prevent update to date) from the file before doing the conversion...Any help would be appreciated. thanks in advance.

 

[ssVBAdev]

In VBA you couls use:

Worksheets("Sheet1&quot.PageSetup.CenterFooter = ""

For example.


********************
What's the best way to get the answers you need?? See FAQ222-2244 for details!

 

[z07924]

Thanks...the following code returns wrong number of sheets...(there are only 10 sheets in this workbook..but it returns 12)

For i = 1 To ActiveWorkbook.Sheets.Count
Sheets(i).PageSetup.LeftFooter = ""
Next i

any idea / any other way opf doing this? thanks.

 

[ssVBAdev]

Sounds as though there are some sheets hidden.

In the "Project Explorer" pane of your VBA IDE are all the sheets that you would expect to see there, or are there more sheets?

The ActiveWorkbook.Sheets.Count will count all the sheets in the workbook, even the ones that are "xlSheetVeryHidden". So there may be a sheet that you cannot see a tab for, nor view using the "Format-Sheet-Unhide".

********************
What's the best way to get the answers you need?? See FAQ222-2244 for details!