Posted to microsoft.public.excel.programming

Erik Klausen Erik Klausen is offline

external usenet poster

Posts: 3

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem reading value from Excel spreadsheet	Jack	Excel Programming	3	October 12th 06 02:42 AM
Import HTML code into Excel	josuegm	Excel Programming	2	May 30th 06 11:02 PM
Reading complete Excel using DDE code	amitkrsingh	Excel Programming	1	August 19th 05 02:43 PM
Code problem emailing range as html in Outlook body	Alan Campbell	Excel Programming	3	August 25th 04 06:59 PM
Calling HTML Source code from within VBA for Excel	Peter Dickson	Excel Programming	0	July 9th 03 08:38 PM

All times are GMT +1. The time now is 09:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us