Comments by JRickey (Top 8 by date)

I came across one allusion to using (System.String()) instead of (Of System.String) as a way to circumvent the no-space restriction.

Thanks, Mehdi. Your suggestion led me to an MSDN article on ExcelWebServices that should help. I'm definitely getting into topics I haven't worked with before.

I'll look at converting the VB6 project since the first step of that is easy. Even if that goes rather smoothly I may rewrite/redesign/refactor the code to allow better testing and to better integrate patches and enhancements done over the years.

Even if you could convince me this is not a homework project (very unlikely), you will learn much from developing the code yourself. You may make mistakes in that code, in which case you post a question with the appropriate piece of code, describe the error you see and ask for help (and tag the question as homework). Besides, on the .Net platform my experience is in C#, not VB. I've broken the problem down into two parts that you can easily learn about on the web (collections, including how to remove one item from a collection; and recursive function done on the collection).

Make a strong effort on your side and I'll provide an additional hint for making the recursion more efficient.

Are you able to use regedit to change it? My Win7 Pro 64-bit has the key shown in the article.

If you want to change via code look at http://www.switchonthecode.com/tutorials/csharp-snippet-tutorial-editing-the-windows-registry and http://msdn.microsoft.com/en-us/library/windows/desktop/ms724878%28v=vs.85%29.aspx (sorry, I don't see how to make those as links). I'm not sure what access level you will need to change that key value.