Working with a webpage

  • Thread starter Thread starter kidkosmo
  • Start date Start date
K

kidkosmo

Hi, Gang,

Hoping someone can help me out here. I am working on a project to
update some information on a wiki page from data in my database. I've
gotten as far as this below (all foreign terrority):

strPath = rs1!wikiEdit

Set IE = CreateObject("InternetExplorer.Application")

IE.Navigate strPath
IE.Visible = True

Delay (10)

IE.Document.All.Item("content").Value = WIKI

What I need to do after I paste in the data is click the Save button.
Is there a command I can provide in my code that will perform this
function for me? Below is the source code I believe to be associated
with the Save/Cancel button (again...foreign territory).

<!-- content editor -->
<div class="inputSection">
<div class="submit-buttons">
<input
tabindex="102" accessKey="s"
type="submit" name="confirm" value="Save"/>&nbsp;&nbsp;
<input
tabindex="104" type="submit"
name="cancel" value="Cancel"/> </div>
<div id="draft-status">
</div>
<div id="editorDiv">

Any help would be greatly appreciated!
 
On Thu, 4 Feb 2010 21:42:03 -0800 (PST), kidkosmo

Possibly:
ie.document.forms(0).submit()

-Tom.
Microsoft Access MVP
 
On Thu, 4 Feb 2010 21:42:03 -0800 (PST), kidkosmo


Possibly:
ie.document.forms(0).submit()

-Tom.
Microsoft Access MVP













- Show quoted text -

I'm afraid that didn't quite work. Just using the "submit", it takes
you to the site search page rather than the Save command. I've tried
other variations with now luck. Any other ideas?
 
On Fri, 5 Feb 2010 07:34:50 -0800 (PST), kidkosmo

C'mon, work with me. Rather than saying: it didn't work - give me
something else, why not saying: wow, that was close. It submitted
something. It submitted the wrong form, but now I see this document
has several forms, and the one I wanted to submit apparently is not
form(0). I bet if I change that to ...

-Tom.
Microsoft Access MVP
 
On Fri, 5 Feb 2010 07:34:50 -0800 (PST), kidkosmo


C'mon, work with me. Rather than saying: it didn't work - give me
something else, why not saying: wow, that was close. It submitted
something. It submitted the wrong form, but now I see this document
has several forms, and the one I wanted to submit apparently is not
form(0). I bet if I change that to ...

-Tom.
Microsoft Access MVP





- Show quoted text -


wow, that was close. It submitted
something. It submitted the wrong form, but now I see this document
has several forms, and the one I wanted to submit apparently is not
form(0). I bet if I change that to ...

ie.Document.getelementsbyname("confirm")(0).Click

it will work.
 
Back
Top