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!

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

Recent content by zunni

  1. zunni

    Outer Join Woes

    Hi, I'm having trouble with creating an outer join involving 3 tables. Can someone shed some light for me? I have three tables: Tables Columns -------------------------------------------- Jobs id,type Action id,type,Job_id Action_sub_type id,type,Action_id...
  2. zunni

    Using Excel to log in using XMLHTTP

    Oh oh! I have hit another snag While the .responsetext shows that I have successfully logged in and shows the html of the next webpage. I can't navigate to it using IE like in the tek-tips example above. Does anyone know why?
  3. zunni

    Using Excel to log in using XMLHTTP

    Arghh! Such a simple error
  4. zunni

    Using Excel to log in using XMLHTTP

    Hi Thanks for your reply. In response to your points: 1. In my .open statement I am using the full URL, just have not included it in my example. 2 and 3. I have tried it with and without some of the query string. From the HTML code: <form name="frmLogin" method="Post"...
  5. zunni

    Using Excel to log in using XMLHTTP

    Hi, I havent read that post before but I am very confident in using the InternetExplorer object to navigate and complete forms in VBA and can log in using this method (and have done so already). However, I want to experiment with XMLHTTP and want to see how the two methods differ in terms of...
  6. zunni

    Using Excel to log in using XMLHTTP

    Hi, I am experimenting with using XMLHTTP and the POST method in VBA to log into a local webserver, but I can't seem to send the right parameters to submit the login details. I have extracted the HTML code for the form element below: <form name="frmLogin" method="Post"...
  7. zunni

    Referencing Current Outlook Appointment

    Thanks, that's great. Is there a way to do it if the 'item' is not open but highlighted? Also, is there a way to query which shared calendar the 'item' is residing in? Thanks again,
  8. zunni

    Referencing Current Outlook Appointment

    Hi When I set an appointment for another user, which I have editors access to, sometimes (but not everytime) I have to set future followup appointments (eg. 3 months later, 6 months later, etc). In my mind the best and quickest way is to create a button, attach a macro to reference the...
  9. zunni

    VBA to initiate download file without security message from appearing

    Hi I am writing an excel vba module to download a file from a https webpage automatically. At the moment, a user has to log in to a website and navigate to the specified page and click on the icon, the dialogue box to open or save the file comes up - which is fine. I have written a vba...
See more

Part and Inventory Search

Back
Top