Hi, I am passing the variable item in the code but it’s showing me the error while executing that activity. But the value is coming from the item is correct. If give the direct path in the code it’s working fine. But when I pass the variable inside the code in the place of path giving then it has thrown me the error while item is giving me the correct folder path and file name.
see what value is printing item. It is the correct value which I want folder name with file name.
Fine the way the variable passed is right
but the value passed with is wrong it seems
kindly check once the path and validate whether it is correct or not
its getting failed while trying to open that file under the path mentioned
see bro before code stage I just used Excel Application Just to check whether the value coming from the item is correct and it read the file. But it read the file correctly it open the same excel file if you see the Excel Application Scope is executing and open the file.
Bro…It’s giving the correct path with file name. even I used in the Excel Application Scope just to check whether it’s readable or not but it’s reading correctly…same item I have passed in the Excel Application Scope.
@Palaniyappan The given path is readable bro. See I pass the same item variable in the excel scope application and it’s working, it open the same file.
But when I pass the same item variable in the code it doesn’t working and thrown an error which I already attached the snapshot.
And it’s giving me the correct file path with name. same item variable I am passing. As I have given in the Excel Scope it’s working. But when give in the code it’s saying file is removed or not there…
I don’t know why it is not getting the full path @balkishan.
Everytime we will get the full path. the thing is that, as we are using the code, it won’t recognize the path if we give short , we have it give it clear
No, If give the direct path then only it’s work, Like item variable printing the path.If I give this complete path then it work. But My file name is changing at last so I can’t give the direct path na. If everytime I got the same file then direct path I can give but here it’s problem.
Any solution for this…
Bro my file is name is diff. It will work only for specific file not for all. I can pass the full path but my file name is not same this is the reason.
it’s showing the full path in the code activity.
If I manually mention this path in the code it will execute…
master_template\AMAZON FILE TEST1234 - COD & E-Paymt final 25 July s.xlsm
But the problem is last bold name will be changing on date wise.