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.