Can we pass variables to excel application scope instead of file path?

Help
, ,
1

Hi guys,

Is there any way by which we can pass a variable to excel application scope instead of the file path?

I know that we can do it by using the command (Directory.getfiles) and looping it in a for loop with item.tostring. But is there any alternate way by which the user input (complete file path) can be read, stored in a variable and then pass this variable at run-time to excel application scope?

I tried it and it is showing that (Illegal characters in file path)! Is there any other way we can perform this.

Thank you in advance.

2

@batBot

Yes you can pass variable into Excel Application Scope activity and make sure you passed absolute path of the excel file.

I guess you didn’t specify file path properly here and that’s why you are getting error.

3

The issue is we have to pass different paths at run time, and based on what excel comes in the bot will do different actions on it.

Now I do it by manually changing the excel path on ExApSc i tried passing the variable to ExApSc by clearly predefining the file path but error shown : Illegal characters in file path!

If possible can you show an example.

4

@batBot

Could you please show me screenshot of how are passing data and also put one message box before Excel application scope activity and print the value you are passing. And help me with that screenshot also. So that I can check and help you.

5

sorry my bad I think I figured it out I accidentally passed the double codes too :sweat_smile: :ok_hand:

1 Like
6

Thank you @lakshman got it

Cheers!

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.