Does Office 2007 work with CVI automation

[menchar]

We've used Office with CVI with varying degrees of success over the years, typically to generate reports or to populate excel spreadsheets with measured data.

Now I'm running XP SP3 and Office 2007 with CVI 2009.

Office 2007 seems to be so significantly different from previos versions, I'm wondering if it's use is supported with CVI?

CVI 2009 still refers to "Excel2000.fp" for example, will it work with Excel 2007?  The help mentions that it will work with "Excel 2000 and later compatible versions". 

In the past as I recall NI's position is "maybe, but if it doesn't, it's not our fault".

So I thought I'd ask and see what the experience has been.  I can install an older version of Office if need be.

Menchar

Message Edited by menchar on 06-10-2010 10:18 AM

[Swathi B]

Hi menchar,

Have you looked into using the Excel 12.0 Object Library, as suggested here?

[menchar]

Swathi -

Thanks for the info.

I'm not pasting pictures so I shouldn't have trouble in this instance, at least.

This is treacherous ground.  I know I've found errors in the CVI wrapper code for office functions in the past, but I'm hoping that by sticking to simpleoperations I'll be OK.

So I'll give it a go with Excel 2007 and report my results.

Menchar

[Ian.W]

FWIW, we have been using "excel2000.fp" for years (with a few thousand users) and it still seems fine for simple exporting of data to Excel 2007. 

I think it all boils down to the Excel object model and whether there have been changes related to the functionality you wish to use.

--Ian

Message Edited by Ian W on 06-14-2010 09:51 AM

[menchar]

I've managed to implement ExcelRpt with Office 2007 and CVI 9.1, and aside from issues that have nothing to do with the Office version, it appears to work all OK.

I am now wondering if that's also going to be true for CVI 8.5.

Menchar