How to save workbook and close workbook within excel application scope?

When I run job, excel opens and copies values…but excel is not getting closed after saving.

What might be the issue ?

close%20workbook

@johns

Create one workbook variable for Excel Application Scope Activity and pass that variable into Close Workbook Activity to close it.

Can you show practically by providing example or .xaml file to save it, and close the application.

It will be very helpful for me.

Keep the close workbook activity outside the excel application scope. Provide the path of excel in excel application scope and take the output to close workbook.

image

1 Like

Could you send me xaml file.

I have a big work-flow. Where can I use Excel application scope. I need to save workbook and close the workbook.

Can someone send me xaml file?

@johns

Please find the attached workflow for your reference.

Excel.xaml (6.4 KB)

Hi Lakhsman,

Thank u for sharing everytime something new.
I have question very similar to this:

I have to extract the data and save it in an excel file and then again in ht e next step I have to save it in a Text format as well but when it saves in the excel format, it saves but also opens up the file(excel). Now I want to close this file and then perform the 2nd step as mentioned above. So for this shall I use Kill process(to close the excel which is opened or close application or close workbook, but in that case I need to give the path of the file where it is saved.
Thank u in advance

1 Like