1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Macro help for computer illiterate

Discussion in 'Software Development' started by LOSERLOSER, Apr 29, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. LOSERLOSER

    LOSERLOSER Thread Starter

    Joined:
    Apr 29, 2010
    Messages:
    1
    Hello,
    i am copying and pasting data from multiple data files into one master sheet. I tried to write a little macro but it was only specific to the data file that was currently open.

    How do i make my macro work so it will copy and paste data from any data file open, into the the master sheet

    pls help it would save me days!!


    the rest of the code isn't an issue i just want it to work for the data file which is currently open

    many thanks
     
  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Hi, welcome to the forum.
    I imagine you are working with Excel but your question isn't really specific enough.
    What kind data and in which format is it offered are you trying to read / import?
    Try the following link: http://www.cpearson.com/Excel/Topic.aspx

    Under the "I" you will find some tips and ideas for importing files, I hope you can use these
    If you are still stuck just call for help
     
  3. Squashman

    Squashman Trusted Advisor

    Joined:
    Apr 4, 2003
    Messages:
    19,786
    I asked a very similar question a few years ago in the Business Applications forum. I needed to merge several excel files together. What they had come up with was to put all the excel files into one directory and run the macro. It then merged all of them onto one sheet.

    I will see if I can find that thread for you.

    Found it.
    http://forums.techguy.org/business-applications/524961-concatenate-excel-files.html
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Okay, I still don't know how and what and where the files are.
    Can't you use this old post to help you on the way?
     
  5. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    And.... how's the litteracy now.
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Macro help computer
  1. charlzguitarz
    Replies:
    4
    Views:
    951
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/920077

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice