Need excel VBA to add xml tags

ganesang · #1 12-26-2018, 09:36 PM

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.

Kenneth Hobson · #2 12-28-2018, 07:36 PM

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