MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Read VB code with VBA

  Asked By: Carlton    Date: Jan 21    Category: MS Office    Views: 2085

Sort of related to the previous post. (I wouldn't think VBA code can
be made .exe, at least directly)

As the result of a search, I sometines find some VB SW which may help
be do something I want to do, but I am unable to read, for example VB6
source. At least, of the packages I downloaded to look at, none of the
files had something I could tell was useful VB source (The author may
not have included the source)



3 Answers Found

Answer #1    Answered By: Phailin Jainukul     Answered On: Jan 21

This was actually a question.

Is there a way to read  / see VB cource code  using Excel VBA?

I have seen code on the net, but it was VB and when I downloaded  it,
there was nothing I could see that looked like VB source  code, so I
couldn't use it or look to see if it met my needs...

Answer #2    Answered By: Bonita Garcia     Answered On: Jan 21

What were the file extensions (you know, like .vb, .cls, .frm, etc.)?
Any chance you can cut and paste it? It all depends on how it was
downloaded and what files there were.
VB projects contain many files, unlike a single Excel file for VBA.
.VB, .CLS and .FRM files are the ones that mostly contain code, and they
correspond roughly to code  Modules, Class Modules, and UserForms.

Answer #3    Answered By: Elmer Young     Answered On: Jan 21

Unless VB has changed (not counting .NET) you can save VB code  as a .bas
file that will open in Office apps. It may not all work, due to using calls
to methods that are not available, but you should be able to open/view it
enough to modify for your app's object model and VBA changes.

Didn't find what you were looking for? Find more on Read VB code with VBA Or get search suggestion and latest updates.