Thread: Save
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
edward edward is offline
external usenet poster
 
Posts: 87
Default Save

Hi Everybody,
I'm programming Excel in Outlook and export some data from Outlook to Excel,
I want to save newly added data in Excel and I use the following code
appExcel.Activeworkbook.Save
but I get the following message
A file named "xyz.xls" already exists in this clocation . Do you wnat to
replace it?
how can I avoid this message?

by the way I use the following code as well
Set appExcel=Createobject("Excel.application")
appExcel.workbooks.open(" filepath ")


--
Best regards,
Edward