Excel - Open and leave the file open - Start process / Excel App Scope

Learn Academy Feedback
1

Hey,

Does anyone know how to keep an excel file open after opening it?

I’ve tried the following methods with no success

Start Process - Used this activity and it locates the file but fails to interact with the password dialogue box as the file is password protected and the activity is faulted with the message “Application could not be opened”
Q: How do you get the Start process to interact with the password dialogue box

Excel Application Scope - This found and opened the file but closed it straightaway -

Q: How do I keep the file open as I need to interact with two excel files to create a pivot?

Thanks

2

Just a suggestion,

You can open the password protected Excel first using excel application scope and open another excel within that excel application scope. Do all the required processes inside the excel application scope.

Excel application scope will automatically close the excel

3

Hi @Supernova,

Why you want the excel file to be opened?

4

Curious to understand how to open a file and close it as and when i want and not when the system decides to close it

5

Better to build your own package to open Excel

6

Resolved it by using the below activity

Open Application (Excel.exe)
Then used click activity to Open File
Type Into activity for the file location
Type into for the password
and another click to open the document.

Start process would have been ideal if only it recognises the password dialogue box