+ Reply to Thread
Results 1 to 2 of 2

Edit data in textfile by Random Access

  1. #1
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Karlstad, Sweden
    MS-Off Ver
    Excel 2016
    Posts
    232

    Edit data in textfile by Random Access

    I have a textfile TESTFILE.txt looking like:

    A 10
    B 20
    C 30
    D 40
    E 50

    I am trying to increase 'D' by one to 41 by attached code. My result is:

    A 10
    B 20
    C 40
    D 40
    E 50

    What am I doing wrong?

    HTML Code: 

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Edit data in textfile by Random Access

    random access files are not text files, but binary files
    If solved remember to mark Thread as solved

+ 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. Hyperlink to edit the data from the access database
    By sagar.rajula in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2013, 02:00 PM
  2. Replies: 0
    Last Post: 10-19-2012, 09:14 AM
  3. Excel 2010 userform to access and edit the data in MS ACCESS DB tables
    By anand_y59 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2012, 07:46 AM
  4. Pick textfile in combobox and read last entry in textfile to sheet!
    By Petter120 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2012, 07:11 AM
  5. [SOLVED] Logging data using the same textfile over and over again
    By Silencer116 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2006, 07:15 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