Need code to save under filename drawn from specific cell

**j_gilhuly** · 03-18-2009, 04:51 PM

(Excel 2002)

Sorry, newbie... I searched and got close to this but no luck. I did however learn how to add buttons to the worksheet and assign macros to them, so I'm on my way...

The goal is to allow users to open a generic form, fill it out, then click the "Save This" button. The file will then save using the contents of C4 appended by today's date as the filename.

Later on they come back to this same form to update it, after which they hit the "Update This" button.

I don't need to track revisions so button 2 simply requires #ActiveWorkbook.Save#, so that's all taken care of.

Any help on button 1? Thanks!

**Richard Buttrey** · 03-18-2009, 04:55 PM

Hi,

Something like

Please Login or Register  to view this content.

perhaps...?

HTH

**j_gilhuly** · 03-18-2009, 05:16 PM

Very nice, thanks. Now how about appending today's date?

**shg** · 03-18-2009, 06:57 PM

Please Login or Register  to view this content.

**j_gilhuly** · 03-18-2009, 07:46 PM

Excellent...thanks to both

**shg** · 03-18-2009, 07:54 PM

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes