Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Get information on changed cells


Hi,
I am using vb application to load and save excel data. I want to kno
if there is a way to get information only of changed/modified cell
when we are to save excel file.
Presently I am using Excel ADO recorset for reading all columns an
rows.
Thanks in advanc

--
****i
-----------------------------------------------------------------------
****ij's Profile: http://www.excelforum.com/member.php...fo&userid=2514
View this thread: http://www.excelforum.com/showthread.php?threadid=39092

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Get information on changed cells

I think the only way would be to keep track of each change while it happens.

Or maybe compare an old version with a new version (sounds like way too much
could go wrong).

Or maybe turn on track changes (also means that the workbook will be shared,
yech!).



****ij wrote:

Hi,
I am using vb application to load and save excel data. I want to know
if there is a way to get information only of changed/modified cells
when we are to save excel file.
Presently I am using Excel ADO recorset for reading all columns and
rows.
Thanks in advance

--
****ij
------------------------------------------------------------------------
****ij's Profile: http://www.excelforum.com/member.php...o&userid=25145
View this thread: http://www.excelforum.com/showthread...hreadid=390925


--

Dave Peterson
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
How do I lock/protect cells so they can't be changed Julie Excel Worksheet Functions 3 November 4th 06 03:49 AM
How to found changed cells? slaya_cz Excel Discussion (Misc queries) 1 July 14th 06 03:24 PM
... After I protected my worksheet, some cells can be changed... Dr. Darrell Setting up and Configuration of Excel 3 February 25th 06 02:23 PM
keep specific cells from being changed. bronsonbits Excel Discussion (Misc queries) 1 September 7th 05 06:44 PM
Save only new or changed cells JR[_4_] Excel Programming 1 December 15th 03 05:14 PM


All times are GMT +1. The time now is 05:11 PM.

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

About Us

"It's about Microsoft Excel"