Hey all, I’m trying to copy over data from one excel workbook to another, this works easily for the most part except my “Comments” column, which is displaying as a .txt file, but the more important information is the the hyper link
It pastes the data in the other excel workbook, but with no hyper link.
You are using read range right, open the properties of read range activity, find out the option called Read formatting, select the Raw value option in that dropdown.
Check the below image for better understanding,
Hope it helps!!
Yes thank you! This is probably the best solution.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
