Recent content by nghiapp

Thanks everybody for the advices. I'm trying to calculate flex time of a day. It shall be shown for every day and the accumulated sum of a week. I think I will use two cells of each day, one to show the value in text format and another one in number format to calculate the sum.

I would like to display result of a subtraction between two time values in time format "hh:mm". It is OK if the result is positive, but only ###### if negative. How to format the cell to show the result with "-" sign as "-12:23" ?

The error could come if sheet2 is protected. If not try with Sheets("Sheet2").Cells.Select Hope this help.

Thank WinblowsMe, That is what I 'm looking for. It works perfectly (after remove List1). Regards Nghia

Thank for the input. I tried to use the "quit" command just before setting the object to Nothing, but it did not work. The object start with: Set PvDbs = CreateObject(OleDbsObjName$) where OleDbsObjName$ is provided by the other. After finish working with the object, I closed the object by...

In Excel VBA, I invoke a process to run in background. After finish, the process should be closed by setting to Nothing, but sometime it fails to close. I can go to the Task manager or use command line "Taskkill" to kill the process manually. How can I check if it is closed and kill the process...