copy files to workbook

  1. H

    Auto Excel file copy and crete files with given names

    Hi Team, I'm looking for one macro code in order to generate the excel files and give the standard excel file names. Example: I have one master file in the given path like C:\Temp\ and input box required to assign the number of file option. If I declare 10 files then my master file should get...
  2. A

    Impossible Copying and inserting Macro....

    Hi Guys... I recieve a daily report that gets filtered onto a spreadsheet. What I would like to do is be able to set up a macro that would take this daily filtered information and insert it into a master sheet that holds 6-8 weeks worth of work. The issue I am having at the moment is that I...
  3. A

    Help! Having Issue with Copying of information with a Macro...

    Hi Guys... I really need some help... I receive a daily report as a txt file. Then I use: ChDir "C:\Users\Mon&Ant\Desktop" Workbooks.OpenText Filename:="C:\Users\Mon&Ant\Desktop\0.txt", Origin:= _ xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _ xlDoubleQuote...
  4. M

    User Selected Range Across Workbooks

    Still kinda new at this. I am trying to write a sub that will allow the user to select a range and a collection of files. That range will be pulled from each of the files selected and then pasted to a new workbook (same sheet). I will also be doing the same thing but instead to one sheet give...

Some videos you may like

This Week's Hot Topics

Top