Advantages of VB over VBA?

[Err]

If you were making the argument to a guy who's position it was to say no to requests to install visual basic -How would you make a case for having Visual Basic installed?

The reason I'm asking is that I'm not sure if there are some limits on VBA that are not there on VB.

Right now my argument is that certain people need to access my programs who do not know anything about "allowing" macros on their machines. What else should I say?

 

[Norie]

Why would these people need VB?

What limits are you referring to?

 

[Err]

"These people" is me. I want it because generally having more tools in my toolbox is better than having fewer. We have a site license but the IT company is third party -so they try to restrict people infringing on what they consider "their territory". I already infringe on their territory... In fact my entire job is one big infringement.

I just need to justify getting VB installed to the third party IT company. I need to justify it well enough that I can make a case to my manager when they say "no".

The limits that I am referring to are unknown limits. It is assumed that VB is more than just a stand alone compiler for VBA. I don't have it so I don't know.

 

[Norie]

Sorry I don't understand.

You seem to be saying that there are limits but then you say they're unknown.

Any chance of an example of something you think you can't do in VBA but can in VB?

If you could give an example that could probably be a step towards convincing the IT folk to install VB for you.

 

[Err]

NO! I'm saying that I don't know. There is a difference between not knowing something and something being unknown.

I'm not sure if there are some limits on VBA that are not there on VB

Surely -you are joking.

 

[Norie]

No I'm not joking, I'm trying to see where you are coming from.

I use both VB and VBA.

I know some of the limitations of both, not all obviously.

If I was an IT person I would be looking for concrete examples.

For example I can do X in VB but I can't do it in VBA, therefore it would greatly help me if I had access to VB.

One of the first limitation that pops into my mind is that you can use control arrays in VB but that limitation can be overcome in VBA using various methods and workarounds.

 

[Err]

I did notice in VBA that there is a size limitation to a subroutine. Is this limitation still there in VB?

 

[Norie]

Err

I honestly don't know if there is such a limitation in VB, but I could be wrong.

In VBA I think there is a limit but whenever I see code that breaks that limit then the code could probably be refined in some way.

 

[Err]

I bumped into the limit once and in fact -it could be refined. However -it is easy to imagine a situation where it could not be refined. Also, since hard coding is always easier -it's nice to consider a situation where we can have the answer to a problem SOONER rather than later.

 

[Norie]

Err

What you have asked is a very broad question and I apologize if I'm not giving you succint answers.

But I'm only posting a few ideas/opinions.

PS Hard coding is easier?