+ Reply to Thread
Results 1 to 2 of 2

Upload excel sheet to google translate (and pull the result) via VBA

  1. #1
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Upload excel sheet to google translate (and pull the result) via VBA

    Hi guys and gals,

    is there a way to upload a sheet to google translate via VBA?
    I can easily do strings, but what if I want to upload a file - how would I do that....?

    Any help would be appreciated.
    Thanks!

    Jasper

  2. #2
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Upload excel sheet to google translate (and pull the result) via VBA

    So in another thread, I figured out how to load XLSB/XLSX files into a variable and put them into the body of a POST request.
    However, it seems like I haven't figured it all out - as google translate doesn't give me the translation.
    I'd love some feedback on what I am missing here.

    Code I have so far, which saves a workbook and loads it into a variable - and then tries to upload it to Google Translate:
    Please Login or Register  to view this content.
    Either the responsetext is empty, has "The translation of file " and then nothing or "Sorry, the page you requested contains a file type (application/octet-stream) we are unable to translate".
    All with the same code.

    Ahhh, the fun of VBA - I would really love some help here.
    (Hoping that Kyle123 is still around... ;-))
    Last edited by JasperD; 06-08-2017 at 04:04 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Get google translate result from vba?
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-29-2021, 07:36 PM
  2. Macro: translate text from cell using google translate
    By Marc_excel_tips in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-05-2021, 06:18 AM
  3. Save text as word document and pull that through google translate
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2016, 03:05 AM
  4. How to catch errors from Google Translate
    By MrsMac in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-29-2014, 09:18 AM
  5. need Google Translate in Excel 2003
    By appu_gusai in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2013, 08:27 AM
  6. Pull google results - title, description,url into excel sheet using VBA
    By joewhyte in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 09:53 PM
  7. Replies: 7
    Last Post: 01-12-2009, 06:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1