Hi,
I have an Access file that I update every so often, and then an Excel file with an update macro which then draws all the information from the Access file.
The Excel file is intended for the end-user (friends of mine) and they will never see the Access file.
For obvious reasons the Excel file needs access to the Access file to work, so how do I go about hosting this scenario without setting up a Windows server?
I've considered simply throwing the Excel file into a DropBox, but that'll bring about a lot of duplicate file issues as well as making each end-user's path be different, thus rendering the path the Update button uses invalid.
Anyone got a good suggestion?
I have an Access file that I update every so often, and then an Excel file with an update macro which then draws all the information from the Access file.
The Excel file is intended for the end-user (friends of mine) and they will never see the Access file.
For obvious reasons the Excel file needs access to the Access file to work, so how do I go about hosting this scenario without setting up a Windows server?
I've considered simply throwing the Excel file into a DropBox, but that'll bring about a lot of duplicate file issues as well as making each end-user's path be different, thus rendering the path the Update button uses invalid.
Anyone got a good suggestion?
Last edited:
