Hi all

Currently I need to execute an excel file (double click it ) daily, which consists of Data link to other Excel tables in various Document Library (MS SharePoint). Thereafter, this updated Excel worksheet will be extracted by another Infra system to update our Windows Active Directory

Basically, I need to open and save it and close daily, the purpose is just to let the PowerPivot table refresh the latest data model.

Is there a way to write a script to open and save at a dedicated timing of the day automatically, without having man in loop to physically run it and save.

Thank you!