Save new Excel Workbook

[sumire]

Hello,

I want to save a new Excel workbook that is manually opened
without using "send hot key".
Please anyone tell me how to create object.

Thanks,



------------------------------
Mitsuko
Asia/Tokyo
------------------------------

[jegendra]

Hi Mitsoko san,

Have you tried using the Blue Prism Business Object MS Excel VBO which contain the following Actions?

• Save Workbook
• Save Current Workbook
• Save Workbook As
• Save Current Workbook As

------------------------------
Jega Avinasinathan
Customer Support Engineer
Blue Prism
------------------------------

[sumire]

Thanks for reply
I tried, but the first problem is that Excel cannot be attached.
This is because 2 Excel processes (1 foreground and 1 background) are running.
There is only 1 Excel workbook on screen that is started manually.

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

[vivek.kumar.goel]

Try this action:

It works perfectly for me.

Once done use the SAVE AS

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
+6594554364
https://www.rpatools.com/
------------------------------

[sumire]

@Vivek Goel

thanks for suggest.
what should I enter in field "File Name"?
this is new excel workbook and not saved yet, so it doesn't have file name.​

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

[vivek.kumar.goel]

If you have only 1 workbook open, then you can use something like this:

If multiple workbook are open, then you need to use the "Attach workbook" option and provide "Book1.xlsx" for an example

For your case, first option is better

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
+6594554364
https://www.rpatools.com/
------------------------------

[sumire]

@vivek.kumar.goel
I tried, but could not attach.
The first problem is that Excel cannot be attached.
This is because 2 Excel processes (1 foreground and 1 background) are running.
There is only 1 Excel workbook on screen.
It was created like this:
CreateObject("Excel.Application") and Workbooks.Add() then set data

I think CreateObject launches another excel process in background, but I don't know if it is true.



------------------------------
Mitsuko
Asia/Tokyo
------------------------------

[vivek.kumar.goel]

Why is it So? You should be able to attach. Try using as per the screenshot 

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
+6594554364
https://www.rpatools.com/
------------------------------