Moving file between folders error (FSO)

[milo1984]

Hi

I am having a bit of trouble with the below code. basically, I want it to move the open workbook from one folder to another. I probably need to add a activeworkbook.close before I can move it, but I'm not sure where.

any help would be appreciated.

Many thanks in advance

Please Login or Register  to view this content.

[TMS]

I probably need to add a activeworkbook.close before I can move it,

Yep, I guess. Otherwise Windows is going to say the file is in use.

but I'm not sure where.

when you've finished doing whatever you need to do to it and before you try to move it ...


Regards, TMS

[milo1984]

Thank you, can you help me with the code though? I'd like it to get to the stage where it says 'file in use'. I think this is where it is throwing up the error

Please Login or Register  to view this content.

Thanks again.

[milo1984]

is there anyone who can help me with this, please?

Thanks in advance

[TMS]

I think it would look something like this but I can't test it it because I don't have workbook(s), forms command buttons, etc.

Please Login or Register  to view this content.

Like I said: after you've finished doing what you need to do to it and before you try to move it.


Regards, TMS