I need to copy from one excel & paste in another excel full of hyperlinks - Hyperlinks need to be there

[Raks_K]

I am using read & write workbook.

Am i doing it wrong way, can someone help.

[lrtetala (Lakshman Reddy)]

Hi @Raks_K

Try with Excel activities

Regards,

[Parvathy (PS Parvathy)]

Hi @Raks_K

What are you exactly trying to do with process? can you specify

If you want the hyperlinks to be present in excel then Excel activities would be preferred. If you have large amount of data then Macros will be preferred @Raks_K please specify what are you trying to do.

Regards

[Raks_K]

So there is a 103 tabs sheet with a summary & summary has tab links.

I am copying data from one excel & pasting in another excel by giving sheet names & where to paste value.

Hope it is clear

whenever I want it to write range in the other excel WB it throws this error:

[Parvathy (PS Parvathy)]

Hi @Raks_K

I think you can do the same with Excel activities rather than workbook activities, so you don’t face that error.
If possible can you share the excel file i can help you with flow.

Regards

[Raks_K]

I am sorry I cannot share the excel file Can you show with dummy data.

[Parvathy (PS Parvathy)]

Hi @Raks_K

May be give me an excel file with dummy data how your original excel looks like and expected output. I can help you.

Regards

[lrtetala (Lakshman Reddy)]

Hi @Raks_K

Simply you can try like below

Cheers!!

[Raks_K]

Thanks but it needs to start pasting from B15 cell any idea on that.

[lrtetala (Lakshman Reddy)]

@Raks_K

OutputExcel.Sheet("Sheet1").Range("B15")

[Parvathy (PS Parvathy)]

Hi @Raks_K

May be you could replicate the flow like below:

Regards

[lrtetala (Lakshman Reddy)]

@Raks_K

Hope you got the solution for your question. If yes please mark it as solution to close the loop else happy to help.

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

Regards,

[Raks_K]

Thanks for this mate.

I have similar 7 to 8 tabs to update, if i want file to keep open both input & output so it updates smoothly & quickly.

Do I add 7 or 8 sequences under flowchart or just below the one where you send a screenshot?

[Parvathy (PS Parvathy)]

Hi @Raks_K

Are you copying data from 7 different excels and pasting it in 7 different excels. Please specify. Do you have multiple sheets across the single excel.

Regards

[lrtetala (Lakshman Reddy)]

@Raks_K

If you want to copy all sheets then try like below

[lrtetala (Lakshman Reddy)]

@Raks_K

If you want particular sheets then try like below