Forum Discussion
Excel update
Hey! It's my first discussion in this forum. I am working on Excel, with lots of developers stuff in it. I am looking for ways where I can send updates for the excel file that I have sent to ...
It is difficult to advise on such a broad question. But let me try anyway.
Your intention is to send people a file which will update their existing workbook to the latest "version", correct?
Ideally, that "Updater tool" would contain a table with all changes to the file and some VBA code which can read that table and act accordingly.
The code in the updater tool should also include some test to determine of the file the user tries to update is sufficiently up to date so that the script is expected to work. Suppose there are 3 existing versions and you now send out the update to version 4. Your code must verify that the workbook the user tries to update is a version 3 file, otherwise your update may fail.
Your intention is to send people a file which will update their existing workbook to the latest "version", correct?
Ideally, that "Updater tool" would contain a table with all changes to the file and some VBA code which can read that table and act accordingly.
The code in the updater tool should also include some test to determine of the file the user tries to update is sufficiently up to date so that the script is expected to work. Suppose there are 3 existing versions and you now send out the update to version 4. Your code must verify that the workbook the user tries to update is a version 3 file, otherwise your update may fail.
- Hi!
You're 99% right, the one thing that I need different is, despite whatever the old version is (1, 2, 3,), if it's lesser than 4, then the updation for version 4 has to take place.- Have you tried to set anything up yet?
- Not exactly, but I used MS Access as database and was able to paste the updated file (example version 4.4) into the users' exisiting (older version file) folder and then opening it.
But this defies the whole purpose of making a patch file/update file. This is just like copy paste stuff from the users' end but I'm doing their job.
