Get file size

uiautomation
activities

#1

I have a process that runs an Excel macro in different files.

The process works well except that in some cases the excel file is considerably large and the macro takes longer than expected. This causes the process to break as the process continuous before the Excel macro is completed.

I’m thinking that maybe capturing the file size I can add a condition where if the file is a certain size then I will add a time delay and resolve the problem.

What activity I can use to capture the file size?

Thanks


#2

I do not think their is any activity available but to compute a file size you can do this:

Regards…!!
Aksh


#3

How do you set the variable as long? I tried LongType but it didn’t work. Which is the right one:


#4

Hey @selrac

long is the same as Int64 so search “System.Int64”.

Regards…!!
Aksh


#5

Fantastic, all sorted now

Thanks


#6

I would suggest to try “Long Path Tool” program.