Hello Experts, Yesterday, while using Google Translator manually I just thought if it can be automated using VBA. Actually what my task includes is to Convert various European language values to Standard English lang.
I have values in a single Column (No fixed number of rows/values but it will be in a single column). What I do is, I separate all the European titles in different files according to their language and then upload it to google translator as a file. Then Select the language and click on go. It gives us the result on the next page. Now I just wanted to know, if VBA can do the following job for us. 1. Copies the values from those column. 2. Pastes it into a new file. 3. Saves it, Closes it. 4. Opens Internet Explorer with Google Translator. (I am able to do till here, next points are bit tricky for me or perhaps I dont know them yet). 5. Uploads the document we saved. 6. Selects the languages (Any european language to ENGLISH). 7. Runs the translator. 8. Copies the resulted values. 9. Pastes it back to excel file as values (Perhaps, it takes less time to be pasted as values rather than the format we copy from websites.) Again I can take it further from here like putting them in the adjacent cells to original values and saving it, Closing it. I would appreciate it very much if you experts help me in this. It will save lots of my time and effort in performing my current task and above to that I would be very happy if I learn the problems from Point # 5 to 9. Thanks again for helping me in all my previous queries. Regards- ANISh -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
