Excel: Creating Workbook fails

[fischerg]

Hello,

I try to create a Excel-Workbook with Worksheet.

Creating the Excel-Application works, but then I get a failure when opening (or creating beacoause the name is empty) a workbook.

Does anybody know why?

Thanks

Gabriel

LabView 2009 Version 9; Office 2007

[J-M]

I am not sure but I think you need to convert the string path to variant data.

JM

[smercurio_fc]

---

@J-M wrote:

I am not sure but I think you need to convert the string path to variant data.

---

That wouldn't make a difference. It gets automatically converted.

As for the question: You appear to have modified a shipping example. The Open New Workbook VI does not have a string input. Is this the VI that's causing the error? If so, what is the error code? Did you modify this? If you did modify it, how did you modify it? Did you save it under a new name? I hope you did not overwrite the shipping example.

[J-M]

Yes, I am wrong.  Try "Open New  WorkBook.vi" instead "Open Specific WorkBook.vi" from the ExcelExamples.llb.

[Darin.K]

The OP appears to be using 'Open Specific Workbook.vi' which has a string input, expected to be a path to an existing workbook.  'Open New Workbook.vi' appears to be in order here.  Both are located in the same llb.

Edit:  Just like J-M said...

[fischerg]

Hello,

Thanks for your answers. I realized that I have switched my LabView Version and was using an old ExcelExamples.llb. After chanching with a newer one it works.

Gabriel