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.
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.