Copy Paste from Word to Excel

Question

Hello everyone, I am new to Zapier. In my job I faced the task of making a glossary. That means I have to copy one line in Russian, then its equivalent in English & paste it the Excel file. Is there a way to partially automate this task? For example, if I highlight the line, and Zapier copies it and inserts it in the opened Excedl file?

If MS Word is not available, I think I could use Google Docs.

Thanks!

ikbelkirasan · Accepted Answer

Hi @Anastasia Zatonskaya- Unfortunately, that can’t be done with Zapier. However, you might want to look into a less fun solution but could potentially work in your case. The solution is to use VBA macros to achieve what you want. Here’s an example I found:http://learnexcelmacro.com/wp/2012/01/how-to-copy-content-from-word-using-vba/

ikbelkirasan · Answer

Also, if you’re using Google Sheets & Google Docs, you might want to look into Google Apps Scripting to write a script that can copy & paste from adoc to a sheet. I’m not entirely sure whether or notthis is possible though so you’ll have to try it out.

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded