Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sravan Aluvala (chakri5122)
Accenture

Accenture
IN
chakri5122 Member since 2017 12 posts
Accenture
Posted: Mar 9, 2019
Last activity: Mar 21, 2019
Posted: 9 Mar 2019 13:59 EST
Last activity: 21 Mar 2019 0:58 EDT
Closed

How to handle save as dialogue box which came from excel

Hi,

I am working on Excel, where I got to run a macro to save the content into pdf. But the problem is when I run macro it pops up a save as dialogue box where I have to give the location path and file name.

Since I'm using connectors for Excel, I can't interrogate that save as dialogue box.

Please help me in solving this.

To see attachments, please log in.
Robotic Process Automation

Posted: 6 years ago
Posted: 21 Mar 2019 0:56 EDT
Sravan Aluvala (chakri5122)
Accenture

Accenture
IN

If I am supposed create a windows adapter to handle that
1.What should be the path for the adapter.

2.If I choose the direct excel file path it is not accepting as a valid path(Since the File extn is .Xlsb)
3.So, I took the adapter path as Excel.exe from program files, But still it launches a new workbook when ever I Start Interrogation and the Interrogation form gets closed keeping the new Excel file opened.   

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice