Macro to Save a Workbook

[amecari]

Hi,
I neede some help with this: I have a plan.xls and I need to save thie in this directory "e:\temp" and the name of file to save is wrote in a cell F6.

Sub Save

Dim name as string
Name = Worksheets("Example&quot.Range("F" & 6).Value
ActiveWorkbook.SaveAs Filename:="e:\tmp\NAME"

End Sub
But the variable NAME ins't recognized. I have in e:\temp a file named NAME.XLS, inside for example DOOR thats is in cell F6.
Someone could help me ???
Thanks a lot

 

[dsi]

First, you should not use the variable name NAME. I believe it is reserved.

Dim sFileName as string
sFileName = Worksheets("Example").Range("F" & 6).Value
ActiveWorkbook.SaveAs Filename:="E:\tmp\" & sFileName

 

[amecari]

DSI, thanks very much.
You did resolve my problem. I didn"t kown how to "load" a variable.