Hello all! I have been frustrated by errors when trying to export an analysis view from Attain 3.60 to Excel. If it is of any help, I am running Office XP on windows 2000. The first is a follows “This data type is not supported by c/side. You can access data from any of the following types: VT_VOID,VT_I2,VT_I4…” Does anyone have any ideas why this is occurring? The second, I have seen before but cannot for the life of me remember how it was fixed. “An exception occurred in an external component. The component did not provide the exception description” Again, any ideas? To compound the problem, we need to fix the first error to get to the second to be able to fix that. Sorry if this is a bit cryptic, any suggestions much appreciated. Thanks
1.) You are calling a Excel function with parameters. One of those parameter will get a return value from Excel. This parameter is of the wrong type. I think you should search for a datetime variable. 2.) Dunno!
oooh I just remembered, check the variant variable as well. This could well be the problem too.
Thanks Emiel! I will try that out and see what happens. If anyone else has any other suggestions for this or preferably a solution to question 2, it would be a big help. Thanks again, John
Hi, The main concern here is that the objects are standard and have not had any changes made to them. Rob
FINALLY FOUND THE PROBLEM !!! The objects have been run through the make-ml upgrade tool. This has taken valid parameters and made them into text constants, causing errors when actually used later on. Therefore, it should be noted that only run the make-ml tools on non-standard objects only. Rob