Results 1 to 17 of 17

Reading line by line data from Text file

Threaded View

wyldencl Reading line by line data... 05-13-2015, 11:52 PM
Leith Ross Re: Reading line by line data... 05-14-2015, 12:29 AM
wyldencl Re: Reading line by line data... 05-14-2015, 03:11 AM
Leith Ross Re: Reading line by line data... 05-14-2015, 04:16 PM
wyldencl Re: Reading line by line data... 05-14-2015, 11:14 PM
wyldencl Re: Reading line by line data... 05-14-2015, 11:46 PM
Leith Ross Re: Reading line by line data... 05-15-2015, 12:36 AM
wyldencl Re: Reading line by line data... 05-16-2015, 02:00 AM
Leith Ross Re: Reading line by line data... 05-16-2015, 02:48 PM
wyldencl Re: Reading line by line data... 05-16-2015, 11:40 PM
wyldencl Re: Reading line by line data... 05-17-2015, 08:03 AM
Leith Ross Re: Reading line by line data... 05-17-2015, 07:36 PM
wyldencl Re: Reading line by line data... 05-18-2015, 11:43 AM
wyldencl Re: Reading line by line data... 05-18-2015, 11:43 AM
Leith Ross Re: Reading line by line data... 05-18-2015, 12:50 PM
wyldencl Re: Reading line by line data... 05-18-2015, 10:03 PM
Leith Ross Re: Reading line by line data... 05-18-2015, 10:09 PM
  1. #1
    Registered User
    Join Date
    04-04-2015
    Location
    Newcastle, UK
    MS-Off Ver
    2014
    Posts
    15

    Reading line by line data from Text file

    Dear all,

    Thank you very much for having this forums and help.

    I am trying to create a spreadsheet which starts with a user form of which i can input a number into a textbox. On clicking a button in the user form, this number will correspond to a certain row number within a separate text file, select and copy that entire row and print it on excel.

    I am very new to VBA and would appreciate if someone could give me a hand with this, i have attached the excel file for reference. thanks in advance!



    My current code (which doesn't work) to copy off the spreadsheet is something like this:
    Private Sub CommandButton1_Click()
    
    
    Sheets("Userform").Range("A3") = TextBox1.Value
    
    Dim r As Integer
    
    r = Range("A1").Value
    
    
    Cells(r, 1).EntireRow.Select
    'Selection.Copy
    'Cells(1, 1).Select
    'ActiveSheet.Paste
    'Application.CutCopyMode = False
    
    
    End Sub
    Attached Files Attached Files
    Last edited by wyldencl; 05-14-2015 at 03:10 AM. Reason: Added Code tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Reading array of data line by line (stock tick data)
    By wyldencl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2015, 03:12 PM
  2. Replies: 12
    Last Post: 01-14-2014, 01:56 PM
  3. STart reading text file at line 2
    By Striker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2006, 08:35 AM
  4. Reading a text file line by line-How do I open the text file with VBA
    By stressman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2005, 12:29 AM
  5. [SOLVED] Reading a text file line by line
    By Foss in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2005, 12:06 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