using style sheets with openxml method

[Akiel]

I am trying to open a teststand xml report created by teststand 3.5 with the horozontal.xsl style sheet. I am using the excel 11.0 object library with the workbooks object class, then calling the openxml method. It work ok (i get a list of results) when i dont specify the stylesheet. When I don I get error -2147024809 user defined code: Possible system error: The parameter is incorrect.  I believe its telling me the format i am specifying the stylesheet is incorrect. I have created a local.stylesheetpath as a string and set the value to <dir>\horozontal.xsl

any ides?

Many thanks in advance 

[snowpunter]

Is 'Store Absolute Path' checked for your report options in TestStand?

I've seen Excel barf when attempting to open TS xml report files due to security settings as well as the fact that it always launches a dialog when opening the file. You'll probably need to replicate this manually and the error may become more apparant.

[Akiel]

I have tried both ways, on further investigation looks like the stylesheet variable that ispassed to openxml is a varient, I just cant get any information on the format of what to pass to it.

Many thanks 

[snowpunter]

OpenXML takes the filename, then a 1 converted to a variant for Stylesheets and a 0 converted to a variant for LoadOption. I've used this in LabVIEW to make a conversion tool to convert to the XML files to XLSM in Excel.