open all files

Dears, I am looking for macro command to open all worksheets in a specified folder and run certain commands save and close file.

I'm trying to save first column of the each sheet as a separate csv file who's name depends on name of each sheet in work book. Once i'm done saving those sheets i want to open those files one by one to align the data in them. below is my code can you please assist how can i open files from same...

I am using Excel 2010 on Windows 7 Professional. I have multiple excel workbooks (.xlsx) in a folder and i want to copy the value (not formula) from cell $C$5 and $D$7 into my Admin workbook that the VBA will be running in. I would like the value from each excel workbook to be placed in one...

Hello everyone, This is my code. This code will grab all the files from a source folder, open each workbook, print all worksheets, and then close it. repeat. However, I am getting an error saying "Run Time Error 1004. Method "PrintOut" of object_Worksheet. failed. I think it is because there...

is it possible to open all files in a folder, have cells bj16:br16 copied and pasted to a new workbook, closed out and repeated through all workbooks in the folder? also if this is used with a macro button and I press it again after another workbook is added could I have it only add the...

Hi, I am looking for a way to loop a macro for the code below so that I can open an undetermined number of files, copy the information and close the files. The code below opens the first file selected and copies all the data, then the other files are opened and only copy the data and not the...

Hello All, I had an automated process that use to take all extracts from a system in ".XLS" format (A lot of quotes); however, the system I got them uploaded to is no longer accepting ".XLS" format, it only accepts ".XLSX" Format, the problem here is that IT does not want and will not invest...

Hello everybody. I have been going crazy over this and although there are multiple threads regarding this problem none of them have helped so far. The Problem: There is a destination sheet that collects data from multiple Source sheets (12 atm, but may become more). The links have mostly been...

Hi Excel gurus, I've been pulling my hair out trying to do a potentially easy code for some experienced people, if anyone can help! I'm looking to : 1) Open multiple file names from my F drive. Details - With the file name of "issue303661.txt" the following file would typically be consectuive...

Hi I found some code on Mr Excel where it will go into sub folders and get the names of all the files within these folders (see below) but i wanted to know if there was anyway i could amend this so it opens the files up in name or date order? Private Sub recurseSubFolders(ByRef Folder As...

I have over 5000 documents to rename with the text in the first line of each document. I can currently open-->copy & paste to a new document-->save new document as (with the desired file name)-->BUT I have to click save for each until it cycles through all 5000 documents. How can I avoid...