Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
tse tse is offline
external usenet poster
 
Posts: 4
Default 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,


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default 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,


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked spreadsheets failing to recognised that the linked file is Michael Excel Discussion (Misc queries) 0 January 14th 10 12:03 PM
Displaying linked data in excel 2007 when linked file is not avail Eng_19 Excel Discussion (Misc queries) 0 December 7th 07 07:27 PM
Cannot save external data into file excel system show not respondi Domino415 Excel Discussion (Misc queries) 0 May 31st 06 09:01 AM
External link only works for numbers -- for text values, #N/A is displayed unless linked file is open Sven Filter Links and Linking in Excel 1 February 22nd 05 08:10 AM
Save without prompted and activate external file mok707 Excel Programming 1 August 19th 04 05:57 AM


All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"