looping through folders - saving xls files as PDFs

Hi,

I've written code in one worksheet module that I'm using to loop through multiple folders containing dozens of xls files. Each file is of the same format with multiple graphs and 3 tables of data. The charts and tables (which are linked from a second tab in the workbook) are manipulated then the active sheet is saved as a PDF file.

Everything runs fine except that I'm updating the headings on each of the 3 tables with 3 character acronyms for the department that the report is for. When I step through the code it's great, pdf saves and the proper headings are there. When I let the code run the updated headings are not there, the default title is.

I've tried everything i can think of. I ended up writing code to copy each table and pasted it over the original table, which seemed to work for a while, but that didn't last. Default titles returned.

Anyway, I'm using Excel 2010

Any thoughts.