Really grateful for a steer in the right direction.
I've created a windows form in VB Express 2005 with lots of combo boxes and print and save buttons.
I would like to be able to save the contents of the populated combo boxes, labels etc ie the whole form from the save button, preferably to excel 2003. However, would be just as happy to save it in the form format.
The only code behind the save button I have so far is this, which just navigates me to the directory. When I enter a filename and extension, the directory is empty:
Private Sub save_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Save.Click ' Displays a SaveFileDialog so the user can save the file assigned to the Save button. Dim saveFileDialog1 As New SaveFileDialog() saveFileDialog1.Filter = "All Files|*.*|Excel Files|*.xls|Word Files|*.doc" saveFileDialog1.InitialDirectory = "R:\Clinical\General\Shifts" saveFileDialog1.Title = "Save Shift File" saveFileDialog1.FilterIndex = 1 saveFileDialog1.ShowDialog() End Sub