[login to view URL]: Convert responseBody to String in Excel VBA.
£10-20 GBP
货到付款
When using [login to view URL], I get the response in responseText and responseBody. I want to use Byte Array in responseBody and convert it into string.
NOTE: To achieve this functionality you cannot write the array in file. All processing needs to be done in VBA.
Below is a sample byte array from responseBody :
[31,139,8,0,0,0,0,0,0,0,115,84,40,73,44,206,86,40,207,44,201,128,176,242,74,115,147,82,139,20,130,125,12,245,12,20,18,115,138,82,19,83,42,21,82,43,50,139,75,138,21,50,243,20,74,50,82,21,10,138,242,179,82,147,75,20,10,114,18,243,244,20,92,243,74,128,234,19,21,74,243,50,11,75,83,145,13,209,83,208,8,240,114,211,53,50,50,54,53,51,176,208,4,0,130,156,240,149,107,0,0,0]
Text for above bytes is:
A task with task number SL1.0 already exists in the project plan. Enter a unique task number. (PJF-2235608)
Fixed price: £10
项目ID: #21801981
关于项目
有4名威客正在参与此工作的竞标,均价£16/小时
hi I am vba developer experienced in web scraping and vba macros and I will finish this task in a day only pls share the details thanks
Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss.
i have very good vba experience. i can make this job 100% in excel vba. let me know more details about this job. thank you