There are some 3rd party tools available that can assist with scheduled exports of reports (and reports can be indicated as Excel, word, or pdf) like Zap Report scheduler. The Appsource has a number of these programs and most of them are very economical in annual cost compared to the time wasted trying to solve for them.
Vice President, FIS Sales Tools, Infrastructure
4900 West Brown Deer Road, Brown Deer, WI 53223
FIS | Empowering the Financial World
If you've found this thread useful, dive deeper into User Group community content by role