topic RE: Save new Excel Workbook in Product Forum

Save new Excel Workbook

sumire — Mon, 18 Nov 2019 04:24:00 GMT

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
------------------------------

RE: Save new Excel Workbook

jegendra — Mon, 18 Nov 2019 05:39:00 GMT

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
------------------------------

RE: Save new Excel Workbook

sumire — Mon, 18 Nov 2019 05:49:00 GMT

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
------------------------------

RE: Save new Excel Workbook

vivek.kumar.goel — Wed, 20 Nov 2019 04:18:00 GMT

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/
------------------------------

RE: Save new Excel Workbook

sumire — Wed, 20 Nov 2019 04:36:00 GMT

@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
------------------------------

RE: Save new Excel Workbook

vivek.kumar.goel — Wed, 20 Nov 2019 05:18:00 GMT

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/
------------------------------

RE: Save new Excel Workbook

sumire — Wed, 20 Nov 2019 05:40:00 GMT

@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
------------------------------

RE: Save new Excel Workbook

vivek.kumar.goel — Wed, 20 Nov 2019 12:17:00 GMT

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/
------------------------------