472,127 Members | 1,465 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.

How to set comboboxes in Google language translation form?

Hello, I want to translate text dynamically from my VBA application with the Google translation tool.

I have already figured out how to send the original text (eg in English) to the 'original text field' (id in html is 'source').

QUESTION: How to set the from and to languages (combobox)?
I have spend several hours to find out how to set the 'from' and 'to' language. Without succes. Can anybody help me? It seems that these fields make a part of a more complex datastructure...

The relevant html can be found by:
1. Type http://www.google.nl/language_tools?hl=en
2. See the two comboboxes under 'Transate text'

VBA code I'm currently using to set the 'source' text:

Expand|Select|Wrap|Line Numbers
  1. Set ie = CreateObject("InternetExplorer.Application")
  2. ...
  3. ie.Document.All("source").Value = TxtbText.Value()

Version VBA used: I'm using Office Excel 2003, SP2, part of office small business edition 2003

Currently my development is stuck on this, so I hope somebody can help me quickly, thank you,
Oct 3 '08 #1
1 2281
297 100+
Check out this blog:

The only real issue is that you will have to screen scrape to get the result. That's often easier if you include something to delimit your text that is part of the text that won't get translated. Something like:
||# text to be translated # ||
This way the translated text will have the delimiters and will be easy to find.
Oct 4 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

30 posts views Thread by Gustaf Liljegren | last post: by
reply views Thread by Thiva Charanasri | last post: by
2 posts views Thread by OM | last post: by
reply views Thread by Thiva Charanasri | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.