Invoke VBA with stranger characters

I have this vb for a filter, and i can’t execute because the invoke vba insert a stranger characters

Sub FilterPromo()
ActiveSheet.Range("$A$1:$L$90").AutoFilter Field:=1, Criteria1:= _
“=DESCONTO ESTAÇÃO”, Operator:=xlOr, Criteria2:="=DESCONTO TOTAL"
End Sub

and always i use invoke vba a receive this output

Sub FilterPromo()
ActiveSheet.Range("$A$1:$L$90").AutoFilter Field:=1, Criteria1:= _
“=DESCONTO ESTAÇÃO”, Operator:=xlOr, Criteria2:="=DESCONTO TOTAL"
End Sub

The invoke vba insert this characters “” in the first line and don’t recognize utf8.

can you share your file and workflow?
what is your file type of vba code?

Promo.zip (95.2 KB)

follow the files and flowchart

try this file for invoke vba
FilterPromo.txt (170 Bytes)

Didn’t work

I keep getting the error message:

Invoke VBA: Unable to run ‘FilterPromo’ macro. It may not be available in this workbook or all macros are disabled

But my macro is enabled in excel, and in scope excel the read only option is off

And the macro still with this characters " *" in the first line

I just left my ofc…
I will share you my workflow tom…

Teste.zip (86.8 KB)

This works, but I upgraded and created another macro and works well

Thats Great!

Cheers

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.