santeria
Well-known Member
- Joined
- Oct 7, 2003
- Messages
- 1,844
I'm just trying to Figure out what to change for a network file save.
Probably something amazingly basic...
However, I have...
And I need to know what to change to make the thing work.
Ta
Probably something amazingly basic...
However, I have...
Code:
Sub SAVECMSDAILYNETWORK()
'
' SAVECMSDAILYNETWORK Macro
' Macro recorded 2/24/2004
'
'
Windows("M:\REPORTS\02_FEBRUARY SUMMARY\CMS Daily.xls").Activate
ChDir "E:\HR Outsourcing\Benefits\Reports"
ActiveWorkbook.SaveAs Filename:= _
"E:\HR Outsourcing\Benefits\Reports\CMS Daily2.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
ActiveWorkbook.Close
End Sub
And I need to know what to change to make the thing work.
Ta