Hello,
I have been receiving error : “TypeConverter cannot convert from System.String” when I use vLookUp activity in StudioX. I have tried methods shown in YouTube or previously discussed in the forum, I still cannot resolve. Kindly assist. I will be posting my file and also what I had indicated in StudioX.
vlookup forU.xlsx (12.8 KB)
LookUp Data
Input and Output Data
Hi @leyin_meng
Check out the below workflow file. I Have use Macros code for VLookUp
NewBlankTask9.zip (277.3 KB)
Hope it meets your requirement.
Regards
Hi @Parvathy ,
Thank you for your help. It is working now. I will try to use this as base to customise my other vLookUp. I hope I can do it myself.
regards.
Since your query is resolved, please mark my post as solution to close the loop or if you have any questions I’m happy to help.
Happy Automation!!
I tried this. The error does not occur anymore, but it is not able to execute the vlookup to get the desired result.
Do you have any more requirements @leyin_meng . If yes, share the input file and what this requirement I will help you with VBA Macros.
Regards
Hello Parvathy and all,
I would like to place the lookup table in another workbook, perhaps named as ‘ABC’. (Meaning it can be in Sheet2, but is in another workbook) Could I get some help on how I should write the VBA code ? Can I still use the same project to run or do I also have to add another ‘Use Excel activity to open another workbook ?’ kindly assist.
Cos in the current code given by it is listed as per below :
Sub VLookupAndWriteNames()
Dim ws1 As Worksheet
Dim ws2 As Worksheet
Dim lookupRange As Range
Dim cell As Range
Dim result As Variant
' Set the worksheets
Set ws1 = ThisWorkbook.Sheets("Sheet1")
Set ws2 = ThisWorkbook.Sheets("Sheet2")
' Define the lookup range in Sheet2
Set lookupRange = ws2.Range("A:B")
Rather than doing VLookup for two workbooks copy paste the sheet present in second workbook t first workbook and run the macros for first workbook. This would be an preferable option. If possible send me inputs of both the excels I will help you out with workflow.
Regards
Hi Parvathy,
Thank you for helping my query. Perhaps, I can share a little of my project. The other issues which I am facing.
- I am using UiPath to go into explorer to run a web-based report. The name of the report takes the date and time which the report is generated. Meaning to say, it is not consistent name. I am not sure if UiPath can recognise part of the name of the report and amend it. But, this portion, I have not yet figured out how to do the change.
- I suppose, if system can recognise the name only then UiPath can copy the worksheet over to do the vLookUp.
- I am attaching an older file (named oldOTReport). Columns F to J are done using vLookUp. This is what I hope to be able to achieve with the report generated from web-based browser.
- In the past, when I perform this manually, I copied the formulas of the first few rows of the same columns from the older report to the newer report. Then I drag the formulas to the rest of the rows. But, I have no idea how I can copy the formulas from the older report to the newer one, so I tried to use vLookup. However, as there are many columns and rows (it can be as many as 1200 rows), this report will take very long to run using vlookup.
I will be attaching my sample files, hope that there is something that you can assist me to automate further here. Thank you.
This is the older report
oldOTReport.xls (199.5 KB)
This is the report generated from web
OTForMonthReport - 2024-02-05T222430.476.xls (153.5 KB)
The reference template
RefTableforOTReports.xlsx (21.4 KB)
If anything else is needed, please let me know. Thank you in advance.
1 Like
Will you be able to provide your project and the required output too. It will help me find out what to do.
Regards
I will provide you more info shortly
1 Like
ashokkarale
Yoichi
singh_sumit
sven.wullum1
adi.mehare
ppr
sonaliaggarwal47
shahidh.aqeel.shahul
Akash_Javalekar1
Sami_Rajput