Macro/Excel

Help Activities
,
1

Good morning guys,
I’m trying to solve a situation if someone can help me I’m grateful

           Follow the steps of the situation

           -Download Excel with information
           -Run macro according to the data contained
           -Access the data and enter the website according to the macro data
           

           If the macro is empty, I end automation.

           Is there a specific tool for the case or will I have to work in another way?
2

Hi,

As per your comments we have to check whether macros are enabled in the excel or not.

we can achieve this goal by using vb.net code. there is method in vb.net (workbook.HasVBProject) it returns boolean so if it returns true the excel has macros or false means the excel doesnot have macros in it.

Attaching work flow for your reference. i hope it would help your requirement.

InvokeCodeDemo.zip (2.3 KB)

1 Like
3

Hi,
it was clear helped me a lot thanks a lot for the support :clap: :clap: :clap:

1 Like
4

Your most welcome @Rntss23 . if you think it is resolved your problem. kindly mark it as solution so that it would help others. thanks.

5

all right
thank again

6

it is nice connecting with you. thanks.

7

:clap: :clap: :clap: :clap: :clap:

8

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