Search results for query: *

Is there a better way to tell the browser to wait until a page has loaded to continue? I've tried while ieobj.busy doevents wend do while ieobj.busy loop and even variable1 = ieobj.document.all.getelementsbytagname("td").length while ieobj.document.all.getelementsbytagname("td").length <...

Well the title says it all, how would i get the url of the link i just clicked? Dim ObjForTesting As Object Dim Link As Object Dim ElementCol As Object Set ObjForTesting = CreateObject("InternetExplorer.Application") With ObjForTesting .Visible = True .navigate...

Anyone home? I guess everyone's on vacation.

Well the title says it all, how would i get the url of the link i just clicked? Dim ObjForTesting As Object Dim Link As Object Dim ElementCol As Object Set ObjForTesting = CreateObject("InternetExplorer.Application") With ObjForTesting .Visible = True .navigate...

How can I stop Dialog Boxes / Error Messages from opening in my OLE object "IBMReflection"? here is the code: Private Sub cmdQuery_Click() Dim hostpassword As String Dim Session As Object Const SessionCon = "149.83.123.3" Set Session = CreateObject("ReflectionIBM.Application") With Session...

MsgBox Clipboard.GetText 'or Debug.Print Clipboard.GetText Text2 = Clipboard.GetText when i run the code, It gives off error Run-time error "424" Object Required.

ps. Clipboard was declared as object.

Text2.Text = Clipboard.GetText gives off error : Object Variable or with blocl variable not set.

Thanks for the response. Yes it copies text into the clipboard, because after the code stops, if i do Ctrl + V anywhere i get the text mentioned above.

I am having trouble pasting data from my OLE object below. The code logs in to an application, goes into a certain screen and then from a certain position to another it copies text, which is not in any format whatsoever. here is an example: SPECIAL BROKER PULL 0 0...

Sorry for not making my post clear. Ok, - Are you saving the value? Yes, I am saving it to String LInum. - Are you manipulating the value? No. - Are you loading or updating information in a database? No. The Input from the user is used to query a website. - Are you closing a form or opening a...

Thanks for the reply. I've tried the snippet above but it gives off error Object Required, As for Calling the validation Text box code, well i dont know how to that. what im looking for is right after the 7th key is pressed BtnOk would be called.

I'd like to have the code press enter after a certain amount of characters have been entered in a textbox. This is what i have but it doesn't work. Private Sub Text0_KeyDown(Keycode As Integer, shift As Integer) 'Dim str As String Dim str As Object Set str = Text0 'str = "1234567" If...

Well, it turns out IE7 didnt like me naming my Constants Username and username1 because after i changed username1 to USRNM, everything was working as it should, i am curious to know why it didn't work before i changed the name. hopefully someone answers~!

Sorry about that, I should have been more specific. The line that is giving me trouble is username.Value = str_usr Password.Value = str_pw LogInBtn.Click Run-Time Error "91" Object variable or with block variable not set. HTH

I'd really appreciate a reply or at least redirect me to a helpful post.

The Code below was made in access 2003 and tested on IE6 and it worked fine, but after testing it on ie7 it gives off errors such as Object variable not defined, or Subscript out of range Sub Kick_Off_Log_In() Const str_usr = "qcc04" Const str_pw = "qc" Dim username As...

It Works! But can you explain how it works? I'd like to do the same for Workcenter B too.

I'll give it a try and post my results.

So far i've come up with Private Sub Command0_Click() Dim Linum As String Linum = "LI-2156379" Call Kick_Off_Log_In Set IeFetch = CreateObject("InternetExplorer.Application") IeFetch.navigate "http://10.0.239.234/one/ASP/TrackingSheet.asp?JobID=" & Linum & "&Type=Job" While IeFetch.Busy...