• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by crazy8

  1. C

    Exporting from Excel via VBA - too much data?

    YES!!! Many thanks - and warm regards. Paul
  2. C

    Exporting from Excel via VBA - too much data?

    As you can see from my code (below) I am formatting data from a spreadsheet and putting the results into a .txt file - that will later be FTP'd to the mainframe. There are 171,148 rows. If only the first 30,000 rows are run (by putting 30,000 in the range (O2) it works fine. It will not...
  3. C

    If then Else - formatting

    Yes - it is working. Apparently your comment was needed for the code to believe it true. Thanks - I am already breathing much easier. I can't return the favor with VBA help - but if are interested in learning to play foosball let me know!!! Best, best regards, Paul
  4. C

    If then Else - formatting

    "I want 01, -1, 00. What is wrong?" OR...' 1', -1, ' 0' would be OK.
  5. C

    If then Else - formatting

    Thank you - this is so very helpful - it worked! Also,I understand your comment on field-size and have adjusted accordingly. Follow-up: I tried using the same logic for another situation with less satisfactory results. Though this logic seems made for this new situation: There are nine...
  6. C

    If then Else - formatting

    Hi. I am very, very new to this - please help! I am using this code to help create a fixed-length record I can send to the mainframe from an Excel spreadsheet. In one column, some results are positive, are negative. I am formatting the positive value like this: MyStr = MyStr &...
See more
Back
Top