-
How to run the VB in all Excel Files
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules