Editing XLSB and OPM Macros Programatically
Is there a way to edit the content of a macro file programatically? I want to programmatically alter the content of my excel macros (saved in an XLSB file) and my outlook macros (saved in the default OPM file).
I regularly run a batch file on my colleagues' computers that updates overwrites their Excel and Outlook macros/ribbons with my own. After their files are updated, I'd like to edit the macros themselves on the user's local drive, replacing all instances of my name with theirs (there are a handful of email macros which presently contain my name in the closing salutation). I tried to force open the excel macros doc (XLSB) and the outlook macros doc (OPM) with Notepad so I could do a find/replace, but it couldn't read them. I would rather that I didn't have to open Excel or Outlook to do it, since those programs need to be closed in order to perform the update. Is there any type of program I could use to read and edit the macro text for either file or both? Or is there perhaps a way to extract the text from the files and dump it into notepad for the find/replace, then return it? Any suggestions would be appreciated.
excel vbscript outlook xlsb
asked Nov 21 '18 at 14:19
user3597313user3597313
276
add a comment |
Is there a way to edit the content of a macro file programatically? I want to programmatically alter the content of my excel macros (saved in an XLSB file) and my outlook macros (saved in the default OPM file).
I regularly run a batch file on my colleagues' computers that updates overwrites their Excel and Outlook macros/ribbons with my own. After their files are updated, I'd like to edit the macros themselves on the user's local drive, replacing all instances of my name with theirs (there are a handful of email macros which presently contain my name in the closing salutation). I tried to force open the excel macros doc (XLSB) and the outlook macros doc (OPM) with Notepad so I could do a find/replace, but it couldn't read them. I would rather that I didn't have to open Excel or Outlook to do it, since those programs need to be closed in order to perform the update. Is there any type of program I could use to read and edit the macro text for either file or both? Or is there perhaps a way to extract the text from the files and dump it into notepad for the find/replace, then return it? Any suggestions would be appreciated.
excel vbscript outlook xlsb
asked Nov 21 '18 at 14:19
user3597313user3597313
276
add a comment |
Is there a way to edit the content of a macro file programatically? I want to programmatically alter the content of my excel macros (saved in an XLSB file) and my outlook macros (saved in the default OPM file).
I regularly run a batch file on my colleagues' computers that updates overwrites their Excel and Outlook macros/ribbons with my own. After their files are updated, I'd like to edit the macros themselves on the user's local drive, replacing all instances of my name with theirs (there are a handful of email macros which presently contain my name in the closing salutation). I tried to force open the excel macros doc (XLSB) and the outlook macros doc (OPM) with Notepad so I could do a find/replace, but it couldn't read them. I would rather that I didn't have to open Excel or Outlook to do it, since those programs need to be closed in order to perform the update. Is there any type of program I could use to read and edit the macro text for either file or both? Or is there perhaps a way to extract the text from the files and dump it into notepad for the find/replace, then return it? Any suggestions would be appreciated.
excel vbscript outlook xlsb
asked Nov 21 '18 at 14:19
user3597313user3597313
276
Is there a way to edit the content of a macro file programatically? I want to programmatically alter the content of my excel macros (saved in an XLSB file) and my outlook macros (saved in the default OPM file).
I regularly run a batch file on my colleagues' computers that updates overwrites their Excel and Outlook macros/ribbons with my own. After their files are updated, I'd like to edit the macros themselves on the user's local drive, replacing all instances of my name with theirs (there are a handful of email macros which presently contain my name in the closing salutation). I tried to force open the excel macros doc (XLSB) and the outlook macros doc (OPM) with Notepad so I could do a find/replace, but it couldn't read them. I would rather that I didn't have to open Excel or Outlook to do it, since those programs need to be closed in order to perform the update. Is there any type of program I could use to read and edit the macro text for either file or both? Or is there perhaps a way to extract the text from the files and dump it into notepad for the find/replace, then return it? Any suggestions would be appreciated.
excel vbscript outlook xlsb
excel vbscript outlook xlsb
asked Nov 21 '18 at 14:19
user3597313user3597313
276
asked Nov 21 '18 at 14:19
user3597313user3597313
276
edited Nov 23 '18 at 13:26
user3597313
asked Nov 21 '18 at 14:19
user3597313user3597313
276
asked Nov 21 '18 at 14:19
user3597313user3597313
276
asked Nov 21 '18 at 14:19
user3597313user3597313
276
276
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53414104%2fediting-xlsb-and-opm-macros-programatically%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53414104%2fediting-xlsb-and-opm-macros-programatically%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
