![]()
Sub snb() With Workbooks.Open("C:\Aus_Nav\2011\August\test.xls") .SaveAs Replace(CreateObject("scripting.filesystemobject").getfolder(.Path).parentfolder & "\" & .Name, "\\", "\") End With End Sub
![]()
Sub snb() With Workbooks.Open("C:\Aus_Nav\2011\August\test.xls") .SaveAs Replace(CreateObject("scripting.filesystemobject").getfolder(.Path).parentfolder & "\" & .Name, "\\", "\") End With End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks