How to Prevent from the workbook to pop up??

Posted by Edo on October 20, 2000 10:32 AM

Hello
I have a procedure that saves specific workbook (book1) every 2 min.
The problem is when I'm working on a different workbook (book2),every time that the following code line is process (in book1) -

sheet1.SaveAs Filename:="C:\rates.csv", FileFormat:= xlCSV, CreateBackup:=False

The first workbook (book1) pops up for 1 sec.
notice that if the active window is not excel their is no problem.
How can I solve this problem?
Thanks in advance
Edo

Posted by DoughBoy on October 23, 2000 1:06 AM

don't exactly understand the problem
but try
Application.ScreenUpdating = False
sheet1.SaveAs Filename:="C:\rates.csv", FileFormat:= xlCSV, CreateBackup:=False
Application.ScreenUpdating = true