Need to save changes in a external linked file
 

Hi all,

I need to save or Highlighted the changes in a WB with external links.
I need to receive some information like: cells changed, date, user.
Anyone knows some possibility to solve this problem?
Thanks a lot to all,

Need to save changes in a external linked file
 

Here is a very simple trick:

1. make 2 copies of the workbook, each with a different name
2. open them both, one with links refreshed, one without the refresh
3. write some simple VBA to do a sheet-by-sheet cell-by-cell comparison
--
Gary''s Student - gsnu200741


"Tse" wrote:

Hi all,

I need to save or Highlighted the changes in a WB with external links.
I need to receive some information like: cells changed, date, user.
Anyone knows some possibility to solve this problem?
Thanks a lot to all,