I have a Excel file.
I need a macro that will translate from English to Spanish with using translate.google.com
Sample of my xls file I've attached.
I have a Excel file.
I need a macro that will translate from English to Spanish with using translate.google.com
Sample of my xls file I've attached.
Hi evek
Welcome to the forum.
I found this link, I must confess I haven't tried it out myself yet.
http://vbaexcel.eu/vba-macro-code/go...rer-automation
Hope this helps.
Thanks for your reply.
I try to use it for my file -- doesn't work
I ran it on theirs attached -- same -- getting errors
Last edited by Leith Ross; 05-15-2013 at 02:30 PM.
I may have found a function that can be modified to suit your sheet.
I can't look further into it at present, look back tomorrow, I might have something then.
Ok, Thank you!
Last edited by Leith Ross; 05-15-2013 at 02:31 PM.
evek, please don't quote whole posts; it's just clutter. Use the REPLY button, not the QUOTE button.
Thanks.
Entia non sunt multiplicanda sine necessitate
Good question! I had tried Google translate recently andit wasn't up and running yet as I recall.
I created a UDF that does the rick for you. I filled it in for the first 100 rows or so, works great. You can do the rest from your machine. I don't know at what Google might block repetitive queries from one IP address.
Here's the code I put in a standard module in your workbook:
Please Login or Register to view this content.
ShredDude, how you added new users function in excel 2007?
Sorry, I found. Working fine.
Thank you !!
Last edited by Leith Ross; 05-15-2013 at 02:31 PM.
Sorry a bit late, but as promised here we are.
I saw ShreadDudes' post and have run a comparison with the code I found earlier, see the attached workbook.
I have included a sheet that lists the codes that Google Translate uses and a link for more code and updates.
Go with ShreadDude! his/her code is shorter and better.
I hope this adds a little bit more help.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
I tried copying the code over and making UDF in excel to use this function but I couldn't get it to work.....it keeps saying there is an error and it will stop debugger or something...and then pulls up the code and has Replace highlighted yellow like I need to change that....I am in 2004 excel
I could also be doing something very basic wrong and not know it...I am new to writing these things and basically just cut the code from the previous post and tried to drag it down.
I also tried using the files that were put up here and moving my cells in there but gave me the same problems.
please help!
Hi shreddude, great UDF it works great, i just have a doubt, how i have to do for doesn't stops at the first "." (dot) that the UDF finds... thank you very much
great job, well done THX
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks