+ Reply to Thread
Results 1 to 3 of 3

VBA Data Import to existing sheet from .csv

  1. #1
    Valued Forum Contributor Miraun's Avatar
    Join Date
    04-03-2009
    Location
    New England
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    554

    VBA Data Import to existing sheet from .csv

    Hey Everyone;

    Very basic question here... unfortunately, I'm not familiar enough with VBA prompts or user defined functions to be able to write this myself, and really haven't found too many in depth guides.

    I have a worksheet named "Data"
    I want a button that will import data from a .csv file into the "Data" worksheet.
    If there is info already in "Data", delete it (easy enough)
    I want the user to select the file in a browser format to find .csv file to import.

    I'm sure it's simple, but I haven't been able to find an example.


    Editted to add: I'm looking to copy all data from the .csv... no further differentiation within it.
    Last edited by Miraun; 06-22-2011 at 09:23 AM.
    Going for Guru! Click the Star to the bottom left of this post if I helped!

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: VBA Data Import to existing sheet from .csv

    Miraun,

    Something like this?
    Please Login or Register  to view this content.


    Hope that helps,
    ~tigeravatar

  3. #3
    Valued Forum Contributor Miraun's Avatar
    Join Date
    04-03-2009
    Location
    New England
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    554

    Re: VBA Data Import to existing sheet from .csv

    Perfect, Thanks Tiger!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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