topic Re: Foundation Consolidation Exercise in University Forum

Foundation Consolidation Exercise

StefLachin — Thu, 16 Sep 2021 15:55:07 GMT

Hello - can some one give me a clue (or the answer 🙂 ); I'm stuck on the first bit where you build the process; I keep getting an error on the Open Workbook action "Internal : Could not execute code stage because exception thrown by code stage: Exception has been thrown by the target of an invocation." which doesn't help much.
I have these entries for the data item:-

And this for the action:-

Any help appreciated as I'm feeling a bit like I've fallen at the first hurdle...
Thanks,
Stef
Training edition 7.0.0

Re: Foundation Consolidation Exercise

lookman — Fri, 17 Sep 2021 13:15:55 GMT

Hi Stef.

The first step is to create an instance. You are doing that and it works fine?

jack

Re: Foundation Consolidation Exercise

StefLachin — Fri, 17 Sep 2021 13:29:25 GMT

Thanks Jack
Yes, the instance comes up OK, then the process then has trouble finding the csv.
I've re-done the process this morning using the csv method and that worked OK so I'm feeling a bit more positive!
I'll check the Excel solution when I get access to the solution document to see what I've missed.

Cheers,
Stef

Re: Foundation Consolidation Exercise

VedSengupta — Sun, 19 Sep 2021 13:21:01 GMT

Hi Stef,
Are you closing all instances of excel before creating an instance and opening any workbook?

Can you please have an action to kill any running instance of excel before doing the exercise and see?

Best Regards,
Ved Sengupta

Re: Foundation Consolidation Exercise

Chan_Thomas — Tue, 09 Apr 2024 16:46:02 GMT

Hey there,
I'm hoping for some help! I'm on this stage also but my Error log is coming up with the below

I can't seem to figure out how I'm referencing the workbook 😞

Re: Foundation Consolidation Exercise

MichealCharron — Wed, 10 Apr 2024 17:57:48 GMT

@Chan_Thomas

What you are looking at is the Process Validator dialog. If the Type was Error, then you would have a problem. The Type is Advice which usually means you are doing something that is not best practice.

In the row that I see in your image, you have a data item named Workbook on your Main Page page that is not being used by any of your other stages. While this does not cause your process to fail, it is bad practice to leave unused data items lying around.

Re: Foundation Consolidation Exercise

asilarow — Thu, 11 Apr 2024 10:49:19 GMT

Hi Stef,

Do you have the Microsoft Excel application installed on your computer?

Also, It would be very helpful if you would paste in a screenshot of your entire process diagram.