I've one round and round in circles on this one so any help woul be a fantastic.
I have wriiten a sub which opens another workbook, edits it, then saves and closes it. So far no problems it does exactly what it should.
The problem comes if the workbook is already open, then it doesn't save the changes (or i don't think it makes them in the first place) and it doesn't close it either. i think its opening another version of it and then closes it, but not quite sure. When i manually close the open book, a message saying its ready for editing read write comes up.
i've played with numerous bits of code, but none worked so its not worth posting them.
What I'm really trying to achieve is a bit of code that will check if the target workbook is open, if it is let the changes take place and save n close, or if its not open,then open it, make the changes, save n close.
if you can help out, big thanks