Need to save changes in a external linked file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List ConnectionString of linked, external Excel file 2
Linked workbooks 1
Save Date in File Name 3
List Box Linked Cell loses connection 1
Copy value from changing cells without VBA 1
Control of links 2
How to reference a file in a different instance of Excel? 4
How to open each file from the folder and save again 4

Back
Top