问题

I'm trying to make a new Excel file, "Personal.xlsb," using VSTO.

I've tried to make a new workbook - regular one, with code below;

Microsoft.Office.Interop.Excel.Workbook myWorkBook = Globals.ThisAddIn.Application.Workbooks.Add();

Yes, it works well. But, as you know well, it cannot be a Personal.xlsb. So, what do I have to do? Using VSTO?

Let's say, I have nothing in the folder "C:\Users\user\AppData\Roaming\Microsoft\Excel\XLSTART".

英文:

I'm trying to make a new Excel file, "Personal.xlsb", using VSTO.

I've tried to make a new workbook - regular one, with code below;

Microsoft.Office.Interop.Excel.Workbook myWorkBook = Globals.ThisAddIn.Application.Workbooks.Add();

Yes, it works well. But, as you know well, it cannot be a Personal.xlsb. So, what do I have to do ? Using VSTO ?

Let's say, I have nothing in the folder
"C:\Users\user\AppData\Roaming\Microsoft\Excel\XLSTART".

答案1

得分: 1

使用Workbook.SaveAs方法，该方法将工作簿保存到不同的文件或格式中。XlFileFormat枚举包含所有支持的文件格式。

英文:

Use the Workbook.SaveAs method which saves the workbook in a different file or format. The XlFileFormat enum contains all the supported file formats.

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。