Hi,
I am facing a problem with office 2000. I am using OWC 11 componets (chart and Spreadsheet). i installed the OWC comonent in the system. Now it is giving me error when I Tried to set its parameters like top, hight, width using VBA. when i debug and trace the code..the excel closed when it reached to that properties line ie. (Chart1.top = 500).I am creating a instance of chart and spreadsheet during run time only.
now i test it with other way. i took a new workbook, add a userform and now place a office chart 11.0 component on the form. When i tried to resize the chart it gives me the following error message and close the excel:
“Excel.exe has generated errors an will be closed by windows. You will need to restart the program. An error log is being created.”
I am wondering to see that my code works fine in India but not in Germany. Its working well on Desktop in Geman setting but not on Laptop (having German setting). I reinstalled the office but facing the same problem.
Please help me to fix this problem.
Thanks in Advanced
Reagards,
Tony