Click here to Skip to main content
15,895,962 members

Comments by SMerrill88 (Top 2 by date)

SMerrill88 20-Jan-14 14:58pm View    
Geo:

First, you need to think about architecture. I have three ideas:
(1) Host in Excel VBA. For example, paste the stuff into a blank sheet and run a parsing macro on it. The problem you may encounter is that you have multiple users for the same piece of VBA, which can be a maintenance pain, unless it is distributed as an Excel Add-In.

(2) Host in a standalone exe. If you just want the learning experience of using VB.NET, then consider where you are going to host your VB Windows Form into which the user pastes his stuff. If it is a standalone program (e.g. Parser.exe), then Parser will need to use Excel Interop to talk to Excel. It's not hard, but it is very similar to just writing it in VBA in the first place.

(3) Host it in an Excel Add-In, written in VB.NET. This is harder, but cool.

Let us know how you want to do this.
SMerrill88 20-Jan-14 14:17pm View    
please ask DevComponents for support. http://www.devcomponents.com/support.aspx