VBA script runs once but if I try to run it again, it does not work

cboshdave · #1 07-10-2017, 03:34 PM

Did not look in detail. Just throwing this out. Is it possible that the file is open in memory and NOT visible? I have had that happen. Look at your task manager and see if there is an instance of Excel running there that you can't see on your screen.

Just a thought.

jakecahill · #2 07-11-2017, 12:40 AM

I did check that. I saw it once, but even closing the instance of Excel from the task manager didn't fix the problem.

Is there a line of code that can make sure that Excel closes properly at the end of the script?

cboshdave · #3 07-11-2017, 07:32 AM

Yes, but if you are not seeing the instance of Excel, that is probably not your problem. I will see if I can find the code that I wrote.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA runs I then save as to keep master free from editds but does not work	dingar	Word VBA	3	04-27-2017 03:18 PM
Video Slide Runs Slow	tommyc325	PowerPoint	0	04-21-2017 06:09 AM
Adapt a script used in Word to highlight words, to work in Outlook?	flatop	Outlook	5	07-15-2014 01:07 PM
Limiting the times that it runs	hchbiker	PowerPoint	0	02-09-2011 08:36 AM
Rule runs once, but not later	stlsailor	Outlook	0	07-28-2009 08:18 PM