How to use Invoke VBA in STUDIOX?

Help StudioX
, , , ,
1

Help can anyone guide me on how to use invoke VBA in STUDIOX?
my code is to SUM BY FONT COLOR in excel.

I want to sum the all green font colors…
then repeat for all red font colors and yellow font colors…

2

Hi @flashdrive07

If you have your VBA Code with you, all you need is an excel application scope, and you can use that vba code inside a invoke vba activity.

3

SUMBYFONTCOLOR.txt (377 Bytes)
this is my sample code … can you guide me more ?

4

from where are you getting these ranges for the function?
it would look something like this:
image

Your txt file should be kept in your project folder.

5

we have different invoke vba function i think…
this is my invoke vba screen. I am using StudioX
image

6

You see down below there’s a button for Add VBA Argument
you gotta use that and pass ranges from there.

1 Like
7

It prompts an error.

image
image969×227 7.93 KB

image

8

it prompts an error

9

Hello,

Can you provide us with a sample project ?

Regards,
Dragos.

10

TEST.zip (63.3 KB)
hi please see attached file

11

Please reply i already attached my sample project