Make your office life easier with simple and fast Excel VBA solutions.
This is the third and the last part from the XML trilogy. Be sure You didn’t miss how to convert XML into Excel and how to overwrite XML file without copying or converting. In this article I’m going to show You how to create XML file from scratch.
In recent post I talked about converting XML data to Excel table. But what should You do to just overwrite data in XML file, without converting or copying it into Excel?
When I was young I thought, that if You want to send table data You use Excel. Now I know that there are tons of ways of transferring data. One of them is XML. In today’s article I will show You an easy way to convert XML into more user friendly Excel.
I’d like to invite You to my first ever YouTube tutorial video, which is about list separator in conditional formatting. Watch it here or go to my channel.
Enjoy the video, leave a like and subscribe!
Tired of opening every single file just to remind yourself what is all about? If You want to learn how to create image or PDF preview in Excel, jump in and You won’t regret this.
Have You already noticed, that row height unit is not the same as column’s width? If yes and You’re curious what is the unit of Excel column width read more to find out!
