hi
i read text in an excel file as follows
so in the above example it looks for the words UNREALIZED LOSS - FVTPL_HFT_SEC (LONG) (59612102)Code:oRng = oWSSheet.Cells.Find("UNREALIZED LOSS - FVTPL_HFT_SEC (LONG) (59612102)", , _ Excel.XlFindLookIn.xlValues, Excel.XlLookAt.xlPart, _ Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, False) ' MsgBox("Value '" & oRng.Value & "' found at '" & oRng.Address) Me.unrealse = oRng.Offset(0, 5).Valu
but in one of the excel files the words are like this "UNREALIZED LOSS - FVTPL_HFT_SEC (LONG) (59612102)"
when i try to do the code as usual like the above code i get an error is there something i can put in my code to strip out the "" around the words


Reply With Quote
