Several users need to update a master spreadsheet (table) so I am creating a macro that will copy their data and paste it into the next available row on the master spreadsheet. My problem is where to put the master file so that everyone can access it from the internet.
I am running into permission problems when I put the file on my web server. For some reason, in VBA when I open the file to write to, it is a read-only copy. I don't know how to get around this. I was hoping one of you with a lot more experience in doing this type of thing could help me solve this dilemma. I am under a time crunch too (sorry).
I thank-you in advance!
John