Need to Save File and prompt user for Filename

**tjamestx** · 10-01-2013, 01:47 PM

Total novice here...

I have a macro (hooked to a button) that clears the Worksheet once the user is done with data entry. What I'd like to do is have the macro initiate a "save as" routine and use the contents of a cell to name the file prior to running the clear routine. Any help on this would be greatly appreciated. Tom
Sub SAV()
'
' SAV Macro
' Saves File and Clears Worksheet
'
' Keyboard Shortcut: Ctrl+s
'
Range("C20").Select
Selection.ClearContents
Range("C19").Select
Selection.ClearContents
Range("C18").Select
Selection.ClearContents
Range("C17").Select
Selection.ClearContents
Range("B17").Select
Selection.ClearContents
Range("E13").Select
Selection.ClearContents
Range("E12").Select
Selection.ClearContents
Range("E11").Select
Selection.ClearContents
Range("C12").Select
Selection.ClearContents
End Sub

**Solus Rankin** · 10-01-2013, 02:25 PM

Which cell will contain the name?

**HaHoBe** · 10-01-2013, 02:41 PM

Hi, tjamestx,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Ciao,
Holger

**tjamestx** · 10-04-2013, 11:32 AM

Solus and HaHoBe,

My apologies for the breach in protocol and for leaving critical information out (cell location), stupid mistakes

. After a lengthy "trail and error" session, I solved the issue. Thank you for the replies though, I will no doubt be back for more help.

Thank you, tjamestx