[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 449
  • Last Modified:

i have a macro which running on excel 2007 file and not stoping, "the file is not responding" how do i stop the running without close the file?

Which process i have to terminate to stop the excel macro running without closing the file?

Thanks
0
gvilbis
Asked:
gvilbis
  • 3
  • 2
  • 2
  • +3
8 Solutions
 
gvilbisAuthor Commented:
yes i press on ESC and its stop but some time all the file is getting white and "not responding" and i know there is a process which has to be kill and rerun, is someone know which process it is?

Thanks
0
 
VipulKadiaCommented:
Hi gvilbis,
It will be good if you post your file which contains the macro.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Rory ArchibaldCommented:
You can't just kill a macro using task manager as far as I know. You can only terminate Excel. Far better to fix the code.
0
 
andrewssd3Commented:
Have you tried pressing CTRL-Break while the macro is running - this should give you a dialog box where you can stop the macro.
0
 
Arno KosterCommented:
as rorya & andrewssd3 indicate :

it is either trying to pause the macro by pressing CTRL-break, or killing the excel task and thereby closing the file.

When you kill the excel task however, intermediate saved files (automatically saved by excel) might be available. the amount of work that will be lost can vary however.
0
 
gvilbisAuthor Commented:
right now the macro is stop
i will try in next time
however in the past some expert give me a process to kill and rerun it and it worked however i can not find it right now
0
 
andrewssd3Commented:
I agree with akoster - I'm pretty sure there's no process you can kill that will stop just the vba execution.  You can only stop the Excel.exe process, and this will kill the whole of Excel, with potential loss of data.
0
 
Arno KosterCommented:
You might be able to concoct a standalone program that identifies the excel process (eg using a tool such as windows spy) and the send API messages to the VBA editor part of the excel process to stop macro execution. I am not sure however if this would even be technically possible at all
0
 
andrewssd3Commented:
Probably easier to just to fix your macro now you have managed to stop it :)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now