I have a list of doctors that I need to create templates for and then
refresh the background query (the spreadsheet is linked to SQL) . I
have the logic worked out, the only problem that I am having is that
when it comes to saving the file name, I have the doctors name in Cell
A5, this is a dynmic field based on the query, how I do fix the
following line of code to tell it to look at A5 for the file name? I
thought I would be able to copy from cell A5 and paste it into the file
name, but that is not working, any other suggestions?

The line of code to save the workbook is:

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Richard
Sabbara\Desktop\Range('C1')", FileFormat _
:=xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:= _
False, CreateBackup:=False

Any help is greatly appericated.

Richard