open macros

  1. J

    Open Files, Run Macro, Save, Close File

    I have been working on a code to open all files in a folder and run each of their macro, save&close each of them. I have a "Master" file that I am putting it in. I am getting a sub or fx not defined on my sub routine Call UpdateData part of the code. The full code is: Sub UpdateAll() Dim...
  2. S

    HELP! How to make code run faster. It's so slow!!

    Hi, So here's the story: I have 24 workbooks, with 12 sheets in each workbook. I have a macro written for EACH sheet in EACH workbook. I also have code written in the first module of EACH workbook. These 24 workbooks are in a folder. I then have another workbook called "Export" which is not...

Some videos you may like

This Week's Hot Topics