| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to track changes made to a excel sheet using VisualBasic
I wouldn't know where to start.
But have you looked at Tools|Track Changes. It requires that the workbook be shared and there are lots of things that are not available in shared workbooks. But maybe it'll be sufficient for you. Daffo wrote: 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 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to track changes made to a excel sheet using VisualBasic
Hi Dave, i dont want to do it by using Tools| Track Changes. I want to
track changes programatically from VB. With Regards Daffo Dave Peterson wrote: I wouldn't know where to start. But have you looked at Tools|Track Changes. It requires that the workbook be shared and there are lots of things that are not available in shared workbooks. But maybe it'll be sufficient for you. Daffo wrote: 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 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to track changes made to a excel sheet using VisualBasic
Good luck.
Daffo wrote: Hi Dave, i dont want to do it by using Tools| Track Changes. I want to track changes programatically from VB. With Regards Daffo Dave Peterson wrote: I wouldn't know where to start. But have you looked at Tools|Track Changes. It requires that the workbook be shared and there are lots of things that are not available in shared workbooks. But maybe it'll be sufficient for you. Daffo wrote: 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 -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to track changes made to a excel sheet using VisualBasic
Hi Dave, thak you.
Dave Peterson wrote: Good luck. Daffo wrote: Hi Dave, i dont want to do it by using Tools| Track Changes. I want to track changes programatically from VB. With Regards Daffo Dave Peterson wrote: I wouldn't know where to start. But have you looked at Tools|Track Changes. It requires that the workbook be shared and there are lots of things that are not available in shared workbooks. But maybe it'll be sufficient for you. Daffo wrote: 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 -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to track changes made to a excel sheet using VisualBasic
I didn't mean to sound to flip, but there are a lot of things that the user can
change--values, formulas, formatting, insertion/deletion of ranges (including whole rows/columns). Insertion/deletion of worksheets. Adding/deleting shapes, names, charts and graphs, ... Good gawd, there's a lot of stuff that anyone can do. ======== On the other hand, if your workbook is restricted (no inserting of rows/columns/ranges) and you only want to find the differences (not keep track), you could look at how Myrna Larson and Bill Manville did it: http://www.cpearson.com/excel/whatsnew.htm look for compare.xla This does a cell by cell compare (a1 with a1, x99 with x99) and you have to have a copy of the before to be able to find the changes. Daffo wrote: Hi Dave, thak you. Dave Peterson wrote: Good luck. Daffo wrote: Hi Dave, i dont want to do it by using Tools| Track Changes. I want to track changes programatically from VB. With Regards Daffo Dave Peterson wrote: I wouldn't know where to start. But have you looked at Tools|Track Changes. It requires that the workbook be shared and there are lots of things that are not available in shared workbooks. But maybe it'll be sufficient for you. Daffo wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
| Excel Sheet default setting. | Excel Discussion (Misc queries) | |||
| In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
| EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Hybrid Mode
