I have written an app that exports access query results into an excel spreadsheet but when/if i try to overwrite the excel file im exporting the results to the program crashs while running the
oExApp.Workbooks(1).SaveAs txtFileName.Text
line only if i choose cancel or no in the windows msg box that shows up asking if i want to overwrite the file
oExApp.Workbooks(1).SaveAs txtFileName.Text
line only if i choose cancel or no in the windows msg box that shows up asking if i want to overwrite the file