countsheets

  1. V

    Convert VBA for use in MACs

    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...
  2. V

    Macro not compatablie with Macs

    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...
  3. L

    Merge Excel Files with the same Tabs names

    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...
  4. S

    Consolidating 2 files into 1 single file with 1 worksheet

    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...
  5. S

    Add Sheet Name to Merge Files Macro

    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...
  6. M

    VBA for combining sheets from different workbooks

    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...
  7. L

    Combining 3 excel files into 1 workbook using VBA

    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...
  8. R

    Assist on creation of a code for merging files into one, and then merge data from sheets into one

    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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top