Hi all

I have 2 Excel Workbooks - WB1.XLS & WB2.XLS

WB2 has cells with formula link to cell values in WB1
WB2 also has so macro to create charts from some data range that is linked to WB1

If I change the cell values in WB1, is there a way to refresh the cells in WB2 programtiaclly without opening WB2

Is there a way to run the macro in WB2 to refresh the charts in WB2 and also print charts in WB2 to a PDF file programatically?

Your advice much appreciated.

Thanks & Best Regards