Saving Notepad from VBA

**ricardodickstein** · 02-04-2009, 10:13 PM

Hello.

I am triyng to paste a range in a notepad and then save this notepad as an xml file

So far I have:

Please Login or Register  to view this content.

How can I now save this notepad as an XML file (for example: test.xml)

Thanks

**Leith Ross** · 02-04-2009, 11:04 PM

Hello ricardodickstein,

Welcome to the Forum!
To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
Select all the code text in your post.
In the Message window Toolbar click the # icon.
Or you can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

As a member, You have agreed to follow the forum posting rules. Please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

Forum Rules

**ricardodickstein** · 02-05-2009, 06:35 AM

OK, Leith.

Thanks for the tip

**royUK** · 02-05-2009, 07:14 AM

See Chip Pearson's code tips

**Kenneth Hobson** · 02-05-2009, 10:21 AM

Not sure what you are trying to accomplish. You can create an xml, which is just a text file using text file writing methods as Roy linked. However, some other parts are created for you when you SaveAs an xml file in Excel or MSWord.

So, why not just record a macro to open a new workbook, insert your data, and then do a SaveAs?

Always avoid Sendkeys when you can.

**cartotech81** · 11-06-2009, 11:01 AM

While XML is basically text, I have the problem of needing it saved as a .xml file for my interactive charts to read the data. Also when trying to save as an xml in excel it says I need to set up xml mapping.

**royUK** · 11-06-2009, 11:18 AM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.