I wrote a novel in French a couple of years ago that I want to translate to English. The way I do it is paragraph by paragraph: copy/paste a paragraph in OpenRouter (Sonnet or Gemini), get back the translation, and rewrite/adjust it.
It works well but copying/pasting back and forth gets old very fast, and it would be better if the process was done inside the word processor. For some reason (various reasons) I still use Office 2003, which doesn't have any AI feature. (It does have a "translate" function but it's awkward to use and not very good.)
So I wrote a macro to send selected text to OpenRouter and replace with the response (with a system prompt that says to only output the translation, otherwise most models start with "Here's the translated text:")
I had never written a macro in vba; I got started with Sonnet and adjusted many parts with the help of StackOverflow (which turns out to have more information about vba than Sonnet...)
And finally it worked; and it turns out to be an incredible boost to translation productivity!
It works well but copying/pasting back and forth gets old very fast, and it would be better if the process was done inside the word processor. For some reason (various reasons) I still use Office 2003, which doesn't have any AI feature. (It does have a "translate" function but it's awkward to use and not very good.)
So I wrote a macro to send selected text to OpenRouter and replace with the response (with a system prompt that says to only output the translation, otherwise most models start with "Here's the translated text:")
I had never written a macro in vba; I got started with Sonnet and adjusted many parts with the help of StackOverflow (which turns out to have more information about vba than Sonnet...)
And finally it worked; and it turns out to be an incredible boost to translation productivity!