Search:

Type: Posts; User: wornhall; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Re: How can I fetch a web site in VBA without using IE? I now use IE & MSXML... to do fetches.

    Thank you very much for the information. Now in process of installing.
  2. Re: Outlook - UserForm open in center of New Email Window

    Word's document control yields the following when running through the menu ribbon "Layout, Orientation, Portrait":


    Sub Macro3()
    '
    ' Macro3 Macro
    '
    '
    Selection.WholeStory
    With...
  3. Replies
    3
    Views
    660

    Re: Weighted Measure - Different Criterias

    That appears to be a problem that fits the exact profile of Excel's "SOLVER" feature. You will find all you need to know in the help library.

    Hope this does the trick for you.
  4. How can I fetch a web site in VBA without using IE? I now use IE & MSXML... to do fetches.

    Chase Credit Card issued this announcement:

    Please update your browser.We'll stop supporting Internet Explorer® soon. Choosing another browser will also help protect your accounts and provide a...
  5. Replies
    1
    Views
    205

    Re: Not Working VBA to log into Website

    The site could not be reached. The result is:
    This site can’t be reachedigate.inside.ups.com’s server IP address could not be found.


    Try running Windows Network Diagnostics.

    ...
  6. Replies
    40
    Views
    1,784

    Re: I need help Editing this Macro

    Sorry, the above post was to have been for another query.
  7. Re: Copy the data from Master data to Multiple sheets based on the condition for Sep 1 to Sep 30.

    That might be a pivot table solution taking into consideration that formulas of "=month(...)' and "=day(...)" yields the number value of each . By entering those formulas in each of two adjacent...
  8. Re: Spremely Frustrated with a 'runtime error: "-2147417848 (80010108)" Method "Value of "Range" Failed'

    change "Dim NextRow As String" to "Dim NextRow As Long
    Integer has a max of roughly +32,000, at which point you get an error.
    Depending on your version of the Excel editor, integer may...
  9. Re: Using MSXML 6.0 having difficulty signing on w/ uid & pwd

    Apparently, my description was not clear enough. As my code showed and explanation state that the process uses password and user-id, and the process is interrupted with a challenge screen. That is...
  10. Replies
    4
    Views
    115

    Re: Save file with date as nae file

    Another suggestion: save the file in YYYY.mm.dd.mm.ss and you will not be having collisions. Also, the name can be sorted or listed in chronological order within a main-name.
  11. Using MSXML 6.0 having difficulty signing on w/ uid & pwd

    Hi, all,

    The following code is used to access my credit card company to scrape the balance. I already have a working IE edition, but it is slow and awkward. The project is to access my banks,...
  12. Re: Conflict between innertext date time and excel date time output

    Excel is converting the date string into an excel date, which is a serial number with a fraction. To keep the input date append a single quote to the front of the string:
    dim opDate as String...
  13. Re: General question about auto- adding first row?

    Try this:

    Range("A3").PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
    xlNone, SkipBlanks:=False, Transpose:=False
    Rows("3:3").Insert Shift:=xlDown ' I...
  14. Replies
    5
    Views
    327

    Re: error handeling

    It sounds as if you are going asynchronously and running into a timing problem. Do you have the following code?
    XMLpage.Open "GET", URL, True
    or is there no second argument, in which case you are...
  15. Re: Why scraping doesn't work the same on two different PC?

    It could be that the version of your handler is different:
    Dim XMLpage As MSXML2.DOMDocument is not sensitive to the versions, but this is -
    Dim XMLpage As MSXML2.DOMDocument60

    The speed of your...
  16. Re: Web Scraping with MSXML for Etrade values - close but not there.

    Yet another question: when in MSXML2.XMLHTTP60, is there a method/procedure to show the page in a browser window?
  17. Re: Web Scraping with MSXML for Etrade values - close but not there.

    Here is another mystery: I am attempting to scrape my credit card balance from Capital One's web page. I am not succeeding. Is it my VBA coding or is it inherent to the site? I need help and advice....
  18. Web Scraping with MSXML for Etrade values - close but not there.

    The following code is my attempt to glean my data from my account at Etrade. The site is meant to confuse, but the code sample has copies of the relevant divisions and id's. Any help or advice will...
  19. Re: Finding or extracting documentation for VBA procedures such as MSXML

    Thanks anyhow.
  20. Re: Finding or extracting documentation for VBA procedures such as MSXML

    Thank you for the fine response. In Excel, the help function refers directly to MSDN on-line which is not very helpful for an addin. What I think is needed is a breakout of the referenced dll, namely...
  21. Finding or extracting documentation for VBA procedures such as MSXML

    How does one get or extract procedural definition and associated parameters from a "project" like MSXML 6.0? I am doing some basic web scraping but am only mirroring VBA snippets, rather than really...
  22. Re: What is "#" doing/saying when it leads a line of code?

    Thank you both for the excellent replies. This answers my question(s).

    Warren Hall
  23. What is "#" doing/saying when it leads a line of code?

    In this code, for example, what is the effect of the "#" sign?

    Public Function Exists(Key As Variant) As Boolean
    #If Mac Or Not UseScriptingDictionaryIfAvailable Then
    Exists = Not...
  24. Re: VBA Autodialer from active cell via Ctrl-J on com-3 standard modem

    Taking a new approach, we now have success with:


    Sub Speedial()' Ctrl-j Warren Hall 11/21/2016, assume you have name then telephone
    ' on the same row, and telephone is the active cell.
    ' ...
  25. Replies
    8
    Views
    261

    Re: Add cell borders based on real-life date

    You don't give the file's location, only the name of the repository. At this point, we really need to see the file under question.

    In the meantime it will be time well spent to look into...
Results 1 to 25 of 59
Page 1 of 3 1 2 3