Open the specific sheet from the excel

Help
21

Tried with this also, Now in the initial excel open with Test sheet. But again it come back to the Sheet1 only.

22

here you go
opensheet.zip (17.1 KB)

kindly mention your filepath and sheetname
hope this would help you
Cheers @balkishan

2 Likes
23

In the code i provided it should not open the excel file . It will do the work in background.
“excel.Visible = False” is proper right?

1 Like
24

Thanks Palani, But similar sol @vishal.kp provided. It open the test sheet, but after 2-3 sec again it show the default Sheet1 only.

1 Like
25

It’s Visible is true only

26

change true to false

1 Like
27

hmm
but it was working fine for me
excel.Visible = True

it was opening the exact sheet we need and the application is still open and has not closed

@balkishan

1 Like
28

@vishal.kp @Palaniyappan It open with Test sheet, but when Send Hotekey start working then it show the Sheet1 only.

29

may i know how the send hot key activity is placed if possible may be a screenshot
Cheers @balkishan

30

can you send your workflow.

31

its work for me.

32

Hi @Bhargavi_Lokapur,

This is a very Old thread is you can mark the solution please do it so that the thread can now be closed and others can refer it.

Thanks

33

hello sir… i have one concatenate formula… when i write this formula in write cell it give error.
Formula is =CONCATENATE(D2," “,“INV NO”,”-“,E2,” “,D3,” “,“INV NO”,”-“,E3,” “,D4,” “,“INV NO”,”-“,E4,” “,D5,” “,“INV NO”,”-",E5)
error is ; is expected. name INV could not be found. operator '- ’ can not be applied to operands of type “string”