I am trying to Open downloaded Excel file with Variable name and remove duplicate. In Variable value file path shown, but it is not considered in vbscript.
Can Anyone please help me.
Tried with Below. Want to use Input_Master_File variable to open workbook.
Set objExcel=Createobject("Excel.Application")
Set objwbk=objExcel.Workbooks.Open("Input_Master_Files")
You use the variable as path in VBscript like this as shown in image.
I think in you case you have list files so use %Input_Master_Files[0]%,if first is the required file path in the list.
(Note:- if you got your solution you can mark as solution and gives kudos)
Thanks & Regards
Vishnu Reddy
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
12
Share
Report
All responses (
Answers (
