VBA or VSTO?

[Legacy 340951]

Hello everyone,

I am new to this board, so I hope I haven't posted in the wrong forum.

It looks like I will be tasked with writing a new program, although the requirements are not complete yet. I will very soon have to start learning either VBA or VSTO. I'm not familiar with either. So far, this is the little that I know:

1. Accept data from an orcacle db via XML
2. Accept data from emails
3. Accept data from OnBase reports
4. Accept data from other excel spreadsheets
5. Need to be able to drill down to verify the accepted data, with time/date stamps
6. Tally up all data into one spreadsheet for daily count matching between OnBase and Excel spreadsheets, info from emails and XML
7. Keep a history, I’d guess in Access of the daily totals, and compare the daily, and monthly, quarterly, semi-annual and annually
8. Maybe as many as 10 users
9. The overall goals of this program are: 1. Compare daily numbers from OnBase and Excel to make sure they match. 2. Show an overview of the daily totals once they have been verified to match.

I know this isn't a lot of info, as this is in the early stages of thought here, but I wanted to start learning as soon as possible. I was hoping for some kind thoughts and insights as to which is better to start learning, either VBA or VSTO (or something else?). I wish I could offer better info, but it's unknown right now.

Thank you in advance

 

[Smitty]

Welcome to the Board!

I'd imagine most of what you want to do can be done with VBA.

I think the big question would be the number of users. If they need to be concurrent, and are inputting data then you might want to consider Access as your platform. You can always output data to Excel for reporting purposes. Depending on the amount of data you'll be dealing with, Power Pivot could also be an option.