import multiple files

  1. P

    Import several text files to separate worksheets of the same workbook

    Hi, First a big thanks to this forum for my learning in VBA here. I have seven different text files named DVE, DVB, FAE, FAF, FAG, FAM, FAB. I have a macro named D_Import(), when I run this macro it prompts me for a text file, and I select DVE.txt from it's location, then it imports the text...
  2. R

    Please Help- Importing multiple files

    I have multiple files that I want to import into the same spreadsheet. The files are extension .asc but import as text, tab delimited, two columns wide. I want to then perform a -log() function on the second column. Then I want to plot the first column and the -log result. I need to import...
  3. S

    Need Help with this Macro

    Need to import multiple text files in one shot. (Excel only allows 1 at a time) Most file names are similar just numbered. ex. JoeBlowfile 1.txt, JoeBlowfile 2.txt, JoeBlowfile 3.txt, etc...... All text files have 30 lines of text For example: JoeBlowfile 1.txt will start at A1 and end at...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top