I am opening a template, populating it with data, doing a SaveAs for the new workbook. Then I do a Process.Start(S avedFile) to open the saved workbook. The problem I have is that the template opens when the saved file opens.
What am I doing wrong?
This is a sample of the end of the code. I can provide more if needed.
What am I doing wrong?
Code:
If ReportDirectoryExists(ReportFolder) = False Then
MessageBox.Show("Could not save report successfully", "Error Saving", MessageBoxButtons.OK, MessageBoxIcon.Information)
Else
xlWorkbook.SaveAs(strSavedFile, Excel.XlFileFormat.xlOpenXMLWorkbook)
xlApp.xlWorkbook.Close()
xlApp.Quit()
End If
Comment