library_vb » Revisions »
Differences
This shows you the differences between the selected revisions of the page.
| 2018-08-20 | 2018-08-20 | ||
| links update (martin) | link normalization (martin) | ||
| Line 22: | Line 22: | ||
| * Implement your interactions with WinSCP .NET assembly in a class module; | * Implement your interactions with WinSCP .NET assembly in a class module; | ||
| * Declare private variable in your class module referring to ''[[library_session|Session]]'' class; | * Declare private variable in your class module referring to ''[[library_session|Session]]'' class; | ||
| - | * Use ''[[https://docs.microsoft.com/en-us/office/vba/Language/Reference/User-Interface-Help/withevents-keyword|WithEvents]]'' keyword, when declaring the private variable; | + | * Use ''[[https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/withevents-keyword|WithEvents]]'' keyword, when declaring the private variable; |
| * Define private function (method) with name ''<variablename>_<event>'' and two arguments (e.g. ''sender'' and ''e'') for every event you need to handle. | * Define private function (method) with name ''<variablename>_<event>'' and two arguments (e.g. ''sender'' and ''e'') for every event you need to handle. | ||
| Line 46: | Line 46: | ||
| VBA does not support catching exceptions, what is a common way of handling errors in examples for most other languages. | VBA does not support catching exceptions, what is a common way of handling errors in examples for most other languages. | ||
| - | In case you need to use custom error handling, instead of interrupting a VB macro (the default behavior), use ''[[https://docs.microsoft.com/en-us/office/vba/Language/Reference/User-Interface-Help/on-error-statement|On Error]]'' statement. | + | In case you need to use custom error handling, instead of interrupting a VB macro (the default behavior), use ''[[https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/on-error-statement|On Error]]'' statement. |
| - | Use ''On Error Resume Next'' to disable default error handling. Then you need to query ''[[https://docs.microsoft.com/en-us/office/vba/Language/Reference/User-Interface-Help/err-object|Err.Number]]'' after every statement to test for errors. You can revert to default error handling (aborting the macro) using ''On Error GoTo 0''. | + | Use ''On Error Resume Next'' to disable default error handling. Then you need to query ''[[https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/err-object|Err.Number]]'' after every statement to test for errors. You can revert to default error handling (aborting the macro) using ''On Error GoTo 0''. |
| <code vb> | <code vb> | ||