Hi all,
I need to add all borders to my excel page. i can do it with start process and excel or with excel pplication scope. But i cannot do it.
I have try to do it as Alt+H+B+A shortcut but i have noticed that uipath cannot run Alt+H shortcut in excel. How can i do that?
@mazlumkacar
You can try using VBA Macro .
I have done using invoke vba activity.
Thanks!
but how may i do that? can you share your code?
Use the below code, copy and paste it in a notepad file.
Then use “Invoke VBA Activity”.
Sub Macro1()
Worksheets(“Sheet_name”).Range(" ").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.BorderAround ColorIndex:=1End Sub
thanks!
Have you enabled the macro settings in excel application?
can you share the screenshot of your Invoke activity?
Just check on " enable all macros" option or else your macro won’t run.
Thanks!
Is that yellow fill color mean this code is wrong ?
Hi this would actually work
Use small case of h b and a
The sequence will be like this
—use START PROCESS activity and pass the file path of excel as input which will bring the file to foreground
—then use send hot key activity without any selector chosen and use hot key as alt+h
—then another send hot key with key as b
And final hot key with key as a
Cheers @mazlumkacar
Yes you have to change the Sheetname you are having in the excel file with the specified range that you have to put border to.
Thanks!
i have just try to do it but it is getting error. Mayi would like to you write it for me? 
sheet name is “Sheet1”
range is all columns that has data.
Fine
The steps involved will be like this
—use START PROCESS activity and mention the file path of excel as input
—now this will bring the excel to foreground
—then use a SEND HOT KEY activity and mention the input as ctrl+g
—now use a TYPE INTO activity and mention the input as “A1”
—then use a SEND HOT KEY activity with key as ctrl+A
—now send hot key with key as alt+h
—another send hot key with key as “b”
—final send hot key with key as “a”
It worked when I tried to simulate
Cheers @mazlumkacar
Perfect solution. Thanks buddy. @Palaniyappan
Cheers @mazlumkacar
Hi all.
I knew it fixed by @palaniyappan . Here is an activity called “Set Border” to set border to the range or a cell.
Regards
Balamurugan.S
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
