View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
elien99 elien99 is offline
external usenet poster
 
Posts: 2
Default Opening a saved file

Hi,

I am saving a file named abc.xls with the following code:

Application.DisplayAlerts = False

ActiveWorkbook.SaveAs Filename:="abc", _
FileFormat:=xlNormal, Password:="",
WriteResPassword:="", ReadOnlyRecommended:=True,
CreateBackup:=False

Windows("abc.xls").Close

Problem : When I try to open this saved file I get the
following message:
"EXCEL.exe has generated errors and will be closed by
windows. You will need to restart the program.
An error log is being created."

Note: I don't get this message when I save manually the
same file.

Question 1: Any clue why I get this pop-up? and what is
the remedy?

Question 2: Where is this logfile in windows/office 2000?

Any help would be much appreciated