View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Daffo Daffo is offline
external usenet poster
 
Posts: 13
Default how to track changes made to a excel sheet using VisualBasic

Hi everybody, i want to know how to track changes made to a excel sheet
using VB. suppose i open a file by name car3.xls. i make some data
changes, changes in the formula, add data to a cell etc. Now i should
be able to track all these changes made to car3.xls programatically
using VB.

I am able to open car3.xls and access the file and get the list of
formulas in the workbook using VB. But i am not able to track the
changes made to the file programatically using VB. It would like to
avoid using VB macros for this purpose.
Can anyone please suggest me how to start and any usefull links. which
is the best way to accomplish this.


With Regards,
Daffo