Search results for query: *

Hey All, I have some VBA code in Word that opens Excel and puts values into a bunch of cells on several Worksheets, but only one workbook. Then when my code finishes I find that the Excel process is still running in the task manager. I thought I had used to proper code to close it properly but...

Hey All, So I have a bunch of XML nodes that look like this: <TREND_VALUE DATE_TIME="20100729101005" MIN_VALUE="-12" AVG_VALUE="0" MAX_VALUE="0" VALID="TRUE" /> <TREND_VALUE DATE_TIME="20100729102005" MIN_VALUE="-24" AVG_VALUE="-12"...

Hey, So I'm opening XML files in Word and using VBA to extract data from certain XML nodes using DOM. My Code looks like this: Sub Extract() Dim xmlDoc As MSXML2.DOMDocument Set xmlDoc = New MSXML2.DOMDocument Dim nodeList As MSXML2.IXMLDOMNodeList Dim str As String...

Hey all, I have a string in Word that I have Parsed using the Split() function and now want to export each element of the array into Excel so that all of the elements are in the same collumn but the rows get incremented with a single element in each row. For example, Dim str as String str =...

I am opening XML files in Word and am trying to extract certain fields from the huge XML file so that I only have the portions of it that I need. When I open the XML file in word it sees the fields (ex "<customer>" and "</customer") as a "tag". How can I use VBA to reference those tags so that I...

Hey, so I'm new to VBA and need some help coding. I am trying to use Microsoft Word to open .xml files with data in them and use VBA to extract the data from the fields that I need. For example, when I open the XML files in Word, I would have: <information> <client> <name>Jim</name>...