View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Calligra[_2_] Calligra[_2_] is offline
external usenet poster
 
Posts: 17
Default Opening & setting data from Excel to webpage


OK guys, I could really use someone's help. I have an excel document
where I have gathered information relating to Software bugs. I now
desire to call a website that stores our information in a SQL DB to take
the gathered information and add a bug to the site.

I cannot write to the DB directly due to the fact that multiple users
must be able to access the DB at the same time without disrupting the
use of the DB for all.

My problem is that the code I'm attempting to utilize does not seem to
call the webpage and sHTML doesn't ever get set to anything. If I live
in the "Do Until" then the program loops infinately. Below is the code
I'm attempting to use:

Application.ScreenUpdating = True
Set IE = GetObject("InternetExplorer.Application")

With IE
.Visible = True
.Silent = True
.Navigate "http://Intranet/Add/topic_add.asp"
Do Until Not .Busy
DoEvents
Loop
sHTML = .document.documentelement.innerText
.Quit
End With
Set IE = Nothing



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!