How do I save spreadsheet?

[donnydooner]

I have a form in VBA that has a spreadsheet control on it. I've figured out how to get it to display a spreadsheet I have saved.

After the user edits data in the spreadsheet displayed on the form, how do I save the new data to the spreadsheet I have on disc?

 

[thepunisher]

ThisWorkbook.Save
ThisWorkbook.Close

it works in excel VBA

 

[johnwm]

For simple VBA questions you will do better in one of the VBA forums listed in the 'Related Forums' panel on your right, as this forum is specifically for VB5/6 questions

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'