-
excel help
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.
:confused: :confused: :eek: :confused: :confused:
-
have you turned the alerts off? (displayalerts = false)
if so, turn them back on and try again - you should see some kind of message from Exccel saying why it wont close (common ones are "document isn't saved, save it now?", and "lots of stuff on the clipboard, keep it there?")
-
thanks for the help.
i think that should be the problem although i haven't tried it out yet.
anyway is there anyway that i can quit excel and the sheet without saving them? cos i'm using one and after that it is no longer needed.. so i need to delete the sheet then close excel. but the problem is it always prompts me whetehr i want to delete.
can this be done without the prompts coming out? thanks
-
thats a simple one, when you do "excel.quit", just add a false parameter to the end - this is to give an answer to "save changes", so:
excel.quit false
:cool:
-