Excel VBA - Table to CSV HTTP Post

Asked Aug 22 '19 at 16:05

Active Aug 22 '19 at 20:23

Viewed 87 times

I am wanting to take a table with n Columns and n Rows and make a CSV variable/string in which I can send through a HTTP Post.

I have only been able to find solutions to create a CSV File. But, i do not want to create a File, I just want to send the final result through a HTTP Post. I know how to do the HTTP Post, I just don't know how to get the CSV to a variable/string and send without creating a File.

edited Aug 22 '19 at 20:23

Tim Williams

137,250
8
88
114

asked Aug 22 '19 at 16:05

Tanner A.

Don't write to a file but keep the content in a variable instead. – Tim Williams Aug 22 '19 at 20:23
I believe that's the part I'm not sure on doing, which is why I asked the question here. An example would be great! – Tanner A. Aug 22 '19 at 20:49
1

Various approaches here: https://stackoverflow.com/questions/39597999/turn-excel-range-into-vba-string – Tim Williams Aug 22 '19 at 20:52
Thanks for the link! I'll go through those and see what i can come up with. It would be nice if someone has already produced a similar result. – Tanner A. Aug 22 '19 at 20:57
Tim thanks for that link! That helped me get what i needed – Tanner A. Aug 23 '19 at 21:10

Excel VBA - Table to CSV HTTP Post

0 Answers0