+ Reply to Thread
Results 1 to 3 of 3

Web History Prevents Macro From Running More than One Time

  1. #1
    Forum Contributor
    Join Date
    02-12-2018
    Location
    TX
    MS-Off Ver
    MS Office 2019
    Posts
    305

    Web History Prevents Macro From Running More than One Time

    I'm phrasing this question the best way i know how. After many weeks of trying, I finally have a working macro. I can run it, it will auto-log me into my bank account. If I try to run it a second time, I get an error message. If I clear my browsing history and close/re-open the file, it works again. What the actual hell is going on with this thing and how can I correct it? Would greatly appreciate the help. Tks.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Web History Prevents Macro From Running More than One Time

    Hello Jim,

    What your describing is a "cookie". A cookie is a small text file saved to the user's hard drive until it expires or the user deletes it.

    What is in a Cookie
    1. Name and data: data is limited by the browser, usually less than 4 KB; a server can define multiple cookies with different names, but browsers limit the number of cookies per server to around 50.
    2. Domain for this cookie: server, port (optional), URL prefix (optional). The cookie is only included in requests matching its domain.
    3. Expiration date: browser can delete old cookies.

    The first time your browser connects with a server no cookies are created. When the server responds to the browser's request, one or more cookies are sent back. In the future whenever the browser connects with the same server, it includes a Cookie which the server can use to connect related requests.

    Cookies are used by the server to implement Sessions. A Session is a pool of data related to an active connection. Typically, the cookie contains an identifier for the session. Most servers check for a session cookie at the start of each request. If the cookie exists then use it to find the session data. If not create a new session cookie. A session id allows the server to access your data without making any personal data like your user name or password public.

    You may simply need to change your browser settings to clear cookies when it closes.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    02-12-2018
    Location
    TX
    MS-Off Ver
    MS Office 2019
    Posts
    305

    Re: Web History Prevents Macro From Running More than One Time

    Hello. Thank you for the reply. I appreciate the help. I tried what you said, and still no luck. The URL keeps changing on me. From https://chaseonline.chase.com/ (the one that works) to https://www.chase.com (the one that prompts errors). I also tried changing "Dim IE As InternetExplorer" to "Dim IE As InternetExplorerMedium" because I read somewhere that that might help. Something having to do with this being a secure site and it was redirecting me to a parent URL. I've been looking like crazy for a solution but it's hard to even figure out the correct way to phrase the question to search for one. Would greatly appreciate any other possible solutions. Tks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Adding ElseIf To Code Prevents Else From Running
    By swordswinger710 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-11-2016, 10:06 AM
  2. How to keep a running history of sizes
    By Sparkplug90 in forum Access Tables & Databases
    Replies: 0
    Last Post: 10-10-2013, 10:32 PM
  3. aProtect Sheet prevents Text Wrap and stops vba code running
    By beaujolais44 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2013, 07:12 AM
  4. [SOLVED] Delete Key Prevents Macros from Running
    By bobmaucher in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2013, 07:39 PM
  5. What prevents macros from running when spreadsheet is opened?
    By harleypop in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2009, 06:36 PM
  6. Trending Data:a running history.
    By Endorphin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2006, 02:16 PM
  7. Running History of values?
    By mr2mike in forum Excel General
    Replies: 7
    Last Post: 11-24-2006, 09:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1