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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Excel Macro Copy cells and pastes them in another sheet 2
VBA Coding Help for Beginner 0
Save as (filename,fileformat) from Word VBA will not work 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Macro to Publish as PDF 1
Macros to convert Data into date format and then plot in graph 7
Cell reference to determine filename 1

Top