Code to import CSV directly into workbook from server

**jaryszek** · 03-23-2022, 07:05 AM

Hi,

i am using WinHttp object to connect to web service run by java. i am connecting to CSV table.
The issue is that response body is in bytes and i want to get just array from it.

It is possible?
If not what should i do ?

Code:

Please Login or Register  to view this content.

Please help,
Jacek

**Marc L** · 03-23-2022, 11:19 AM

Hi,

you must use a Byte array like in this thread …

**jaryszek** · 03-24-2022, 02:07 AM

Thank you Marc,

Best,
Jacek

Code to import CSV directly into workbook from server

LinkBack

Thread Tools

Rate This Thread

Display

Code to import CSV directly into workbook from server

Re: Code to import CSV directly into workbook from server

Re: Code to import CSV directly into workbook from server

Thread Information

Users Browsing this Thread

Similar Threads

VBA Code to export or import between fixed named workbook and variable name workbook

VBA code to run SQL code and import data from Microsoft SQL Server to excel

VBA code to import Outlook calendar data directly into Excel

Trying to import CSV directly to XLSM workbook

Code to force Server Document Panel to open/display when a Workbook is opened?

Import excel and put it directly in different colums (vba)

Bookmarks

Bookmarks

Posting Permissions