Hey @phani.gampala try to correct your file names & file locations per instructions below.
Right now, the way they are in your code & Excel file, it will not work as you can tell with testing.
----------------------------------------
Dim excelFilelocation As String
' (This should be where the Excel file is stored on your computer)
excelFilelocation = "L:\Phani\RC REPLACEMENT.xlsx"
Dim oExcelList As ArrayList
oExcelList = GoExcel.CellValues(excelFilelocation, "Sheet3", "A1", "A3")
----------------------------------------
----------------------------------------
' "C:\MY_WORKSPACE\" = Project Specified Working Folder.
' (L:\Phani\RC REPLACEMENT.xlsx\0092230.ipt (from Excel) will not be changed..... here's the issue)
' ()
' (If the file 0092230.ipt is stored in this folder C:\Users\phanig\Documents\Vault\ )
' (Then the Excel cell needs to contain C:\Users\phanig\Documents\Vault\0092230.ipt )
' (Then the below lines will change it to search in your Vault for Project Explorer/0092230.ipt )
Dim oTemplateVaultPath As String = oFileName.Replace("C:\Users\phanig\Documents\Vault\", "$/")
oTemplateVaultPath = oTemplateVaultPath.Replace("\", "/")
Dim oVaultPaths() As String = New String() {oTemplateVaultPath}
----------------------------------------
If this solved your problem or answered your question, please click ACCEPT SOLUTION.
If this helped you, please click LIKE.
