#1
|
|||
|
|||
Need excel VBA to add xml tags
Hi Guys,
I need the VBA code which helps to add the code for the cell value. Please see the example sheet attached here. Please note that there is no limit for "INPUT" values which is exceeded more than 50 occurrences with separated by comma. |
#2
|
|||
|
|||
Code:
'=ParseCDD(J5) Function ParseCDD(c As Range) As String Dim r As Range, a, i As Long a = Split(c, ",") For i = 0 To UBound(a) a(i) = "<categ no = " & """" & a(i) & """" & "/>" Next i ParseCDD = Join(a, vbNullString) End Function |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to copy texts from excel and paste in to the Notepad++ in between the particular tags | ganesang | Word VBA | 2 | 08-27-2018 02:05 AM |
Updating old Tags | caz46 | OneNote | 0 | 01-10-2017 04:19 AM |
Is there a way to remove ALL Tags from a notebook? | TheDm | OneNote | 0 | 08-25-2016 04:11 AM |
Exporting Custom tags to PDF | lervein | PowerPoint | 0 | 09-16-2014 08:55 AM |
For Moderator: Code tags? | Ulodesk | Forum Support | 1 | 07-12-2011 07:54 AM |