Extract and Replace value in Excel Macro

Help
,
1

Hi,

I’m working on a robot that attempts to find an Excel Macro, extract the value (being a folder directory) and then replace it with a new value. I can locate the line I need to extract, But I do not know how I’m gonna replace the string.

RequiredFile
RequiredFile1440×446 27.7 KB

Using string manipulation, I’ve selected this value from the GetFullText activity. I just need to know how i’m gonna write into it, on that line again specifically, with the type into activity? I was thinking to use the Replace function to insert the new desried criteria.

Cheers for any help!

Tom

2

Buddy @TommyHudd

Welcome to UiPath Community buddy, thats really good question to start wih

In uipath we have an option called Execute macro, where we can pass any value to macro with parameter properties…

So for your case you can go for the same buddy

Cheers

3

I’ll give that a go - thank you!

Tom

4

Great…try and let know whether it works or not buddy @TommyHudd

Cheers

5

So I’ve indentified the Excel workbook and the macro name… now I just need to know to pass the parameter in, and on the correct line once again!

Tom

6

Great in macro the place where you want to pass this variable, mention like this just for example
Sub WrapText(Path As String)
FolderLocation = “” & Path).Select
…
…
…

And in studio execute macro activity pass the filepath variable in parameter like this buddy
{filepath}

Cheerss

7

is that working buddy

8

Couldn’t get it just yet - gonna keep trying a few things. Thanks for your help so far :slight_smile:

1 Like
9

No worries buddy, kindly let know if you face any issues…

Cheers keep going