VBA - Copy data to .txt document

[BigLRIP]

Hi all,

I have a sheet with data in column A.

I would like to use VBA to
1) Open a new, unnamed text document
2) Copy and paste the data into text document
3) Close and save the text document as "name.xml"

Is this possible?

Thanks.

 

[jvanbonn]

By no means am I the right person to answer this, but here is something I was playing with...

Sub testCreateAFile()

Set fs = CreateObject("Scripting.FileSystemObject")
Set A = fs.CreateTextFile("c:\testfile.txt", True)
A.WriteLine ("This is a test.")
A.Close

'MsgBox fs.filexists("c:\testfile.txt")
End Sub

 

[VoG]

Try

Sub CreateXMLFile()
ActiveSheet.Copy
ActiveWorkbook.SaveAs Filename:="C:\name.XML", FileFormat:=xlXMLSpreadsheet
ActiveWorkbook.Close False
End Sub