Timestamp

**preciouslife73** · 02-06-2012, 08:00 PM

I don't understand. IT worked perfectly at home. But when I trying another computer, the first part of the MACRO works GREAT!, it was able to create a Folder with Date Stamp and copy from old path to this new path.

But when it got to the 2nd part where it need to rename the file in the new path it gave me a warning that the file does not exist. How is that possible? It was created in the first place to begin with. It can't be right. I have Microsoft Excel 2010 while the other computer has 2007. I really dont think that would matter. How do I revise this to make it work? (but it works at my home computer)

Please Login or Register  to view this content.

**smuzoen** · 02-06-2012, 08:23 PM

The code seems fine - is it one particular file causing the problem - does it rename any files in the new directory. It may be a permissions issue as you are working in "C\Users". Just for interests sake add some error handling to see if it is just one file or all files. Add

Please Login or Register  to view this content.

and see if any files are copied. THIS IS NOT A SOLUTION. It is just to see if one file is an issue. Try the code outside of "C:\users" - set up a test folder "C:\Test" and put some excel files in here - if it works in the test folder then it may be a permissions issue.
I have tried this code and it works fine so it must be a problem on your end.