Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro pauses
I have been running a macro for a few weeks. All of a sudden it began
stopping on one line, with no error message. I hit the play button and the macro continues to the end. Any ideas? TIA Gerry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro pauses
Tell us what the line is, Gerry.
-- Gary Brown "Gerry" wrote: I have been running a macro for a few weeks. All of a sudden it began stopping on one line, with no error message. I hit the play button and the macro continues to the end. Any ideas? TIA Gerry |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro pauses
Here is the line it is pausing on.
ActiveWorkbook.SaveAs Filename:="C:\Shared Data\RetailPro\Retail\Rpro\PRINT\Inventory for G Site old.txt",FileFormat:=xlText, CreateBackup:=False Gerry *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro pauses
My best guess is that in the past, after creating the file "Inventory for G
Site old.txt", it has been moved, deleted and/or name changed. Try putting the following lines in front of the line that is pausing... Application.DisplayAlerts = False 'turn warnings off Kill :="C:\Shared Data\RetailPro\Retail\Rpro\PRINT\Inventory for G Site old.txt" Application.DisplayAlerts = True 'turn warnings on This will delete the old file without stopping the code/displaying warnings just before you are creating the file with your line... ActiveWorkbook.SaveAs Filename:="C:\Shared Data\RetailPro\Retail\Rpro\PRINT\Inventory for G Site old.txt",FileFormat:=xlText, CreateBackup:=False HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Gerry Waldram" wrote: Here is the line it is pausing on. ActiveWorkbook.SaveAs Filename:="C:\Shared Data\RetailPro\Retail\Rpro\PRINT\Inventory for G Site old.txt",FileFormat:=xlText, CreateBackup:=False Gerry *** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro pauses
Thanks Gary
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 pauses after copy or paste actions | Excel Discussion (Misc queries) | |||
Macro allowing pauses for editing | Excel Discussion (Misc queries) | |||
printer pauses after each page can't just print 20 copies | Excel Discussion (Misc queries) | |||
Creating a .bat file that opens, pauses & closes MS Excel | Excel Programming | |||
Excel macros should be able to record pauses, thread.sleep(23489) | Excel Discussion (Misc queries) |