topic Re: Creating Excel File for Different Versions in .NET Forum

Creating Excel File for Different Versions

mgorecki — Fri, 14 Aug 2015 18:07:47 GMT

Hello,

My program will output to a new Excel file. I have Microsoft 2013 and 2010 installed on my computer. There are people in my company that only have 2010, so I need to be able to output to 2010.

In the references, I have added:

Microsoft Excel 14.0 Object Library

Microsoft Office 14.0 Object Library

(14.0 = version 2010)

In my code I have used "Object" instead of Excel.Workbook as I read in another forum I have to do that for this to work in older versions of Excel.

Dim xlApp As Object

Dim xlWkBook As Object

Dim xlWkSheet As Object

'Dim colorRange As Range - can't use it currently

'Open Excel application

xlApp = CreateObject("Excel.Application")

'Make sure excel is visible and add a new workbook

xlApp.Visible = True

xlWkBook = xlApp.Workbooks.Add

xlWkSheet = xlApp.ActiveSheet

The problem happens when the file is saved and I double pick the file to open it, it tells me that the file format and the extension don't match. I pick "Yes" to open it anyway and it opens just fine. Is there any way to get around this warning message?

Thanks,

Mark

Re: Creating Excel File for Different Versions

arcticad — Fri, 14 Aug 2015 19:27:56 GMT

Check if the file is a xls or an xlsx.

Rename the file to .zip and unzip the file.

If you have a few files then it's an xls

otherwise if there are multiple folders it's an xlsx file.

Re: Creating Excel File for Different Versions

mgorecki — Fri, 14 Aug 2015 21:26:20 GMT

ok, it looks like its an .xlsx.

Re: Creating Excel File for Different Versions

andrewpuller3811 — Sun, 16 Aug 2015 12:13:25 GMT

Without the code, it seems like the problem is being caused by having the file name extension set as .xls when the file format is actually the new .xlsx type.

I would suggest changing the file extension you are passing to match the file format you are creating/saving as.

Re: Creating Excel File for Different Versions

mgorecki — Mon, 17 Aug 2015 22:21:49 GMT

Ok I tried something else today and it seems to be working.

Originally, in the References I used Microsoft Excel 14.0 Object Library (14 = 2010, 15= 2013) from the COM tab.

I removed that and replaced it with Microsoft Office Interop Excel from the .Net tab.

I saved it and it ran just fine without format/extension issue.