Search results

  1. M

    Find function in VBA acts strangely (excel)

    Hi, I am trying to search a word in the activesheet using the following code. VBA is behaving strangely, in that, when I run the macro it is not able to find the word, even though the word is there in the worksheet. However, when I step through the macro (using F8) the Find function is able to...
  2. M

    Way to get innertext of all childnodes of a node?

    Hi, Is there a way to get innerText from all childnodes of a node quickly? I am using VBA. A web page has a node "H1" which in turn has several childnodes, some of them are "p" and some are "STRONG". I need to get the text in these nodes. I tried to use getelementsbytagname and getattribute...
  3. M

    CDO email error - traport failed to connect the server

    Hi, Please see the following code I am trying to use to send a simple email. I am getting the following error message: Run-time error '-2147220973 (80040213)' The transport failed to connect the server. What could be the problem? Dim objEmail, toemail, schema schema =...
Top Bottom