Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. asianinvasian

    How to connect to a website through a macro?

    I'm running in to a problem.. Set oElements = oIE.Document.GetElementsByName("var1") '1 is the field for app ID Set oElement = oElements(1) oElements.Value = Ref the last line of this code errors out sometimes and states that the object value is set to nothing. this...
  2. asianinvasian

    Send an email from access

    I got this to work in EB Set ol = CreateObject("Outlook.Application") Set olns = ol.GetNamespace("MAPI") Set olmail = ol.CreateItem(olMailItem) With olmail .To = "Address you are sending to" .Subject = "Your Subject" .body = "Body Text" .Send End With But i'm...
  3. asianinvasian

    How to connect to a website through a macro?

    Thank you to everyone who gave me tips :) or really wrote most of it haha.
  4. asianinvasian

    How to connect to a website through a macro?

    Oh also that code on the web page, for me its <select name=”var”> <option value=''>Choose Option</option> <option >Complete</option> option >Incomplete</option> <option >Incomplete - Need Call</option>
  5. asianinvasian

    How to connect to a website through a macro?

    CreateObject works fine. I’m now running into another problem. oSelect.Text = camp oSelect2.Text = "Incomplete" I have two select fields. One is for camp and the other is the status (oSelect2) The camp is all numbers. So I have that working just fine. However the status(oSelect2) are strings...
  6. asianinvasian

    How to connect to a website through a macro?

    A list box is a "select" tag. With a list box you'll also have to enumerate the oElement.Options.Length and do a oOption.Selected = True to change the item selected." i'm a bit confused on this part acutally still. Not quite sure how to go with this.
  7. asianinvasian

    How to connect to a website through a macro?

    Alright i got that to work on google. is there a way to figuer out which item(x) the submit button is on my site?
  8. asianinvasian

    How to connect to a website through a macro?

    Awesome Thanks! i got it to populate the fields i want. How do i make the button click? or submit
  9. asianinvasian

    How to connect to a website through a macro?

    Should oElements and oIE be Dim as Object? i also get an error when i compile the code in the macro editor for the for statement.
  10. asianinvasian

    How to connect to a website through a macro?

    Hello, New to this site. Just signed up :D i've been browsing the forums and i found a whole bunch of information i can use at work with Extra! personal client 6.5 What i haven't ran into is how to send information to a website. At work we have a site that we enter what we completed. Lets say i...

Part and Inventory Search

Back
Top