Now leaving a blank "" in the SelectGenerateData action will make that cell value in the Excel table empty, while leaving a null in the SelectGenerateData action will skip updating / not alter the cell value that currently exists in the Excel table there. Version 6 ...
Since these methods are prone to runtime errors, but work fine after one or two tries in debug mode, you might have to tell Excel to try again if it runs into an error. I solved this by adding this error handler to the sub, and it works fine: Sub ApplyHTML() On Error GoTo E...
The problem I have is the occurrence in the cell is variable, the needed string is variable, and the LEFT delimiter is variable. The LEFT delimiter is either ("," ) or ("~" )and the right delimiter is always ":O". So, in the first cell I need to parse out, "CDIFO"...
Now leaving a blank "" in the SelectGenerateData action will make that cell value in the Excel table empty, while leaving a null in the SelectGenerateData action will skip updating / not alter the cell value that currently exists in the Excel table there. Version 6 which looks ...