I writing in VBA for excell.
My program calls the filecopy function in a private function. If filecopy
fails, the program should analyze it and return with a failure value to the
main subrotine that calld the fuction (in a success execution of filecopy,
the function returns the workbook object of the new destination file). How
can I check the status of the execution?
How can I found out if the returnd workbook object has value or it's empty?
Thanks