topic Correct Syntax for fields of "Save As" MS Word VBO action? in Product Forum

Correct Syntax for fields of "Save As" MS Word VBO action?

LennyAdams — Fri, 24 Apr 2020 23:37:00 GMT

Hi There,

I'm working with an MS Word VBO business object action labelled as "Save As". It has three fields that require input and I have been getting the same error for quite some time now. It is as follows:

"Internal : Could not execute code stage because exception thrown by code stage: Bad file name"

I have crafted a very simple implementation in order to streamline the process of saving the generated Word document.

Here are some screenshots:

Would you happen to know the proper syntax--or better yet, where to find a compilation that contains examples of the proper syntax?

Thank You!

🙂

------------------------------
Lenny Adams
Technology Early Career Development Program (TECDP) Intern
Cigna
------------------------------

RE: Correct Syntax for fields of "Save As" MS Word VBO action?

AntonHosang1 — Sat, 25 Apr 2020 09:45:00 GMT

Hi, you entered the double quotes in the data item. They are not needed to make text in Data Items. Only use quotes to mark a string in the Expression editor/inputs.

------------------------------
Anton Hosang
RPA Developer
Smart Automation Services
Europe/London
------------------------------

RE: Correct Syntax for fields of "Save As" MS Word VBO action?

LennyAdams — Sun, 26 Apr 2020 11:11:00 GMT

Hi Anton,

Thank you for your response. I have adjusted the data item text field and yet the same error (Bad Filename) is still being thrown by BP. Here's a screenshot for reference:

Any other ideas as to why this is still happening?

Thank You.

------------------------------
Lenny Adams
Technology Early Career Development Program (TECDP) Intern
Cigna
------------------------------

RE: Correct Syntax for fields of "Save As" MS Word VBO action?

Mohammed_OmerAl — Mon, 27 Apr 2020 19:11:00 GMT

Hi Team,

Please use create instance first then you will get the output.

Pass that output ie.handle for all actions like create document and save as . Hope you will not get the error and also use close instance before killing ms Word.

------Original Message------

Hi, you entered the double quotes in the data item. They are not needed to make text in Data Items. Only use quotes to mark a string in the Expression editor/inputs.

------------------------------
Anton Hosang
RPA Developer
Smart Automation Services
Europe/London
------------------------------

RE: Correct Syntax for fields of "Save As" MS Word VBO action?

LennyAdams — Tue, 28 Apr 2020 01:15:00 GMT

Hi Mohammad,

Thank you so much for your insight! I utilized it and was able to successfully use the MS Word VBO "Save As" action.

I will post a summary of the solution steps here just in case anyone needs them in the future. :c)

=========================================================================================

The solution looks like this:

It appears that my primary issue was that I had NOT created an MS Word instance first!!

Once I followed the following procedure, it FINALLY worked:

1) Create MS Word Instance and pass output to Handle data item.

2) Create MS Word document and pass output to DocumentName data item.

3) Type test text in MS Word document (passed Message data item to input parameter).

4) Use "Save As" MS Word VBO action the following arguments:

5) Detach from created MS Word Instance.

And that did the trick!

Thanks for the feedback, Team. :c)

------------------------------
Lenny Adams
Technology Early Career Development Program (TECDP) Intern
Cigna
------------------------------