Converting Excel to PDF Using a task schedular or service when the user is logged out.

Question

Dear Team, I am reaching out to seek assistance with automating the process of saving Excel Reports on a daily basis. Given that my excel reports have formulas that continuously updates the values in each cell, it is crucial for us to maintain a record of these reports daily for user access, with each report reflecting the specific date of its generation. Previously, I attempted to execute a code for converting Excel files to PDF format through automation on a daily schedule. However, it encountered issues as the user needs to be logged in for the code to interact with Excel and save the file as PDF with the designated date. To streamline this process effectively, I would appreciate any guidance or solutions you could provide to automate the saving of these reports daily, even if the user is not logged in.

The conversion needs to happen non-interactively.