I've created an excel file. It works fine. Opens up fine.
Now I want to save this file.
Here's my current code.
VB Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim excel As New Excel.Application excel.Workbooks.Add() excel.Range("b1:c1").Select() excel.Selection.Font.Bold = True excel.Range("b1").Select() excel.ActiveCell.Value = "Questions" excel.Range("c1").Select() excel.ActiveCell.Value = "Answers" excel.Visible = True
Now, I want to save the file (either before or after it is displayed to the user)
I was looking for a excel.saveFile function but can't find it.![]()
How would I save this?
something like excel.save(application.startuppath & myvar & ".xls")
Thanks...




Reply With Quote