Export xml macro

Hello

I need macro code for export xml data
my excel already mapped xml

export can be manually in this steps
1 - select B2
2 - right click
3 - xml
4- export
5.png

i want code to do this with one click,so what the code?

kindly add the code in this button

Please Login or Register  to view this content.

Have you tried using "Record Macro? .. I think this may help you

yes i tried, not working its only select the cell

So if you have cells already mapped to xmlmaps. Then code would be something like...

Please Login or Register  to view this content.

Unfortunately not working

also ur code seems its will export the file direct, i need to choose location from the window not in code , so code should press export and stop here
Attachment 632785

...i need to choose location from the window not in code

This was not indicated in initial post.

This will do the job then.

Please Login or Register  to view this content.

Expand on "not working".

Administrative Note:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.

Thanks and sorry , i was think if i quote the messages, the second person will be noticed, noted thx

Then separate out Application.GetSaveAsFileName from code line and perform check.

Something like...

Please Login or Register  to view this content.

@ e97h

Thanks for the rep.
If your issue is resolved, please mark the thread as solved by using thread tools found at top of your initial post.