[Excel] convert code using Linq.XDocument in VB.net to MSXML in VBA
I wrote an XML parser in vb.net and it seems to work fine. It extracts data from an XML file and then produces a comma delimited text file. I then import the text file into excel using a macro. In trying to make it a single process, I thought about producing a .exe file from the vb.net code and then calling it using process.start() (or the like) in the macro. I also attempted to convert my vb.net code to VBA using the MSXML class but that got frustrating really fast.
Last edited by adrian1906; May 25th, 2012 at 09:37 PM.