Invoke VBA - Compile Error, Variable not defined

[shawnmurray]

Hi,

Trying to use Invoke VBA Activity and i receive the following error:

Everything seems fine so im not sure where the issue could be?

Regards,
Shawn

[Palaniyappan (Palaniyappan P)]

Fine
–have we passed any argument to the script, if so kindly check whether it is defined within the code with a datataype like string or int
or
–kindly check once whether the entry method name is what in the VBA script as well as a method name

Cheers @shawnmurray

[KarthikByggari]

Please check the code inside macro file.
As the error says, the variable is not declared but using somewhere in the code.

For example:

Dim strValue As String //you might be missing this statement

strValue = “Hello”

[shawnmurray]

@Palaniyappan @KarthikByggari

Thanks for the suggestions, I have checked and still cant seem to locate the problem,
Would you guys mind having a look?

Regards,
Shawn

[Palaniyappan (Palaniyappan P)]

kindly share the vb script a screenshot if possible
Cheers @shawnmurray

[shawnmurray]

Hi @Palaniyappan

Please see screenshot

Thanks