Display server message to user after POST file upload

**cows** · 02-06-2014, 06:43 PM

I'm using VBA to upload the open workbook to app.box URL which is working great! Since I'm pretty new to VBA, I can't figure out how to get Excel to display the sucess/failed message from the server to the user. I used the VBA POST upload module from this awesome tutorial, but I can't figure out how to return the message to the user. Any suggestions?

I did figure out that on the website there is an "id="after_upload_message", not sure if that helps. My code is below.

Please Login or Register  to view this content.

**wqweto** · 02-11-2014, 04:38 PM

Hi,

Just remove `bAsync` parameter and dimension it as a local variable (`Dim bAsync As Boolean`).

This way the `Send` method of `XMLHTTP` will execute syncronously so you can access `ResponseText` property just after `Send` call (but before `End With` statement).

In this way you can communicate success/failure response from the web service in plain-text (or JSON or XML encoded).

cheers,
</wqw>

**cows** · 02-20-2014, 02:28 PM

Thanks for the help!

Display server message to user after POST file upload

LinkBack

Thread Tools

Rate This Thread

Display

Display server message to user after POST file upload

Re: Display server message to user after POST file upload

Re: Display server message to user after POST file upload

Thread Information

Users Browsing this Thread

Similar Threads

Upload current document to http server (using POST)

Use a Macro to Upload Excel File to FTP Server when saving

Upload file on a server

[SOLVED] upload excel file into sql server

[SOLVED] save XL file to server via FTP upload

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions