Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing webpage data into Excel | Excel Discussion (Misc queries) | |||
restrictions in excel opening webpage ?? | Excel Discussion (Misc queries) | |||
Linking Webpage to Excel Data | Excel Worksheet Functions | |||
Opening a webpage from a vba macro in excel | Excel Programming | |||
opening webpage in excel | Excel Programming |