View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Why use VB over VBA?

If you are developing applications that will use Excel, and you have no
other over-arching considerations (such as the security of your code), then
just use VBA within Excel. VB will be an overhead which, at first, you don't
need, but may migrate to later.

--
HTH

Bob Phillips

"Mark Stephens" wrote in message
...
I am a self taught excel programmer and am embarking on development of
software for mass worldwide distribtion. Is there any reason why i should
consider using VB (which I have never used) over VBA within excel. Seems

to
me excel can do everything I need and I understand that even if I were to
switch to VB my users will still have to have excel to use the program, so
is there any benefits in switching?

Sirry it's a pretty basi cquestion but there doesn't seem to be much info

on
google on the subject.

Thanks and regards, Mark Stephens