Command Button to open workbook and update the macro within

C

cassie123

New Member
Joined
May 27, 2015
Messages
21
Hi all,

I would like to create a command button/macro to open all the workbooks( I have 200 of them in the same folder) and update/run the macro in the workbook.


Please help and thank you.
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
You must log in or register to reply here.

Similar threads

B
  • Question
Stopping the save button from clearing textboxes on UserForm.
Replies
2
Views
271
bandito04
B
T
  • Question
updating all the data from another workbook
Replies
4
Views
308
Tej92
T
JohnGow383
  • Question
ActiveX Command Buttons Swapping Over After Execution
Replies
1
Views
244
JohnGow383
JohnGow383
Ottsel
  • Solved
Create File Directory Within Excel
Replies
3
Views
376
Eric W
Eric W
J
  • Solved
Easiest way to execute a macro from Excel Menu
Replies
2
Views
436
jharding
J

Forum statistics

Threads
1,203,600
Messages
6,056,206
Members
444,850
Latest member
dancasta7

Share this page

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