Change the name of an auto save

D

DaveDuf

I am trying to write a macro that will save the file to a specific cell
reference. The reference is a specific name that is automatically generated
by another macro function.
Any suggestions on how I could do this?

Cheers
 
R

ryguy7272

IS thsi what you want?

Sub SaveMe()
sFilename = Format(Worksheets("Sheet1").Range("A1").Value)
ans = MsgBox("Save file as " & sFilename)
If ans = vbOK Then
ActiveWorkbook.SaveAs Filename:=sFilename
End If
End Sub

HTH,
Ryan--
 

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

Macro to select and delete levels of a document 2
Drop down list control value in vba 2
Crating User Form to Add Names 1
Insert name and adress from a list in a word document 1
Sub projects added as read only in Master file which are saved on sharepoint 1
Save workbook without shapes 0
Macro to Select text from a point given to a specific word 2
Grouping Names in Mail Merge 0

Top