Microsoft Office Forums Need excel VBA to add xml tags

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-26-2018, 09:36 PM
ganesang ganesang is offline Need excel VBA to add xml tags Windows XP Need excel VBA to add xml tags Office 2016
Competent Performer
Need excel VBA to add xml tags
 
Join Date: Jul 2018
Posts: 127
ganesang is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Sample_data.xlsx (11.1 KB, 10 views)
Reply With Quote
  #2  
Old 12-28-2018, 07:36 PM
Kenneth Hobson Kenneth Hobson is offline Need excel VBA to add xml tags Windows 10 Need excel VBA to add xml tags Office 2016
Novice
 
Join Date: Jun 2018
Posts: 29
Kenneth Hobson is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


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
Need excel VBA to add xml tags For Moderator: Code tags? Ulodesk Forum Support 1 07-12-2011 07:54 AM


All times are GMT -7. The time now is 07:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft