can anyone tell me why my excel keep freezing after i save it using VB?
i used excel to establish DDE connection to a plc to retrieve data. after that i will save the file and exit.

i tried it before and it pose no problems.. however this time it always freeze and it doesn't quit even after i did the excel.application.quit

it just freeze there and it will eventually crash my computer as well. please help.

is it because of the load? cos this time round i used it to retrieve a substanially large amount of data from the plc as compared to last time.