open run

  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...
    • jpsimmon
    • Thread
    • open open and close workbooks open macros open run
    • Replies: 1
    • Forum: Excel Questions
  2. T

    VBA Macro to auto run on open and close with formatting

    Hi, I am trying to keep column G as text format. I would not like anyone to change the format as another program needs to read it as text. so the format has to be for ex. 12/22/2014 or 12/01/2014 but text and users should not be allowed to change it. What i had so far is not working, can...

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