web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

Open Excel file

(0) ShareShare
ReportReport
Posted on by 22

I have excel files as bellow,

Dumi_0-1653017692136.png

I need to open the excel file by date. so I used below code, 

Dumi_1-1653017923626.png

But, below error came(Failed to open excel file). Please tell me how to solve it

Dumi_2-1653018002583.png

 

  • Verified answer
    VJR Profile Picture
    7,635 on at

    Print the full path in a display box and see what path it shows up.

    VJR_4-1653019633782.png

     

     

    It shows the asterisk also. Clearly there is no such file with the asterisk.

    The parameter needs an "existing Excel document" it says.

     

    VJR_1-1653019055380.png

     

     

    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.

     

    VJR_2-1653019301940.png

     

    After doing the above, 

    %Files[0].Fullname% will give the name of the file you need having today's date.

     

    VJR_3-1653019465169.png

     

     

    Now you can use it in Launch Excel.

  • Dumi Profile Picture
    22 on at

    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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 426

#2
11manish Profile Picture

11manish 349 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard