Save As

[gripper]

I have a macro that creates a master spreadsheet from several other spreadsheets.

Now I want to be able to do a save as command with in the macro.

On my spreadsheet Sheet1 in cell B2 I have the file name - example "finalsheet"

I am trying to figure out the steps to save this to file path C:\active_files\$b2.xlsx

I would like the first part of the string to be constant "c:\active_files\ and the variable to be the value in cell b2 with a file extension added of ".xlsx"

Is there a way to do this automatically without the save as dialog box opening and asking me to click he button?

Any assistance to poin me in the right direction would be appreciated very much.

Thank you.

 

[repairman615]

Hello, maybe like:

<font face=Courier New>ActiveWorkbook.SaveAs Filename:="C:\active_files\" & Range("B2").Value & ".xlsm"</FONT>

 

[gripper]

Repairman - Thank you very much. That worked like a charm. I appreciate the assistance.