[login to view URL]: Convert responseBody to String in Excel VBA.

進行中 投稿 4年前 着払い
進行中 着払い

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

エクセル ビジュアルベーシック アプリ用ビジュアルベーシック VB.NET Excel VBA

プロジェクトID: #21801981

プロジェクトについて

4個の提案 リモートプロジェクト アクティブ 4年前

4人のフリーランサーが、平均£16 で、この仕事に入札しています。

Mokshith30

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

£18 GBP 1日以内
(49件のレビュー)
4.9
josna000999

Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss.

£10 GBP 5日以内
(0件のレビュー)
0.0
sfarzat

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

£24 GBP 7日以内
(0件のレビュー)
0.0
TrueGovt

I have always striven to do the best. I am a very hard worker and always deliver the work on time. My Motive is to make my employer happy. I know the work would be a unique combination of a task which I have learned もっと

£10 GBP 2日以内
(0件のレビュー)
0.0