Consulting

Results 1 to 2 of 2

Thread: Excel VBA to import txt file AND automatically insert rows

  1. 10-10-2017, 12:14 PM #1
    Techgirl7
    Techgirl7 is offline
    VBAX Regular
    Joined
    Oct 2016
    Posts
    13
    Location

    Excel VBA to import txt file AND automatically insert rows

    I have a form that I need to populate with a text file. I need to be able to import this, but the form only has room for 10-15 rows of new data. There is info above and below that area I will be importing to. So if I have 20 rows in the text file, it will need to read the text file, count the rows, (20), then go to Cell A25, make sure there are 20 blank rows, then import the data.

    Is this possible?
    Techgirl7
    Last edited by mdmackillop; 10-10-2017 at 12:54 PM. Reason: Typo corrected
    Reply With Quote Reply With Quote
  2. 10-16-2017, 05:36 AM #2
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base     VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Is your data in one column or multiple?
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules