Perform file data comparision?

  • Thread starter Thread starter Rich Wallace
  • Start date Start date
R

Rich Wallace

All,

I need to write up a solution that will trap an Excel spreadsheet when a
user opens it and after they make changes to the file, I need to 'copy' the
new saved version of the spreadsheet and perform a comparision so that I
cand extract only those Cells that have been altered since it was opened.

I've looked into using WithEvents and Delegates options but I don't
necessarily need the changed data on an event drive basis as far as
immediate changes to a cell are made.

I'm trying to generate an XML representation of data changes but I'm
currently only able to write teh XML each time the spreadsheet is saved,
which makes for a very large XML document. Here is a logical idea of what
I'm trying to do:

1. When a spreadsheet is opened, maintain a copy of it before it is altered
2. User updates the spreadsheet, saves and closes
3. Upon the closing of teh spreadsheet, I grab a new copy of the saved
spreadsheet
4. Perform a side by sid ecomparison to locate the cells and data of what
was changed.
5. Create XML off of changes cells only

Any ideas?

TIA
-Rich
 
Any ideas?

I dont know what im talking about here which is not unusual... but
dont office programs maintain version changes internally? Maybe there
is something in the Excel object model that you can tap into?

hth

Richard
 
I'm still fairly new in the Office 'development' area so I'm not too sure
either. So far I'm able to generate two copies of the file based on the
original version and the changed version of the file, I'm just trying now to
run the comparison against the two files and only extract the changed values
and place them into an XML file.
 
Back
Top