Hi, has anyone tried to get the variable value embedded in a text box control from an XLSM file?
I tried several times with the default Get Cell Value action, but it doesnt detect the existence of the variable, anyone has any ideas about how to manage this type of data extraction?
Hello Antonio,
We can't extract textbox values using the Get cell action. The ActiveX textbox value can be extracted by creating a new custom action in the Excel VBO. Please refer the below snippet of code.
Inputs:
Textboxname : Developer -> Design Mode -> Click on the textbox -> Properties -> Name (based on the attached screenshot it should be "Fecha")
Output:
Code:
