How to handle save as dialogue box which came from excel
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.
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.