Announcements
I have excel files as bellow,
I need to open the excel file by date. so I used below code,
But, below error came(Failed to open excel file). Please tell me how to solve it
Print the full path in a display box and see what path it shows up.
It shows the asterisk also. Clearly there is no such file with the asterisk.
The parameter needs an "existing Excel document" it says.
If you want to open today's file and if you are sure that there is always going to be 1 file having today's date then you can use this approach which makes use of File filter option.
After doing the above,
%Files[0].Fullname% will give the name of the file you need having today's date.
Now you can use it in Launch Excel.
It worked. Thank you very much
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Mohsin Ali 426
11manish 349 Super User 2026 Season 2
M Bilal Khan 308