Hi,
iam using below code (by using wildcard character "*" ) to open excel file. but it showing error
kpath = ThisWorkbook.Path & "\"
Workbooks.Open Filename:=kpath & "usd project*.xlsx"
Error: Run-time error '1004':
"Sorry, we couldn't find C:\Users\syed\Desktop\pipeline\usd project*.xlsx. Is it possible to moved, renamed or deleted?"
regards
syed