Working with a webpage

[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!

 

[Tom van Stiphout]

On Thu, 4 Feb 2010 21:42:03 -0800 (PST), kidkosmo

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

-Tom.
Microsoft Access MVP

 

[kidkosmo]

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?

 

[Mark Andrews]

This link might help:
http://www.ozgrid.com/forum/showthread.php?t=138829

I think you need to "click" the button via code (see the .click)

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com

 

[Tom van Stiphout]

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

 

[kidkosmo]

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.