Dynamic Filename From Macro

C

Craig

I am trying to save a spreadsheet that is created by a macro. The
name that I want to use for this sheet is parsed from a cell so it
appears as a formula in the cell.

I have tried to use the cell value as the filename when executing the
Save As feature in the Macro, but can't seem to get the value to be
used. Am I missing something obvious? I thought that I had it
working once but couldn't reproduce the steps.

thanks again in advance!

craig.
 
D

Dick Kusleika

Craig

What do you have?

ActiveWorkbook.SaveAs Filename:=Range("a1").Value
 
Top