February 2nd, 2013, 11:30 AM
Join Date: Feb 2013
Time spent in forums: 4 h 45 m 43 sec
Reputation Power: 0
name v fullname
Your problem is that activeworkbook.name is just the name of the file, you need path and name to open a file, activeworkbook.fullname is the name and path
All your code needs is an extra "full" and it will work fine
Just a thought, the way you have it your code will reopen the original file as it was before any edits, if you want it to be as it is after any edits you have done use:
Nameaandthepath = ActiveWorkbook.FullName
ActiveWorkbook.SaveAs Nameaandthepath & "xx"
Last edited by GGriggs : February 2nd, 2013 at 11:40 AM.