+ Reply to Thread
Results 1 to 4 of 4

Creating .txt file Issues

  1. #1
    Registered User
    Join Date
    09-12-2014
    Location
    Pennsylvania
    MS-Off Ver
    2010
    Posts
    16

    Creating .txt file Issues

    Hi All,

    Right now, we receive an excel spreadsheet with a list of usernames in a column. We then create a notepad file which contains the text "NASClusterNewHome H7, UserName", where the UserName is copied/pasted from excel to notepad manually. I am attempting to automate this process by using this code:

    Please Login or Register  to view this content.
    This does create a text file which looks exactly as it should.

    However, for QA, I took a notepad file which had previously been completed manually and compared the text using the 'Exact' formula from that file to the text in my newly created file (from same spreadsheet). Out of 186 users, 17 came back saying "False". I have no idea why, they look exactly the same to me, but it is very important they are exact.

    Any help would be much appreciated and any info I can provide I will be happy to, thanks.

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Creating .txt file Issues

    Open both files up in word and turn on the Control Characters, does anything look different between them?

    Chances are its a control character in the field or some extra spaces etc.

    Try changing:

    Please Login or Register  to view this content.
    to

    Please Login or Register  to view this content.
    then compare again.
    Last edited by pjwhitfield; 01-21-2016 at 03:23 PM.
    If someone has helped you then please add to their Reputation

  3. #3
    Registered User
    Join Date
    09-12-2014
    Location
    Pennsylvania
    MS-Off Ver
    2010
    Posts
    16

    Re: Creating .txt file Issues

    Looks the same to me. I'm just confused to why it was 17 out of 186, and they all happen to be in a row (IDs 322 to 338)

  4. #4
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Creating .txt file Issues

    If Im reading you correctly the original process for this is to copy and paste each row manually?

    Thats your answer, the code youve supplied will do exactly as youve coded it to, theres nothing in there to make it do 17 different results. Human nature however says that manually mistakes will be made whether its dragging a touch too far or maybe missing a space here and there. If I was manually copying and pasting a load, Id make mistakes too.

    If you really want to find it though then give this a go, its rough but will highlight the ASCII values of any differences.
    Attached Files Attached Files

+ 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. issues creating a graph
    By Sezra in forum Excel General
    Replies: 6
    Last Post: 04-06-2015, 12:48 PM
  2. [SOLVED] Issues creating additional columns
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2014, 12:22 AM
  3. [SOLVED] Issues with vba macro while creating csv files
    By HelpForxls in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2013, 02:19 AM
  4. Replies: 3
    Last Post: 05-03-2012, 10:56 AM
  5. issues creating a newsletter template
    By dadevil in forum Word Formatting & General
    Replies: 1
    Last Post: 10-15-2010, 02:40 AM
  6. [SOLVED] Suggestions for creating Issues Log using Excel?
    By Deb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2005, 12:06 PM
  7. Menu Issues when creating an Add-in
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2005, 09:06 AM

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