Open a Xlsx Excel and run certain macro

Help
, ,
1

Hello Guys :slight_smile:

I want to open a certain xlsx file and then run a certain makro in that opened file.
What activity do I use and how?

Thanks :slight_smile:

2

Hi @SSchmitz,

use Excel Application Scope activity, and Execute Macro in it:

image

1 Like
3

Thanks! Now I need to enter the last months ultimo and todays date. Whats the way to get those values?

4

@SSchmitz,
Do you want to colect the date from this table?

The date today can be used as a variable:

today = Today.ToString("yyyy-MM-dd")

1 Like
5

I need to enter the last months ultimo and then then hit OK. After that the file which includes the “Dateiname” as Filename and is found in Path (“Pfad”) has to be send to a certain mail adress.

6

Prompt_WB
Prompt_WB704Ă—217 4.8 KB

@Adrian_Star

7

@SSchmitz
You can use something like this:

Variables:
now (variable type: DateTime)
whichDay (variable type: Int32)
newDate (variable type: DateTime)

Logic
now = DateTime.Now
whichDay = now.Day

newDate = now.AddDays(-whichDay)

Function explanation
DateTime.Now shows today’s date
.Day shows you which day it is
.AddDays(1) adds the number of days = 1
.AddDays(-1) subtracts the number of days = 1

2 Likes
8

Great explantion. So you pretty much do: Date-Day from today. Thanks alot! Very helpfull!

1 Like
9

@SSchmitz,

This is the simplest method because logic is stitched in the UiPath Studio library.

image

1 Like
10

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