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 people.
No, I don't want to send over the excel file all over again, but send over a file/excel file that could extract the user details in the user's existing file and shall update features/bugs from the sent file/excel file.
6 Replies
- 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.- 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?
