LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Importing webpage data into Excel Dave Excel Discussion (Misc queries) 4 May 21st 07 09:04 PM
restrictions in excel opening webpage ?? Andrew Excel Discussion (Misc queries) 0 October 1st 06 09:34 PM
Linking Webpage to Excel Data Taier Excel Worksheet Functions 1 November 19th 05 12:43 AM
Opening a webpage from a vba macro in excel Irishmaninusa Excel Programming 1 August 13th 03 07:28 PM
opening webpage in excel Rod[_3_] Excel Programming 8 July 13th 03 04:20 PM


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"