Macro to save a file

[triegaardtm]

Hi

The code I wrote to save a file with the last row counter and month counter looks as follows (this was working on my Mac)

ActiveWorkbook.SaveAs FileName:= _
"Macintosh HD:Users:myratriegaardt:Desktop:Quotes" & M & ":Quote" & LastRow & ":QuoteHG" & LastRow & ".xlsm", FileFormat _
:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False

I converted it to put on Windows,

ActiveWorkbook.SaveAs FileName:= _
"C:\Users\Cape Crating\Desktop\Quotes" & M & "\Quote" & LastRow & "\QuoteHG" & LastRow & ".xlsm", FileFormat _
:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False


This however gives an error


Please assist

M

 

[Special-K99]

And that error would be...?

For a start what's "M" ?

 

[hippiehacker]

what error do you get?
what is declared and stored in M? and lastrow?