ExcelBanter - Problem reading HTML code from Excel-VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Problem reading HTML code from Excel-VBA (https://www.excelbanter.com/excel-programming/377478-re-problem-reading-html-code-excel-vba.html)

Erik Klausen

Problem reading HTML code from Excel-VBA

"Michel Pierron" wrote in
:

Hi Erik,
Try:

With CreateObject("Microsoft.XMLHTTP")
.Open "GET", Worksheets("Mellemregninger").Range("B13"), False
.Send
S = .ResponseText
End With

Hi Michel

This worked fine Thanks!

KR,
Erik

All times are GMT +1. The time now is 04:37 AM.