All excel-sheets are “not responding” while executing macro from other Excel file2019 Community Moderator ElectionStarting from Excel (VBA): Launch an external interactive program, and in there launch commands and read their output : is this possible?How do I create an executable application for a Excel macro procedure?Excel 2010 freezes when executing SQL statement through macroRun a VBA Macro against an Excel sheet with C#execute macros in multiple excel filesMacro for exporting text files from Excel file with multiple worksheetsExcel merge range from Macro run XLSB files into oneCode only runs on Excel 2007 if file is opened from within ExcelMacro button under customized ribbon tab tries to open old Excel fileRunning excel macros only on one sheetDisabling macros from other Excel sheets
Can an earth elemental drown/bury its opponent underground using earth glide?
3.5% Interest Student Loan or use all of my savings on Tuition?
A bug in Excel? Conditional formatting for marking duplicates also highlights unique value
It doesn't matter the side you see it
How can I highlight parts in a screenshot
Plagiarism of code by other PhD student
Formatting a table to look nice
Giving a talk in my old university, how prominently should I tell students my salary?
Why won't the strings command stop?
Being asked to review a paper in conference one has submitted to
How to kill a localhost:8080
Ahoy, Ye Traveler!
How to fix my table, centering of columns
Is every open circuit a capacitor?
Can a space-faring robot still function over a billion years?
How can I handle a player who pre-plans arguments about my rulings on RAW?
Split a number into equal parts given the number of parts
If nine coins are tossed, what is the probability that the number of heads is even?
How do we objectively assess if a dialogue sounds unnatural or cringy?
Misplaced tyre lever - alternatives?
Difference between 'stomach' and 'uterus'
Why did the Cray-1 have 8 parity bits per word?
PTIJ: What dummy is the Gemara referring to?
Relationship between the symmetry number of a molecule as used in rotational spectroscopy and point group
All excel-sheets are “not responding” while executing macro from other Excel file
2019 Community Moderator ElectionStarting from Excel (VBA): Launch an external interactive program, and in there launch commands and read their output : is this possible?How do I create an executable application for a Excel macro procedure?Excel 2010 freezes when executing SQL statement through macroRun a VBA Macro against an Excel sheet with C#execute macros in multiple excel filesMacro for exporting text files from Excel file with multiple worksheetsExcel merge range from Macro run XLSB files into oneCode only runs on Excel 2007 if file is opened from within ExcelMacro button under customized ribbon tab tries to open old Excel fileRunning excel macros only on one sheetDisabling macros from other Excel sheets
As indicated in this question, I'm running Windbg from Excel, in order to analyse the results.
Within my Excel macro, there are following lines of code:
Windbg_PID1 = Shell("windbg -z """ + Txt_File1.Text + """ -logo """ + Output_FileName1 + """ -c "".load pykd.pyd;!py heap_stat.py -stat""", vbMaximizedFocus)
Windbg_PID2 = Shell("windbg -z """ + Txt_File2.Text + """ -logo """ + Output_FileName2 + """ -c "".load pykd.pyd;!py heap_stat.py -stat""", vbMaximizedFocus)
And after quite some Windbg processing, there is following command to close the mentioned Windbg sessions:
Shell "TASKKILL /PID " + CStr(Windbg_PID1) + " /PID " + CStr(Windbg_PID2)
Everything is working fine, but there's a catch : it seems that all Excel files (even the ones who have nothing to do with my Windbg analysis) get grouped under the same Excel application, and as long as my Windbg launching macro is running, all my other Excel files turn into Not responding.
Does somebody know how to:
- (Preferably) Launching a macro within an Excel file (even if it contains
Shell()worksheet function), without making my Excel file "not responding". - (In case point 1 is impossible) open my other Excel files under a separate Excel application. (When I open 3 Excel files and I run
tasklist | findstr /I excel, I should get 3 results)
(For your information, I already tried using vbNormalNoFocus as Window style but this did not save the issue)
excel vba worksheet-function
asked 19 hours ago
DominiqueDominique
2,02241941
add a comment |
As indicated in this question, I'm running Windbg from Excel, in order to analyse the results.
Within my Excel macro, there are following lines of code:
Windbg_PID1 = Shell("windbg -z """ + Txt_File1.Text + """ -logo """ + Output_FileName1 + """ -c "".load pykd.pyd;!py heap_stat.py -stat""", vbMaximizedFocus)
Windbg_PID2 = Shell("windbg -z """ + Txt_File2.Text + """ -logo """ + Output_FileName2 + """ -c "".load pykd.pyd;!py heap_stat.py -stat""", vbMaximizedFocus)
And after quite some Windbg processing, there is following command to close the mentioned Windbg sessions:
Shell "TASKKILL /PID " + CStr(Windbg_PID1) + " /PID " + CStr(Windbg_PID2)
Everything is working fine, but there's a catch : it seems that all Excel files (even the ones who have nothing to do with my Windbg analysis) get grouped under the same Excel application, and as long as my Windbg launching macro is running, all my other Excel files turn into Not responding.
Does somebody know how to:
- (Preferably) Launching a macro within an Excel file (even if it contains
Shell()worksheet function), without making my Excel file "not responding". - (In case point 1 is impossible) open my other Excel files under a separate Excel application. (When I open 3 Excel files and I run
tasklist | findstr /I excel, I should get 3 results)
(For your information, I already tried using vbNormalNoFocus as Window style but this did not save the issue)
excel vba worksheet-function
asked 19 hours ago
DominiqueDominique
2,02241941
try this link link
– Yane
17 hours ago
@Yane: thanks for the quick response, but this leaves me with another problem: as stated in that link, it is possible to start up a new Excel session, launchingExcel /x, but how can I add this/xswitch to the*.xlsmfile extension? (It gives the possibility to choose an app, but I seem not to be able to add switches to it)
– Dominique
17 hours ago
maybe this 4. Edit the Registry: Force Excel to Open in a New Instance by Default My suggestion would be to adjust your workflow in a way that you startr all normal files as usual and always open the files that use Windbg in a separate instance.
– Yane
17 hours ago
add a comment |
As indicated in this question, I'm running Windbg from Excel, in order to analyse the results.
Within my Excel macro, there are following lines of code:
Windbg_PID1 = Shell("windbg -z """ + Txt_File1.Text + """ -logo """ + Output_FileName1 + """ -c "".load pykd.pyd;!py heap_stat.py -stat""", vbMaximizedFocus)
Windbg_PID2 = Shell("windbg -z """ + Txt_File2.Text + """ -logo """ + Output_FileName2 + """ -c "".load pykd.pyd;!py heap_stat.py -stat""", vbMaximizedFocus)
And after quite some Windbg processing, there is following command to close the mentioned Windbg sessions:
Shell "TASKKILL /PID " + CStr(Windbg_PID1) + " /PID " + CStr(Windbg_PID2)
Everything is working fine, but there's a catch : it seems that all Excel files (even the ones who have nothing to do with my Windbg analysis) get grouped under the same Excel application, and as long as my Windbg launching macro is running, all my other Excel files turn into Not responding.
Does somebody know how to:
- (Preferably) Launching a macro within an Excel file (even if it contains
Shell()worksheet function), without making my Excel file "not responding". - (In case point 1 is impossible) open my other Excel files under a separate Excel application. (When I open 3 Excel files and I run
tasklist | findstr /I excel, I should get 3 results)
(For your information, I already tried using vbNormalNoFocus as Window style but this did not save the issue)
excel vba worksheet-function
asked 19 hours ago
DominiqueDominique
2,02241941
As indicated in this question, I'm running Windbg from Excel, in order to analyse the results.
Within my Excel macro, there are following lines of code:
Windbg_PID1 = Shell("windbg -z """ + Txt_File1.Text + """ -logo """ + Output_FileName1 + """ -c "".load pykd.pyd;!py heap_stat.py -stat""", vbMaximizedFocus)
Windbg_PID2 = Shell("windbg -z """ + Txt_File2.Text + """ -logo """ + Output_FileName2 + """ -c "".load pykd.pyd;!py heap_stat.py -stat""", vbMaximizedFocus)
And after quite some Windbg processing, there is following command to close the mentioned Windbg sessions:
Shell "TASKKILL /PID " + CStr(Windbg_PID1) + " /PID " + CStr(Windbg_PID2)
Everything is working fine, but there's a catch : it seems that all Excel files (even the ones who have nothing to do with my Windbg analysis) get grouped under the same Excel application, and as long as my Windbg launching macro is running, all my other Excel files turn into Not responding.
Does somebody know how to:
- (Preferably) Launching a macro within an Excel file (even if it contains
Shell()worksheet function), without making my Excel file "not responding". - (In case point 1 is impossible) open my other Excel files under a separate Excel application. (When I open 3 Excel files and I run
tasklist | findstr /I excel, I should get 3 results)
(For your information, I already tried using vbNormalNoFocus as Window style but this did not save the issue)
excel vba worksheet-function
excel vba worksheet-function
asked 19 hours ago
DominiqueDominique
2,02241941
asked 19 hours ago
DominiqueDominique
2,02241941
asked 19 hours ago
DominiqueDominique
2,02241941
asked 19 hours ago
DominiqueDominique
2,02241941
asked 19 hours ago
DominiqueDominique
2,02241941
2,02241941
try this link link
– Yane
17 hours ago
@Yane: thanks for the quick response, but this leaves me with another problem: as stated in that link, it is possible to start up a new Excel session, launchingExcel /x, but how can I add this/xswitch to the*.xlsmfile extension? (It gives the possibility to choose an app, but I seem not to be able to add switches to it)
– Dominique
17 hours ago
maybe this 4. Edit the Registry: Force Excel to Open in a New Instance by Default My suggestion would be to adjust your workflow in a way that you startr all normal files as usual and always open the files that use Windbg in a separate instance.
– Yane
17 hours ago
add a comment |
try this link link
– Yane
17 hours ago
@Yane: thanks for the quick response, but this leaves me with another problem: as stated in that link, it is possible to start up a new Excel session, launchingExcel /x, but how can I add this/xswitch to the*.xlsmfile extension? (It gives the possibility to choose an app, but I seem not to be able to add switches to it)
– Dominique
17 hours ago
maybe this 4. Edit the Registry: Force Excel to Open in a New Instance by Default My suggestion would be to adjust your workflow in a way that you startr all normal files as usual and always open the files that use Windbg in a separate instance.
– Yane
17 hours ago
try this link link
– Yane
17 hours ago
try this link link
– Yane
17 hours ago
@Yane: thanks for the quick response, but this leaves me with another problem: as stated in that link, it is possible to start up a new Excel session, launching
Excel /x, but how can I add this /x switch to the *.xlsm file extension? (It gives the possibility to choose an app, but I seem not to be able to add switches to it)– Dominique
17 hours ago
@Yane: thanks for the quick response, but this leaves me with another problem: as stated in that link, it is possible to start up a new Excel session, launching
Excel /x, but how can I add this /x switch to the *.xlsm file extension? (It gives the possibility to choose an app, but I seem not to be able to add switches to it)– Dominique
17 hours ago
maybe this 4. Edit the Registry: Force Excel to Open in a New Instance by Default My suggestion would be to adjust your workflow in a way that you startr all normal files as usual and always open the files that use Windbg in a separate instance.
– Yane
17 hours ago
maybe this 4. Edit the Registry: Force Excel to Open in a New Instance by Default My suggestion would be to adjust your workflow in a way that you startr all normal files as usual and always open the files that use Windbg in a separate instance.
– Yane
17 hours ago
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%2f55021515%2fall-excel-sheets-are-not-responding-while-executing-macro-from-other-excel-fil%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%2f55021515%2fall-excel-sheets-are-not-responding-while-executing-macro-from-other-excel-fil%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
try this link link
– Yane
17 hours ago
@Yane: thanks for the quick response, but this leaves me with another problem: as stated in that link, it is possible to start up a new Excel session, launching
Excel /x, but how can I add this/xswitch to the*.xlsmfile extension? (It gives the possibility to choose an app, but I seem not to be able to add switches to it)– Dominique
17 hours ago
maybe this 4. Edit the Registry: Force Excel to Open in a New Instance by Default My suggestion would be to adjust your workflow in a way that you startr all normal files as usual and always open the files that use Windbg in a separate instance.
– Yane
17 hours ago