Hi everyone,
I’m at the start of a huge learning curve with Applescript and feel way out of my depth. I’m sure what I’m trying to achieve is possible but I don’t know how to go about it.
I am trying to create a Droplet that will convert Word documents into pdf files and save them into a designated folder, not the same folder as the Word documents. Seems straightforward enough.
Google showed me a script that will save pdfs into the same folder as the Word documents but that’s not what I require and I don’t know how to change it.
Another problem is the script only works with straight forward Word documents. By that I mean the files I’m working with all have multiple links to external data in an Excel workbook. The links are set to automatically update. When the document opens, a prompt appears requiring a response. I don’t know how to write a script that answers the prompt. See image.
All the files open but the script fails at the prompt, so I have to manually click ‘Yes’ for each one.
Ideally the script would answer ‘Yes’ (not ‘No’) to the prompt for each file in the list and then save a pdf into my designated folder before closing.
Another problem. The automatic update setting, triggers another prompt on closing the document, asking if I want to save changes or not; ideally yes. I don’t know how to write a script to answer this prompt either.
Turning the ‘Update: automatically’ option on and off gets around the prompts but it’s not really a viable solution. In short, I looking for a Droplet that can answer both prompts appropriately and also save a pdf to my designated folder.
Please, if anyone can help me?
I’m at the start of a huge learning curve with Applescript and feel way out of my depth. I’m sure what I’m trying to achieve is possible but I don’t know how to go about it.
I am trying to create a Droplet that will convert Word documents into pdf files and save them into a designated folder, not the same folder as the Word documents. Seems straightforward enough.
Google showed me a script that will save pdfs into the same folder as the Word documents but that’s not what I require and I don’t know how to change it.
Another problem is the script only works with straight forward Word documents. By that I mean the files I’m working with all have multiple links to external data in an Excel workbook. The links are set to automatically update. When the document opens, a prompt appears requiring a response. I don’t know how to write a script that answers the prompt. See image.
All the files open but the script fails at the prompt, so I have to manually click ‘Yes’ for each one.
Ideally the script would answer ‘Yes’ (not ‘No’) to the prompt for each file in the list and then save a pdf into my designated folder before closing.
Another problem. The automatic update setting, triggers another prompt on closing the document, asking if I want to save changes or not; ideally yes. I don’t know how to write a script to answer this prompt either.
Turning the ‘Update: automatically’ option on and off gets around the prompts but it’s not really a viable solution. In short, I looking for a Droplet that can answer both prompts appropriately and also save a pdf to my designated folder.
Please, if anyone can help me?