combine files

Hi All! I am new to the forum and BI, but this is what I'm working with: 1. We receive/download approx 23 files per day from a vendor share site - combo of csv/excel & pdf reports (though naming conventions are NOT consistent) 2. We have a daily tracking sheet of numerous rows we maintain and...

Hi guys, Need some help on the below code please. See code below. What I would like it to do is to do the following, in sequence: 1. Create a new folder in the location of the Workbook. Name this folder based on the contents of worksheet cells "D2" and "D3", then the current date and time...

I'm importing a number of CSV files that are stored in a folder. I can get power query to import and merge them all into a long list, however if i make changes in the power query editor - > Transform Sample file. The Data query that combines all the files no longer works as I've changed the...

I'm combining data from multiple .XML files in a specific folder using the Combine & Transform option in Power Query. The files are similar, they all contain some standard information, but the problem is that some of them have a few additional columns. All files have the following information...

Hi All, I need a macro for combing 3 workbooks into one new workbook. For example a excel file contains list of files in coulmn A ,B and C and in Column E new file name . I need to update all three workbooks without saving the actual workbook combine all workbook into One workbook . Here is...

I have written a Macro that opens the selected file, searches where the error is occured and then places it in the Summary file in the active cell. Its working perfectly but now i want that instead of selecting each file one by one i could select all required files together or i could open one...

Hi, Until recently all of my school's attendance figures, teacher payclaims, etc were written by hand and faxed to HQ at the end of the month. This was time consuming, frustrating and error-prone. I put together an Excel workbook that took away most of the teachers' pain but the HQ office staff...

I am trying to write some VBA code that will allow me to combine multiple files (exact # varies each week) in a folder into 1 file. The files only contain 1 row (no headers) and 9 columns (shown below). I would like the macro to open each file and copy row 1 and then paste it in my macro...

I receive daily files that I must combine into a single file each month. The data in each file is the same (fields) but the challenge is the file name is different each day. Is there a way i can create a macro to combine all files together? Since the file names are different I would put into...