Get variable data from a XLSM file

tono0582 — Tue, 27 Jun 2023 15:26:39 GMT

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?

Thanks to everyone.

Re: Get variable data from a XLSM file

Athiban_Mahamathi — Wed, 28 Jun 2023 05:44:26 GMT

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:

topic Get variable data from a XLSM file in Product Forum

Get variable data from a XLSM file

Re: Get variable data from a XLSM file