Search results for query: *

Think I may have cracked it - just seen something in another piece of code that may help, looks like a re-write of code

Thanks for the reply - does any vb.net expert know the answer to this problem

SET HTMDLDOC = objie. Only works in VB6 not VB2008

Just changed from VB6 to VB2008. After some investigation, I have found that IE8, has changed regarding GetElementById and GetElementsByName. My old VB6 code used to bind to certain places on a webpage, using this code HTMLDOC = objIE.document.getElementById("mainframe") But IE8 is case...

Thanks seem to work at the moment - just piling through the rest of the code. Trying to change all the other errors

Just converted from VB6 to VB2008 On running my old code, I get the following error. Conversion from type '_ComObject' to type 'String' is not valid This is the code that is throwing the error. trans = Trim(MyArea) I have declared trans as a string and MyArea as object. MyArea is set to...

Finally Cracked it... I used the following code Declare Sub Wait(objIE As Object) Sub Main() Dim objIE As Object, i As Integer Set objIE = CreateObject("InternetExplorer.Application") With objIE .Visible = True .Navigate "http://www.google.com" End...

1. Declare Sub Wait(objIE As Object) 2. 3. Sub Main() 4. Dim objIE As Object 5. dim objApp as object 6. 7. Set objIE = CreateObject"InternetExplorer.Application") 8. With objIE 9. .Visible = True 10. .Navigate "http://www.google.com" 11. End With 12. 13. 'Call...

I get the error on line 19 when I step through the code.

Thats strange, I have run WinblowsME's code and I get an error saying 'Object set to nothing'

I was using the code for Google as a test web site. Just to find the text box and enter some text, if I could get this to work I was going to adapt my code to work with an internal website

WinblowsME - I have tried the code that you posted above, but it returns an error with ref to the following code: objIE.Document.Forms("f").all.item("q").value = "TEST" It returns Object value is set to nothing

Thankyou, that's been a great help

Thanks for the replies, they are most helpful. Is objIE.Document.Forms("f").all.item("q").value = "TEST" Looking for certain things on the webpage.

Hi, I am trying to write a macro using Attachmate Extra 7.1 to copy from an Extra screen, find the correct opened Internet Explorer window then paste the contents into a blank box on Internet Explorer. I can get the macro to open a new IE window, navigate to a certaqin website(I used Google)...

Hi sedj, Here is my code, I have set my code up as per the tutorial that you mentioned, but the only way to execute the java file is by using the following on a command line:- java -cp pg73jdbc3.jar:. DbConnect Is there anyway I get the java file to run as a standalone. Java code see below...

I need to connect to a secure postgresql database, i have the latest drivers downloaded from the postgresql website. My main question is:- Is there a way of importing the jar file into the java class. So method in another java class can then call the DbConnect class file. At present the only...

Not sure if this is the right forum, I need to connect to my sql database using java. I cannot seem to get the jdbc drivers to load. Does anybody have any ideas, here is the code so far. // Establish a connection to an Interbase database using JDBC. import java.sql.*; class DbConnect {...

Thanks for that it works a treat, just to work how to copy the new data from sheet 5 to sheet 1. Jimwal0367

Hi, I have found this code in another posting Sub Find_Matches() With Sheets(1) For Each r In .UsedRange With r If .Value <> Sheets(5).Cells(.Row, .Column).Value Then .Font.Color = vbRed Sheets(5).Cells(.Row, .Column).Font.Color = vbRed Else...