workbooks in folder

Struggling with "activeworkbook" vba. I have a spreadsheet with a button (who doesn't, right?). This button is supposed to take all of the .xlsx files, recognize the name, and save as pdf's to various destination folders on sharepoint/teams based on that name. Most of that actually happens...

I have a folder having total 13 workbooks with same sheet name "Annex 2" . I need to open each single workbook (from those 13 workbooks) and need to copy data from column A to P from Sheet "Annex 2" and need to create a new Master file and paste into it. Please help me out with this. Thank you...

I have multiple excel files in the following folder "C:\Users\frasmar\Desktop\Test" (all .xls files) where I want to extract data from the sheet named "Tombstone - DonnéesDeBase". The data that I want to extract is range "M4:M13". I would like to copy that range and paste it in another workbook...

Hello everyone, I have been looking everywhere and I can't seem to find what I am looking for. I want to create a Macro that will go into a folder, search every Workbook (each with multiple Worksheets), and copy and paste the data onto a single Worksheet. The data that I want will begin in Row...

Hi, I have a folder with the path "C:\A\Consolidated". This folder contains the master file. There are also folders within the Consolidated Folder that are differentiated by dates - YYYYMMDD. The date folders contain identical workbooks that are differentiated only by employee name. The number...