Following are the few differences:
1. We have a Library File with following Functions One Public and another Private:
Public Function myPublicFun()
msgbox "I am a public function"
End Function
Private Function myPrivateFun()
msgbox "I am a Private function"
End Function
If we use ExecuteFile method to load the library file, we will be able to access the private function directly. But if the same file is associated we won't be able to access private functions directly (Type Mismatch Error will be thrown).
Please Note that the functions are not inside a class.
2. With ExecuteFile method debugging of your class/Functions become difficult as F11/Step into feature does not work properly.
Regards,
Rajeshwar
1. We have a Library File with following Functions One Public and another Private:
Public Function myPublicFun()
msgbox "I am a public function"
End Function
Private Function myPrivateFun()
msgbox "I am a Private function"
End Function
If we use ExecuteFile method to load the library file, we will be able to access the private function directly. But if the same file is associated we won't be able to access private functions directly (Type Mismatch Error will be thrown).
Please Note that the functions are not inside a class.
2. With ExecuteFile method debugging of your class/Functions become difficult as F11/Step into feature does not work properly.
Regards,
Rajeshwar