Re: Vba Button Export Data From Xls To Mdb
Hey, thanks to you, I finish my own codes. But there is still one more problem.
This line of code did not work as expected. After run these codes, the process EXCEL was not killed and still using some resources. Have you all seen this? And how can this be done.? Do you think we need to call Kill process method?
Re: Vba Button Export Data From Xls To Mdb
I dont know what code you have but perhaps it would be best to start your own thread. ;)
YOu cant kill the excel process just by setting hte applicaiton object variable to Nothing. You need to .Quit it first and before that any other object variables of Excel.
Re: Vba Button Export Data From Xls To Mdb
vb Code:
Set excelWksht = Nothing
excelWbk.Close Savechanges:=True
Set excelWbk = Nothing
excelApp.Quit
Set excelApp = Nothing
I am sorry for being not so clear. My codes were above, it really did not work, and bythe way I am using Office XP.