So you just want to insert a row and put some text in A2?

If so then:

Rows(2).Insert
Range("A2").Value = "<?xml-stylesheet type=""text/xsl""
href=""2simplesamples.xsl""?"


--
Jim
"scantor145" wrote
in message ...
|
| Excel 2002 with Visual Basic 6.3
|
| I have an XML file, which I'll call 2SimpleSamples.xml
|
| <?xml version="1.0"?
| <NewDataSet
| <Measurements
| <Index0</Index
| <Pos1</Pos
| <ChemNumber7</ChemNumber
| <ReadNumber1</ReadNumber
| <Repeats0</Repeats
| <FilterNumber1</FilterNumber
| <Signal193075</Signal
| <Reference76668</Reference
| <TimeStamp1255</TimeStamp
| </Measurements
| <Measurements
| <Index1</Index
| <Pos1</Pos
| <ChemNumber7</ChemNumber
| <ReadNumber2</ReadNumber
| <Repeats0</Repeats
| <FilterNumber1</FilterNumber
| <Signal191867</Signal
| <Reference76204</Reference
| <TimeStamp1496</TimeStamp
| </Measurements
| </NewDataSet
|
| In a macro I have commands to select the xml file:
|
|
|
| Code:
| --------------------
| FilterList = "XML Files(*.xml),*.xml" 'Type of file to open
|
|
| With Application
| MyFileMod = .GetOpenFilename(filefilter:=FilterList)
| End With
| --------------------
|
| In order to format the data in a prescribed way in Excel, I have
| another file called 2SimpleSamples.xsl which is a style sheet
| associated with the file 2Simplesamples.xml. Actually, inserting the
| following line between <?xml version="1.0"? and <NewDataSet in the
| xml file above makes the association:
|
| <?xml-stylesheet type="text/xsl" href="2simplesamples.xsl"?
|
| In my macro, after I open the xml file I need to insert(write) the
| above line into the xml file. Is it possible, and if so, how?
|
| Thanks
|
|
| --
| scantor145
| ------------------------------------------------------------------------
| scantor145's Profile:
http://www.excelforum.com/member.php...o&userid=14766
| View this thread: http://www.excelforum.com/showthread...hreadid=383308
|