+ Reply to Thread
Results 1 to 2 of 2

VBA for Importing data

Hybrid View

  1. #1
    Registered User
    Join Date
    03-23-2009
    Location
    los angeles
    MS-Off Ver
    Excel 2003
    Posts
    25

    VBA for Importing data

    I need some help writing a VBA code for importing data from an external file.
    Can you user enter the location of the file by browsing?
    While doing it manually, I import the data and format it as text in the import dialog box.

  2. #2
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845

    Re: VBA for Importing data

    Hi,

    Try using the macro recorder and record your steps.
    When done stop the recorder.
    You can now view what you just recorded.
    Hope this gets you stared.
    Charles

    There are other ways to do this, this is but 1 !
    Be Sure you thank those who helped.
    IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.

+ 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