SKIPPER Steph Houghton has urged England’s women to go one better than their male counterparts did 25 years ago at Italia 90. They are in a complex file hierarchy structure but I could move to a single file with time. Hi, I have loads of files like this (sample below) and I am trying to find a way of grabbing the ‘HeadLine’, ‘Author’ and ‘body’ tags values into a single Excel doc listing (a file per line). ‘FIND XML FILES ONLY IN SOURCE SUBFOLDERSįor Each MySubFolder In MySource.SubFolders Set nodeXM元 = xmlDoc.getElementsByTagName(“stpiece_per”) Set nodeXML2 = xmlDoc.getElementsByTagName(“year”) Set nodeXML1 = xmlDoc.getElementsByTagName(“dc:identifier”) XmlDoc.Load (mySourcePath & “” & myfile.Name) XmlDoc.SetProperty “SelectionLanguage”, “XPath” Set xmlDoc = CreateObject(“Microsoft.XMLDOM”) If Right(myfile.Name, 3) = “XML” Or Right(myfile.Name, 3) = “xml” Then Set MySource = MyObject.GetFolder(mySourcePath) Set MyObject = New Scripting.FileSystemObject Sub ListMyFiles(mySourcePath, IncludeSubfolders) Set ShellApplication = CreateObject(“Shell.Application”).BrowseForFolder(0, “Please choose a folder”, 0, OpenAt)
0 Comments
Leave a Reply. |