Excel related problem

[tmadhu]

Dear Friend,
I've developed code to create Excel work book and post data in to it. Since one year it is working fine. Now from 1 week it is not working at our client place. I am not able to trace what might gone wrong or new installations happened etc.,

I am putting the code here. As soon as the application reaches Line 10 program is just exiting without giving any error message.

Dim xlFl As String
1.On Error GoTo Errh
2.Excel.Applica tion.DisplayAle rts = False
3.xlFl = Replace(RltFl, ".rlt", ".xls", 1, 1, vbTextCompare)
CloseIfOpen xlFl
xlApp.DisplayAl erts = False
Set xlWorkBook = xlApp.Workbooks .Add
ActiveWindow.Zo om = 100
ActiveWindow.Wi ndowState = xlMaximized
xlWorkBook.Save As xlFl

[sirsnorklingtayo]

Did you try to re-Install the MS Office? or did they try to make some updates like MS OFFICE 2000 to XP/2003? Try to re-Install it first with your original MS OFFICE Version because if you developed your Program under previous version of MS OFFICE like 2000 then your client is using XP/2003 then some of the functionalities might not the same as the old one. So, in short please check if there are some compatibility issues. I experienced that before...

Gud luck

Norman

[Killer42]

I'd suggest leaving DisplayAlerts turned on for debugging, in case you are suppressing a significant error message.

[tmadhu]

Thanks a lot buddy, Keep it up. Your suggestion shown me a way.

Regards,
Madhu.

Did you try to re-Install the MS Office? or did they try to make some updates like MS OFFICE 2000 to XP/2003? Try to re-Install it first with your original MS OFFICE Version because if you developed your Program under previous version of MS OFFICE like 2000 then your client is using XP/2003 then some of the functionalities might not the same as the old one. So, in short please check if there are some compatibility issues. I experienced that before...

Gud luck

Norman