Results 1 to 8 of 8

Simple Import Data From Another WorkBook

Threaded View

somebody113 Simple Import Data From... 04-28-2011, 03:39 PM
somebody113 Re: Simple Import Data From... 04-28-2011, 03:44 PM
JBeaucaire Re: Simple Import Data From... 04-28-2011, 10:14 PM
somebody113 Re: Simple Import Data From... 04-29-2011, 11:37 AM
JBeaucaire Re: Simple Import Data From... 04-29-2011, 02:52 PM
somebody113 Re: Simple Import Data From... 05-01-2011, 05:25 PM
JBeaucaire Re: Simple Import Data From... 05-04-2011, 07:08 AM
somebody113 Re: Simple Import Data From... 07-07-2011, 04:29 PM
  1. #1
    Registered User
    Join Date
    04-28-2011
    Location
    chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    25

    Simple Import Data From Another WorkBook

    Okay, this is super simple, I can’t seem to find the EXACT answer I’m looking for..
    All I need is a simple macro to import data from another workbook.

    I have a Master File called “Master.xlsx”

    and

    .csv file called “Extract.csv” that refreshes every hour. I have a imacro setup to refresh that

    I need a macro that pulls from columns A-G on “Extract.csv” and pastes the info a sheet inside of “Master.xlsx” called “PDump”

    So…

    Extract.xlsx
    Sheet - Sheet1
    Columns A-G

    TO

    Master
    Sheet - Pdump
    Paste Starting at cell N3

    I’d like to run this macro from “master” and its fine if it constantly overwrites the data

    This is the closest thing I could find to what I'm looking for, but it does not work!

    ChDir _
    "S:\Operations\Oper\Analysis\KPI\FY'04 KPI & Month End Spreadsheets\Monarch\SKU backup"
    Workbooks.Open Filename:= _
    "S:\Operations\Oper\Analysis\KPI\FY'04 KPI & Month End Spreadsheets\Monarch\SKU backup\rwp381.xls"
    Range("A2:L15").Select
    Selection.Copy
    Windows("Model.xls").Activate
    Sheets("LinesOnly").Select
    Range("A2").Select
    ActiveSheet.Paste
    End Sub
    Last edited by somebody113; 04-29-2011 at 11:36 AM.

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