Search results

Hi Marc, My XML contains 1000 tags a minimum.. so i cannot use search and replace if i want to replace 100 tags.. that is why i was looking for some code which can do so. Thanks!

Hi - I have a XML file and have to replace some node values of the XML. After the values are replaced have to save it back into XML format. Appreciate your help in this..This is how my XML looks like. <CHCOMMST_REC> <CHCOMMST_KEY_AREA> <KEY_DIKY_CLM_SYS_ID>COSM</KEY_DIKY_CLM_SYS_ID>...

Hey Marc, Thanks its working and i also tried the below formula which also worked. =MID(A3,FIND("DIKY_CAE_CLM_ID",A3)+16,FIND("DIKY_CAE_CLM_ID",RIGHT(A3,LEN(A3)-FIND("DIKY_CAE_CLM_ID",A3)))-18) Pls mark this post as solved. :)

Hi, I am looking for a formula which gives me the XML tag value. I have a XML as below in a cell (3,A) of attached sheet now i have to find <DIKY_CAE_CLM_ID> tag from this cell and get its corresponding value '1008001438' and display it in cell (3,B). <DIKY_CLM_SYS_ID>COSM</DIKY_CLM_SYS_ID>...

I have used OFFSET() and it worked perfectly. Thanks Luke and Jeffrey.. :) Can someone mark this a solved.

I have two rows (1&2) of col A in which row1 has three possible values which user will select using drop down. Based on the value selected by user in row1, row2 should be displayed with its corresponding values. Example: Row1 has three possible values Apple, Orange, Banana Row2 can have Boy...

I have tried using Replace as below Cells(index1, arrayval).Value = Replace(Cells(index1, arrayval).Value, " ", "") but it is throwing me Runtime error 6: Overflow.

Hey guys, I was trying to extract data from Mainframe Db2 using VB and have some issue in the way it is pulling data. This is the query im using: SQLSelectStatement = "SELECT" & " " & strColumnD & " " & " " & "FROM" & " " & strdb & strtable & " " & "WHERE " & "INVN_CTL_NBR= " & "'" &...

I want to take the fields of COLA of Sheet2 and do a lookup on COLA of Sheet1 and if i find it twice in COLA of sheet1 i want to capture the corresponding COLB value of Sheet1 and place it in COLB of sheet2. If i find the field twice in COLA of shee1 i have to display both the corresponding...

Hey Nebu, I am not able to attach the file again.. So please refer to the old file that i have attached and in that 'FV Fields' refer to COLA of Sheet2 and 'I/P Value1' refer to COLB of sheet2.

I am attaching the updated sheet here. I want to take the fields of COLA of Sheet2 and do a lookup on COLA of Sheet1 and if i find it twice in COLA of sheet1 i want to capture the corresponding COLB value of Sheet1 and place it in COLB of sheet2. If i find the field twice in COLA of shee1 i have...

Hi.. I have uploaded a sample file, the fields on colA of Sheet2 gets repeated so i have to capture all related COLB values and not a single time so i cannot use lookup.

Hey, I am new to the macros and was trying to come up with a compare macro and looking for help... I have a workbook with two sheets and i have to compare COLA of Sheet1 to COLA of sheet 2 and capture the corresponding value in COLB of Sheet2 and display it in COLB of Sheet1. Looking for some...

Yes rst is initialised. Dim rst As New ADODB.Recordset Nope i got this piece of code from some website and i have tried to incorporate into my code.

I am trying to display the results of a query into a worksheet using the below code, but it is throwing Run-time error:'13' Type Mismatch error. Worksheets("QueryInDB").Select Range("D6").Select Do Until ActiveCell = "" ActiveCell.Offset(1).Select Loop Range("D6", ActiveCell.Offset(-1...

Thanks Colin, It worked :)

I am working on database querying, and heres is what i need sSQL = "SELECT * from ABCD.EFGH_IJK where LMN in values from [A1-A10];" Can someone help me on how to get those values? and also i need the values to be placed in single quotes separated by a comma.