Double Save On Shared Network Drive

Hello,

I am working on a solution to allow a small team to work on and edit a project calendar. Due to another department accessing the same spread sheet through Citrix VPN, my team would loose editing permissions to this spread sheet.

To fix this issue, I planned to make a macro that would save a file in two locations on the shared drive. My team would work on one and make edits to the calendar and those logging in through the VPN would look at another copy of the same file with our updates.

I ran a test on my desk top and was able to get the results that I was looking for. Now that I am trying to push the function on to a shared network drive, I am having errors.

This is a first time effort with VBA. I have built what I have through tutorials and outside help. I am open to suggestions and education.

Please Login or Register  to view this content.

Regards,
Mark