Hi
I am trying to get a master purchase order sheet to copy and rename a set of folders and files contained within to a central location.
The folders are in the 'Standard Documents Folder' and I am wanting these to copy to the main 'Contract' Folder on the server (at the minute I'm using a test folder 'Test').
The code I have below so far is:
I am getting the error "Object Variable or With Block Variable not set" on the following code:
Can anyone see why?
My next query when I can get this one sorted is to have the other excel files that are already on the copied files to be renamed in the same way (contract number etc, so RAMS would become C12345 RAMS etc).
What would be the best way to do this?
Kieran
Bookmarks