How to save bunch of Excel file as CSV file format without asking for the save as dialog. I don't want this dialog box.
wksht.SaveAs("C:\\Barcodes\\New\\"+ Date + "_" + k +".csv",Excel.XlFileFormat.xlCSV);
Asked
Active
Viewed 1,646 times
-4
rene
- 41,474
- 78
- 114
- 152
mike chathuranga
- 11
- 6
-
try xlAppClass.DisplayAlerts = true; it won't display excel alerts. – sowjanya attaluri Jul 05 '16 at 07:57
1 Answers
-2
Use this
wbook.SaveAs("C:\\Barcodes\\New\\"+ Date + "_" + k +".csv",Excel.XlFileFormat.xlCSV);
For more details can see here https://msdn.microsoft.com/de-de/library/microsoft.office.interop.excel._workbook.saveas(v=office.11).aspx#Y114
120196
- 283
- 6
- 14
-
1
-
i tot workbook,saveas is difference with the op wrote 1, if got mistake please correct me – 120196 Jul 05 '16 at 08:05
-
The OP didn't mention that their object doesn't have a SaveAs method. Your answer is at best a guess. – rene Jul 05 '16 at 08:07