Results 1 to 4 of 4

Thread: Issue with Chase downloading a years transactions
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular joh1135's Avatar
    Join Date
    Mar 2003
    Location
    Texas
    Posts
    156
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Cool Issue with Chase downloading a years transactions

    I have been trying to figure out why Chase transactions do not down load properly into Excel. After a couple of hours I downloaded the document into word with using past with document formatting and it showed me that Chase places a question mark in front of the number if the number is negative (?$1,000.00).

    So now I need some help with VBA to remove the ? and replace it with a - in column E. I tried to use Record a macro but I could get it to do both actions. I have 300 transactions and i would hate to have to do it manually.

    Any help will be greatly appreciated

    Thank you
    Dave Johnson

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,805
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Issue with Chase downloading a years transactions

    maybe:
    Find: ~?
    Replace: -
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    Board Regular joh1135's Avatar
    Join Date
    Mar 2003
    Location
    Texas
    Posts
    156
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Issue with Chase downloading a years transactions

    I will give it a try - Thanks
    Dave Johnson

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,805
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Issue with Chase downloading a years transactions

    Welcome
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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