Good Morning,
I have created a database in excel that is to be in a public shared folder. When it is not shared you can run all of the macro's just fine and everything is all fine and dandy. As soon as it gets shared, and you use the "Update Drop Downs" macro, it locks the document for saving. all of the macro's still work which is good but you just can't save after the fact. I figure that it is because I use some mySQL in the excel code and it opens the excel document partially (I am just throwing stones into the pond at this point) and since excels sees it as "Opening" it locks the file for editing. Does anyone know a work around for this? I was thinking maybe closing the background file that is open some how but I am not sure what the vba would be for that.
I tried having the program close then reopen before I let the user input data for saving but sharing cut that off and errored so I am out of ideas.
I have attached the file for you to look at:
InventoryDatabase.xlsm
If you have any questions at all let me know,
Sleepyshy
Bookmarks