Save file to Network Drive

[santeria]

I'm just trying to Figure out what to change for a network file save.
Probably something amazingly basic...

However, I have...

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

 

[Seti]

Not 100% sure, but I think the space in the file name is a problem. Can you use an underscore? If not, I think you need some single quotes around the filename (and possibly the extension).

 

[santeria]

Actually the file references is the one thing I am certain on.
They work in all other code I have in that format.

It's the references to the file that I am stumped on... the macro is aiming to save a file from a separate file.
The "Raw Data File" is basically where the control panel for this stuff lives.
And I need to save the CMS Daily file as CMS Daily2 in another Network drive.

Such a headache, but the instructions I have stand as is

Thanks anyway.

Ta

 

[Smitty]

What line does it crap out on?

Smitty

 

[santeria]

First Line.
However, this was the code generated by the Macro Recorder, so it has me puzzled as to why it is dying.


Ta

 

[Smitty]

Silly question, but is your CMS Daily.xls workbook open?

 

[santeria]

No.
Most of the other Macros seem to run without it being open.
In fact they usually have seizures if it is open.

 

[Smitty]

That's your problem then. You're trying to activate a workbook that's closed. It needs to be open.

Smitty

 

[santeria]

Nope, it's something else.

Can't quite get the correct tags.

Ta

 

[santeria]

Yes, If someone knows the repair on the Macro Code, I would REALLY appreciate it.

Ta