View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Doug_F Doug_F is offline
external usenet poster
 
Posts: 13
Default Has the Excel 2003 OLE model changed over SPs?

Thanks. I have a request in to have the use updated to SP3. If that fixes
the problem, I'll probably not go any further. If he's still hosed, I'll
create a new version and leave off the 'xlapp.' bit and see what happens.

Doug

"dmoney" wrote:

Not sure why, but I had a similar problem and excluding the application
seemed to work.

ActiveWorkbook.SaveAs Filename:= _
"C:\filename.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False