Search results for query: *

Thank you very much for this. This has given me a real head start. I will play around with this. I am used to asp but am new to .net. A quick look at your code gives me some confidence. I will get back to you after trying this Thanks once again ip

Hi Jason Thanks for your reply. Actually I am new to .net Can you give me an example of what you mean by read each xml file into xmlreader? ip

Hi again I have this code in C# which I got off the web that exactly does what I want but this reads only one XML file. If someone can suggest me some modifications to this code so that it can read all the XML files in a directory and append to the same excel file it would be so much helpful...

I have a number of XML files in a directory with the same format. I would like to display these files in a readable format either in html or excel (preferable). I tried importing in Excel 2003 using the standard Data -- XML -- Import menu. But with this I am having problems with importing...

Hi Chris Thanks for your reply and your offer. I donot know how to use Perl. I know ASP. What are the requirements for using Perl? What is the WebServer used? How do I view a Perl file? Lot of questions. If it is easy to use then I would love to try your script. Thanks ip

Hi Bong Thanks for your reply. The XMLMAP "MyFields_Map" I have defined that manually by adding the XML file and then wrote the vba programe. I am not sure whether this action will this save the XmlMap. How do I define the XMLMap any idea? Regards Priya

Hi Everyone I have tried to write a macro that imports XML documents in a specific directory into Excel 2003. The file search part is being handled correctly. But the import of XML part is where it errors out. The error is "Object Required" Here is the code that I have written. Sub...

I have a number of XML files in a directory with the same format. I would like to display these files in a readable format either in html or excel. I tried importing in Excel 2003 using the standard Data -- XML -- Import menu. But with this I am having problems with importing multiple xml...

Hi there Did you get a solution for this?

Thanks for your prompt reply. That worked. But now it is giving a XML Map beign different error. That may be an issue to be raised in the XMl forum. Thanks and you again get a star from me.

I have done some research and got this far. Now I get an error at Set filenam=File.Name the error is 'Type mismatch' Sub XMLimport() Dim fs As FileSearch, i As Long, filePath As Variant, filenam As Variant, fsObject As Variant, file As Variant Dim wsh As Worksheet Set fs =...

Hi Gurus I have recorded a macro to import xml files into excel 2003. Importing one file is achieved through this. What I need is a macro that will loop through all the xml files in the directory specified and import data into excel and append the results. All these xml files have the same...

Hi everyone I have a table comments with 4 fields in them. When I first designed the table I have set two fields 'issues' and 'comments' as varchar data types. But as I got the data into the table, the data is much more that 8000 characters. So I have changed the data types to text. I have...

Hi everyone I have a table comments with 4 fields in them. When I first designed the table I have set two fields 'issues' and 'comments' as varchar data types. But as I got the data into the table, the data is much more that 8000 characters. So I have changed the data types to text. I have...

Hi PH That was the exact solution I was looking for. Thanks again. Here goes another star for you. Regards ip

Hi guys I have solved my problem by changing the code in this way. Do While Len(Trim(ActiveCell.value)) <> 0 oElective = ActiveCell.value Worksheets("Summary").Select lrow = ActiveCell.SpecialCells(xlLastCell).Row With...

Hi there Thanks very much for all your replies. I think I have found out why my code is not working. It is because it is not going into the second Do Loop. i.e., Do While ActiveCell.value <> oElective And ActiveCell.Row <= lrow Does anyone know why? or is there any other condition that I...

I have the following code which finds one occurence of a value. But what I need to be able to do is to find all occurences of a particular value. Do While Len(Trim(activecell.value)) <> 0 oElective = activecell.value Worksheets("Trainee Summary").Select lrow...

PHV you are a star! Wonderful. That works perfectly. I have learnt a lot today. I am giving you two stars. Thanks once again ip

Hi PHV Thanks for your ammended code. It works fine. But what I am getting is a copy of all the formulae and formats. But I donot want to copy formulas as each cell has formulae and this is increasing the size of the new workbook. Is there a way to copy the formats and values but not the...