How can i do to let the exel file open when the process finish plz?

Learn Academy Feedback
1

how can i do to let the exel file open when the process finish plz ?

2

Put this activity after your Excel Application Scope. Granted, this re-opens the workbook, but this way the workbook will be open when you finish the process.

Processusvierge.zip (17,6 Ko)

1 Like
3

Use StartProcess activity and enter the full file path

image

1 Like
4

How can i open a excel file after invoke VBA plz ?

Here i used fichier2 but it doesnt work

5

InvokeVBA is carried out in an Excel Application scope.

Once it completes the file is saved and closed.

image

Use the StartProcess activity to then open the file

2 Likes
6

thank you it works :slight_smile:

7

What i have to put i here ?

image
image1453Ă—665 37.9 KB

@ronanpeter

8

Do not put StartProcess inside the excel application scope. Place it as the next step after that.

Then just put the full file path you wish to open in the executable box

9

it doesnt work my friend, the excel file comes from a datascraping

image
image1466Ă—513 19.3 KB

10

It doesn’t matter where the excel file comes from. As long as you have provided a valid file path to the StartProcess activity it will open,

Main.xaml (3.9 KB)

11

i am selecting any file, it comes from datascraping, i don’t know if i am clear ? :slight_smile:

The question is what i have to put in startprocess variable to indicate the file the datascraping just created

12

In your workflow you scrape the data then write it to an excel file, yes?

image

Then you run your VBA. Once you move away from that Excel Application Scope to another activity, you have an excel data file with the VBA applied to the data.

Is this what you want to then open?

1 Like
13

exactly

14

So as I said, to open the file once the VBA has run and saved the excel workbook, use StartProcess.

15

how can i do that plz ?
can you send me a picture ?

16

I sent you an example workflow of it opening any file you ask it to

17

with your xaml file, i need to chose a file with the activity selectfile, and its not what i need.

I need to open it automaticaly

if your process can do that, can you send me a picture plz :slight_smile:

18

Place the full file path to your excel workbook in the executable line here (i.e. in place of where it says strOutputFile below)

image

19

the file change everytime i lunch the the process,

i put the same full file path as u wrote and this is the error

image
image1920Ă—833 67 KB

20

Put a KillProcess activity in before the StartProcess activity. Set the ProcessName to “Excel”. Test again.