Macro Importing Selected Text Files into Temp Folder and then Separate Worksheet Pulling Selected Areas

maninblack

New Member
Joined
Jul 10, 2012
Messages
1
Hello, I am wondering on how to prepare a Macro code in Excel 2007 to initiate the movement of text files into a temp folder or separate sheet in the excel document and have data recovered onto the main page. So Sheet1 will hold selected data from the files that have been entered on sheet2. Sheet2 has the directory of the files in cell E2 (C:/data/2012/), and would like to pull data from text files entered in cells C6 (run001) to C26 (run020). And the selected location of the data that I want to be pulled from these text files are on line 26, starting on space 15 and is 10 characters long. I would like to also produce a macro button for this as well on Sheet2.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,329
Members
414,055
Latest member
mcarduner

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
Top