Saving Form Contents

Borhani · January 19th, 2008, 03:06 PM

I have a form wiht textboxes and comboboxes for inputing data... at present... when I need to save I have to close the form and go to File>Save As in excel to save the updated content...

If I choose to put a command button on the form for saving information....can it be coded to do the saving....

Grateful if you could help....

Shasur · January 19th, 2008, 10:16 PM

You can write a small code in the command button click event

Code:

Private Sub cmdSave_Click()

    Application.DisplayAlerts = False
    ActiveWorkbook.SaveAs "c:\temp.xls"

    ActiveWorkbook.Close (False)
    Application.DisplayAlerts = True

End Sub

Hope it works!

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Borhani · January 20th, 2008, 12:55 PM

I tried it ... it seems the code is not working...may be I am doing something wrong...

I pasted it in the Save AS command button and after running the application the application closed without saving...

Is there an alternative...or if possible to elaborate:)...Thanks..A. Borhani