Ok, I've been staring at that for ages and my logic has vanished... I re wrote it to this the below.... Only problem is that I still don't get a valid response.. the array is of the form : [1] => Array ( [Name ] => Aberdeen [Status ] => Ready [Location ] => [Jobs ] => 0 [Model ] => HPUniversalPrintingPCL6 [Comment ] => PRINT_EARL The correct number of "@" are retuned so it's performing the correct number of itterations, but no giving me the results... I should have mentioned that I'm completely new to PHP and am kinda winging it.... Start of code chunk $it = new RecursiveIteratorIterator( new RecursiveArrayIterator($server1)); echo ""; foreach ($it as $key=>$val) { echo "@"; if ($val == "PRINT_EARL") { echo ""; echo ""; echo ""; echo ""; } Else echo $key.":".$val."\n"; } End of code chunk -- Modified Monday, May 3, 2010 10:51 AM "; echo $key; echo " "; echo $val; echo "

Doh! thanks for that... I'll just get my coat.. TAXI!

LastWriteTime IS the "Last Modified Time" in NTFS. If you're talking about getting a time out of the metadata in the picture file itself, then these methods will do nothing for you. You need to get the properties out of the JPG. Google for "jpeg metadata vb.net[^]". A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 But no longer in 2009...

It's resolved now... I copied the entire Form1.vb and form1design.vb etc to notepad, created a new project and then pasted the code back into the new project.. This appears to have resolved the problem, I'm guessing that there must have been some residual "reference" somewhere which forced VB Express to require the above a pre-req, even tho they weren't utilised in the code... thanks for you thoughts anyway...

Good :) Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

To be perfectly honest, creating excel sheets using interop is an absolute development nightmare. For one, if the user does not have excel installed, your application will not work. The error you described is one of many similar ones I have seen when I tried to do it with interop (that's what is throwing the error). The problem is, the syntax changes with each different version of excel, so even if you finally get it to work, you can start over as soon as MickeySoft decides to market a new Office version. Personally, I have decided to cut my losses, and I have rebuilt the whole thing using xml. That means I basically build up an xml file in a string and in the end I save the string to an excel file. I can now create excel files containing autofilters, all kinds of formatting, frozen panes, and more, and the resulting file can be opened in any excel version from 97 to 2007. In other words, I warmly recommend using my approach, and saving yourself a big headache. My advice is free, and you may get what you paid for.

Hi there, Thats great, working fine now... Ta v much.....

Just because it might be easier for you to work with, take a look at this method. Drag a datagridview onto your form designer and put in the following code, change the table to see your different output. VS is very good at converting between XML and Datasets and vice-versa. If nothing else, the tables will help you visualize the structure of the XML, you can easily see from this sample that size is on a different 'level' than the rest of the data. Imports System.IO Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'load xml into a dataset to use here Dim dS As New DataSet Dim fS As FileStream 'open the xml file so we can use it to fill the dataset fS = New FileStream("C:\test\10g_2.xml", FileMode.Open) 'fill the dataset Try dS.ReadXml(fS) Catch ex As Exception MsgBox(ex) Finally fS.Close() End Try Me.DataGridView1.DataSource = dS.Tables(2) End Sub End Class

Well I got stuck on the recursion so got a script to tidy up the XML file so that it is reasonably well formed.. But now I have an issue getting one element out, <sizedata Size= "VALUE" IGNORE THE REST OF THEM/> here is a fully formed, but shortened XML file: <?xml version="1.0" encoding="UTF-8" standalone="no"?> <Root Type="TRoot"> <Date>15/10/2009 12:30:08</Date> <Folder fullpath="C:\" IsFilesNode="0"> <Name>C:\</Name> <SizeData Size="74609238013" Allocated="72396726232" Wasted="234062016" CDRom="74727184384" Files="116733" Folders="12272" Compression="3"/> </Folder> <Folder fullpath="C:\" IsFilesNode="-1"> <Name>[Files]</Name> <SizeData Size="18745407271" Allocated="18745561088" Wasted="153817" CDRom="18745475072" Files="69" Folders="0" Compression="1"/> </Folder> <Folder fullpath="C:\TEMP_\" IsFilesNode="0"> <Name>TEMP_ALAN</Name> <SizeData Size="15469174140" Allocated="15489126222" Wasted="19886724" CDRom="15478267904" Files="9570" Folders="1832" Compression="1"/> </Folder> <Folder fullpath="C:\TEMP_\mp3\" IsFilesNode="0"> <Name>mp3</Name> <SizeData Size="11504514137" Allocated="11513361814" Wasted="8829863" CDRom="11508457472" Files="4561" Folders="510" Compression="1"/> </Folder> </root> The code I have is below: <pre>Try                   Dim odoc As New System.Xml.XmlDocument                   odoc.Load("C:\test\test.xml")                   Dim oXmlLog As System.Xml.XmlElement                   Dim text As String = ""                   For Each oXmlLog In odoc.SelectNodes("Root")                         Dim node As System.Xml.XmlElement                         For Each node In oXmlLog.SelectNodes("Folder")                               Dim fullpath As String = node.Attributes.GetNamedItem("fullpath").Value