Visual Basic 2008

[schnabs]

Hello
I am using Visual Basic 2008 and Quickooks SDK to interact with and pull data from Quickbooks. I don't know if anyone here is familiar with the QBSDK, but so far I have been able to successfully open QB, connect to it, request a report and have it returned. The report is in xml. Being new to VB and not that proficient yet, I'm running into a problem writing the response to an Excel worksheet. I also need to parse out the xml, but I'm more concerned with the former first. I won't post any code, as I feel that I'm hoping to get lucky with someone on here who is familiar with QBSDK. Any help would be greatly appreciated. If you'd like to see my code so far just ask.
Thanks!

 

[RiverGuy]

No I haven't used the Quickbooks SDK. However, as with most things in VB.Net, there are probably numerous ways to go about this.

The easiest method would be to save your XML text to a file, and then open up the file in Excel. Maybe you will get lucky and Excel will be able to parse the XML text as is.

You can also look at the XMLTextReader:

http://msdn.microsoft.com/en-us/library/system.xml.xmltextreader.read.aspx

You can also look at reading the XML into a DataSet with the DataSet.ReadXML method, creating a connection/dataadapter to Excel and then saving the DataSet out that way.

If your question is more about how to control Excel from within VB.Net, there are many tutorials and code snippets on the web. Here is one

http://support.microsoft.com/kb/219151/.