cancel
Showing results for 
Search instead for 
Did you mean: 

Latest Excel VBO: 'Could not run the object because one of the code stages has a compile error, use Check for Errors for a list of problems'

john.hammond
Level 6

Morning all.

When trying to run pages from within the latest Excel object (link - MS Excel VBO), I'm presented with the following error:

'Could not run the object because one of the code stages has a compile error, use Check for Errors for a list of problems'

Upon investigating the Code stage, no such errors seem to exist. I've searched previous posts for this and it was suggested that a missing DLL could be the cause, but from the documentation, it doesn't appear as if this VBO requires any additional files. These are the listed dll's established:

28902.png
However, when checking for errors within the Object itself, there is an error related to the compiling:
28903.pngI don't know enough about the code for this particular action, and although c isn't declared, I'm assuming this particular 'c' isn't referring to a filepath, rather a data item that hasn't been declared. 

Am I missing something here? Do I need to amend the code for the 'Set Value of Cells in Range' object? Or just remove it entirely? Our team isn't using it, but I'm loathe to remove potential future functionality. 



------------------------------
John Hammond
------------------------------
10 REPLIES 10

@jincjoseph have you tried opening the VBO and seeing if any errors are presented? I'm running v7.4 and have no issues. Are you using the lates Excel VBO from the Digital Exchange?

Cheers,
Eric