countsheets

Hello. I need help converting the below macro to be used in MACs. Any help would be appreciated!! Sub MergeExcelFiles() Dim fnameList, fnameCurFile As Variant Dim countFiles, countSheets As Integer Dim wksCurSheet As Worksheet Dim wbkCurBook, wbkSrcBook As Workbook...

Hello, unfortunately I have a client that insists on using Macs. The Macro I am using below is returning a 1004 error for Method 'GetOpenFileame'_Application' failed when using a Mac only. Is there any way to correct to have it work on both Mac and PC? Sub MergeExcelFiles() Dim...

Hello Guys, I have a problem if you could help me out. I have the following vba code (found it, not created it): As it's 'Sub' specifies it is a 'Excel Merger' and it works but it doesn't do what I really want. Context: I am having 2 Excel Files with the same Tabs names and I need to merge...

Hello Friends, Need your help in writing a macro since i am very new to the world of Macros. Problem Statement: There are 2 separate .xlsb files at 2 different locations. Currently i manually copy the data from each file into a new workbook in a single sheet. So i want to write a macro which...

Hello! I am using the below macro that I found to combine several worksheets into one workbooks on separate tabs. However, I need the Sheet names to be the names of the files so I know which is which - ideally the name of the file without ".xls" but if it has to be there that is fine. I was...

Hi, I have a folder with plenty workbooks. Each workbook contains multiple sheets. I want to combine one specific sheet (say "Sheet X") from each workbook into sheets in one master workbook, and I want to create a macro that does this. The macro should be able to do the following steps: 1...

I have 3 excel files that I am trying to combine into one file so that they can be sorted in a particular tab order. I have the below code that I am trying to use that merges the files together. The issue I am having is that it is linking the cells back to the original file and I just want the...

Hello all, I don't have big knowledge and experience in VBA coding, but still learning. I would like to ask you, VBA coders, for your kind assistance in creating a VBA code for my purpose. I need data which is extracted day by day into one file. So far I have found a code that merges files into...