cancel
Showing results for 
Search instead for 
Did you mean: 

Excel - Popup

JaneRobert
Level 2
Im getting the Save & Save As window while opening the excel file with excel vbo action. Do we have any solutions to disable this window.

------------------------------
Jane Robert
------------------------------
1 BEST ANSWER

Best Answers

david.l.morris
Level 14
Can you describe the sequence of steps your process goes through when working with Excel? Typically, a Save & Save As window won't pop up while using the Excel VBO if you use the standard actions of Create Instance > Open Workbook > Get/Write Collection > Close Instance (with input as save True or False).

------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------
Dave Morris 3Ci at Southern Company Atlanta, GA

View answer in original post

2 REPLIES 2

david.l.morris
Level 14
Can you describe the sequence of steps your process goes through when working with Excel? Typically, a Save & Save As window won't pop up while using the Excel VBO if you use the standard actions of Create Instance > Open Workbook > Get/Write Collection > Close Instance (with input as save True or False).

------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------
Dave Morris 3Ci at Southern Company Atlanta, GA

Thanks, There was an error in macro code. Now its working fine

------------------------------
Jane Robert
------------------------------