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 ...
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.
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.- I'm confused, you started your post with mentioning an Excel file, now you are talking about an Access database?
- How will you send an updated excel file (version 4 per se)? Either you share it via email or through external drives or if you have a shared drive you can take use of it, right? So I used MS Access to post the path of version 4 which is in the shared drive, and had a VBA module to pick the version 4 from the path which is mentioned in the Ms Access and copy paste The Excel file version 4.
I guess it's clear now...