Dynamic Filename From Macro

  • Thread starter Thread starter Craig
  • Start date Start date
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.
 
Back
Top