Easy one: What to name this

[klarowe]

I just wrote this quick code for saving some new reports I'm making up and it runs great if I don't have "Option Explicit" but if I add it in, it brings up an error. I know its because I don't have "Dim SaveName as ____" but I can't seem to find anything to fill in the blank with that works. Where am I going wrong?

Sub SaveAs()
    On Error GoTo Err
    SaveName = Sheets("Home").Range("C38").Value
    MkDir "\\TBISUSFS001\Share\SERVICE\Repair Shop Build Books\" & SaveName
    ActiveWorkbook.SaveAs Filename:= _
        "\\TBISUSFS001\Share\SERVICE\Repair Shop Build Books\" & SaveName & "\" & SaveName
Err: MsgBox "File was not saved.", vbOKOnly, "File Not Saved"
End Sub

 

[JamesW]

Hi klarowe,

Think about what SaveName is holding. If the value in C38 is always a number, then try using Long. If the value is always a string, or a mixture, then try String.

If all else fails, you can always use Variant - although I don't recommend this but for such a small piece of code you will be fine.

 

[klarowe]

I thought about long, but its a mix of letters / numbers. I also tried Variant and it didn't seem to work (gave me an error). I'll try string.... didn't even think of that one.

Edit: String seemed to have worked. Thanks for the help!