Hi,
I am looking to write a code in Office Scripts. I am trying to open a spreadsheet, then send it as a PDF to a list of people, every morning at a certain time. I cant quite figure it out. I have an Automate flow to start trigger in the morning, and Run a Script, but I cant quite get the script right. Help?
Thanks
You can automate tasks using the windows task scheduler. The windows task scheduler can open an Excel file, but cannot run a macro. An Excel file can open another Excel file and run a macro. The attached has the files and explains the system to do this.
First you create the Excel program that makes the PDF and mails it. This is known as the target file. Then you clone the Control Template and give it a meaningful name. You fill in certain cells in the Control Template and, among other things, it gives you the script you need in the windows task scheduler. Copy this to notepad.
Then set up the windows task scheduler to run the renamed control template. At the appropriate time, the windows task scheduler opens the control template, which in turn, runs the macro in the target program.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
If you don't change the excel file at all, no need to write any code. The first step of your flow is "Convert file" and the second step is "Send an email".
If you do need to change the file, the Scripts code is just as same as what you normally write.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks