General information
Category:
COM/DCOM and OLE Automation
Environment versions
Network:
Windows 2003 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only