closed file

  1. E

    Macro to copy tab from closed workbook not working

    Hi all, The below code doesn't seem to be working: Sub CopySheet() Application.ScreenUpdating = False Set closedBook = Workbooks.Open("C:\Users\040429\Documents\Workings\Excel\_Holidays_.xlsb") closedBook.Sheets("Holidays ").Copy Before:=ThisWorkbook.ActiveSheet...
  2. V

    Getting external data from Dynamic Path and Closed Files

    Hello, I'm trying to get external data from a number of different excel files across different Locations, WITHOUT needing to open the files. I want to aggregate all data from one year (on different Closed workbooks) into a single sheet (per store) on the Open Workbook . The Closed woorkbooks...
    • voodoo1
    • Thread
    • closed file dynamic path reference external data
    • Replies: 5
    • Forum: Excel Questions
  3. S

    Getting value from closed workbook

    Hi there, I have this code which extracts the values I want from the spreadsheet I want, however there is only one problem - hopefully an easy fix. This extracts the data from rows 5 to 28 and columns 26 to 36, but inputs these values into my sheet in the same place. I would like the macro to...
    • sn281
    • Thread
    • closed file closed workbook get value range strip
    • Replies: 5
    • Forum: Excel Questions
  4. N

    Alternative for Countifs when referencing closed file - multiple lines

    Hi. I've been going through the archives to look for an alternative to using "COUNTIF" as I am referencing a file that is 113 MB and would prefer never to open it again. There are a few suggestions I've seen in searching the archives like trying a combination SUM(IF) or ACOUNT but none work at...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top