Printable View
Hi All,
I am about to write a large project involving data manipulation on excel sheet in real time. Since I am a working with VB for a few years now, I prefer writing my app in VB and not in VBA but I have my doubts...
Can you tell me the pros and cons for doing it in VB/VBA ?
Thanks !
It all depends...........
The VB version will remain on the computer, where you have installed it. If you use the VBA version, the code will go with the Excel-file.
So you have to decide on what you want to do with the EXCEL-file. (BTW their are ways to have the VBA code in an EXCEL-file, that does not hold the data)
If I would have been using VB for some time, I'd stick to VB. But I think the job could be done both ways.
If the code will goes with the Excel file the user may run into
issues if they are not allowed to run macros at the company.
If you are more comfortable with VB and you are not as fluent in
VBA then I say use VB. Either way you can use either one, but it
all comes down to deadlines and budgets. So if that is what you
are looking at then VB would make more business sense.