Excel 2010 Saveas macro issues

[chicosbailbonds]

As part of my code I define the path and filename of where I want this file to be saved.

Dim NEWDAYXLS As String
Dim NEWDAYPATH As String

NEWDAYXLS = Sheets("Dates").Range("M5")
NEWDAYPATH = Sheets("Dates").Range("O5")

Do work to roll the day of the file

ActiveWorkbook.SaveAs Filename:=NEWDAYPATH & NEWDAYXLS, FileFormat:=52

This does not seem to work as I am getting a method Saveas of object' _Workbook failed on the last piece of code shown above.

Anyone have any thoughts? Thanks for your time and help in advance.
Jim

 

[Smitty]

You need to make sure that you have the proper path like "C:\" and the correct backslashes. Check and see what this returns now: NEWDAYPATH & NEWDAYXLS

I'd imagine you just need to add some tweaks, like NEWDAYPATH & "\"& NEWDAYXLS

HTH,

 

[chicosbailbonds]

It returns: X:/OPS/Daily Reports/2011/04-2011/Tax Lot Appraisal - 04.12.2011.XLSM

Which I believe is what I want it to return. The only item I am not sure about is if I need the Filename to include the .xlsm or if that is automatic.

 

[Smitty]

What happens if you try to save with the physical path/name as you posted it? And generally you do include the extension.

 

[chicosbailbonds]

Thank you for your help, I figured it had to be something dumb on my part and it was. After trying to save it down manually using the info from the immediate window I received an error. After staring at it for a few minutes I realized I was using the wrong slash. Should be "\"!