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
|