PDA

View Full Version : How to run the VB in all Excel Files



ooitzechyi
10-31-2016, 08:40 PM
Hi, I had stored the VB in one file (let's named it as fileA.xlsm) and keep this fileA at Desktop.
And I also add-in the VB to ribbon.
Now, I'm facing 2 problems.
1. I open a new excel file (fileA is closed) and run the VB code in ribbon. I managed to get what I want but fileA will be prompted (open automatically).
2. If I try to run the VB in an excel file save at D_drive, error message will be prompted as fileA is not found.

Any method would help me solve this problem?
Thank you.