importing files

  1. M

    Importing multiple files into one tab instead of separate tabs

    Hi I've got some code that imports multiple files into one single file. However, each file that is imported is put into a separate tab in the single file. I would prefer to have append the data from the multiple files, instead of having it on separate tabs. Does anyone know how to modify...
  2. K

    Importing CSV Files from a folder

    Hi Everyone, I am trying to create a macro that will allow me to selected multiple CSV files in a folder to import into an EXCEL spreadsheet. The CSV files are already in an EXCEL worksheet after being downloaded from another database. There are four columns of data in each file that I want...
  3. V

    Avoiding Data Duplication using the Workbook Data Connections

    Hello to everyone, I wrote a code, which allows me to automatically import the Text (.txt) files (that are located in the same folder) on different worksheets (according to a certain criteria). But I have a problem with the duplication of data: I would like to import one text file only...
  4. andrewb90

    importing CSV data from files with changing names

    I am looking for a way to import CSV data from different files into my existing spreadsheet and fill it into my cells. For example one file will be labeled Z005_13 and cells B11:C35 will need to be copied from that file. Now everyday the file name will change. the two digits at the end will...
  5. R

    macro to select file for import.

    Hello Excel Experts. I have sheet4 of my workbook designated as the destination for imported .CSV files. The files data is pre-formated to fit into columns A & G. The rest of the sheets in the workbook read and pull the data from there. I have no trouble manually selecting the needed file and...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top