View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] hakanmalmros@mac.com is offline
external usenet poster
 
Posts: 1
Default Excel macro - Save as with override...

I am trying to handle "save as" command with override
of "File already exist, Do you want to replace it" from
excel VB macro but I can't get it right.

Using "ActiveWorkbook.Close Savechanges:=Active,
Filename:="C:\Test1.txt", FileFormat:=xlText,
CreateBackup:=False"

Can not find any argument to override xl messagebox.

Thanks!