Any reason this VB script would work for some, but debug as read-only for others?

Hiya all,

I have a simple macro that copies information across to another workbook, on a new line.

We are in an office where the workbook 'output.xls' is saved on a shared drive that all staff have modify access to. The workbook that this script runs from, 'input.xls', is saved to each person's personal drive.

The form seems to work perfectly fine for half of the agents, but other agents get a read only version of 'output.xls' opening instead, and so they get a debug error when it tries to save. I cannot figure out why this would happen for some colleagues, but not others.

Any ideas?


Thank you.

Please Login or Register  to view this content.

Not as far as I'm aware; It still works for me and I've checked with a few other agents and it seems OK for them too, but other agents get output.xls opening as 'read-only' every time.

Does the code look OK? I couldn't spot anything wrong with it myself.

If the agents who are having errors open the 'output.xls' workbook directly, it still opens as read-only for them. I'm assuming this means that there is something outside of the script affecting them?

Not entirely sure what to check though. I have spoken to out IT guys and they have set permissions for the folder to be modify for everyone.

Ah! If they try and create an excel workbook in the same folder, it comes up as access denied. This must be a permissions problem then!

Thank you for your help. I'll just have to go and beat the IT guy lol