Recent content by zunni

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...

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?

Arghh! Such a simple error

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"...

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...

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"...

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,

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...

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...