advanced excel
-
I have created an interface where user can chose the required data to be exported to excel. If in future, user select a new data to be exported which the new data is already included in the previous data, the excel file must not replace bt the current one. If the new data selected is not included in the previous data, the excel file should update the data instead of replace it. Any idea of how can I do that?
-
I have created an interface where user can chose the required data to be exported to excel. If in future, user select a new data to be exported which the new data is already included in the previous data, the excel file must not replace bt the current one. If the new data selected is not included in the previous data, the excel file should update the data instead of replace it. Any idea of how can I do that?
Member 9169887 wrote:
Any idea of how can I do that?
Open your excel file, loop through all existing data and see whether it has changed (and needs be updated) Easiest way to read an existing excel-file would be using JET.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]