I have a little automated Excel program that pulls info from the company database, fills out forms and then saves the forms you want to a shared drive. At the same time, it updates the control log with the file details and a hyperlink to the file.

I'm having a little problem with the saving though. I tested the program using my userID and can save to my machine (not much use in the end) and also to a shared folder I have full access to. The user that is using my program cannot, however, save to the shared folder he needs to save to. He has full permissions on the folder according to one of the on-site IT people. He can also manually put a file in the folder, but that's useless in this case as the hyperlink becomes invalid. Any ideas?

Another colleague of mine had a similar issue with some of his programs which he managed to resolve by just having the folder open before he executed the save event in Excel, however I cannot use this solution with my program. Besides, it's a bit awkward.

Any help would be most appreciated. Thanks!