Tutorials for Visual Basic Beginners

Click For Summary

Discussion Overview

The discussion revolves around finding resources for learning Visual Basic programming, particularly for applications in engineering and enhancing Excel usability. Participants share links and insights regarding Visual Basic and Visual Basic for Applications (VBA), as well as file types associated with Visual Basic projects.

Discussion Character

  • Exploratory
  • Technical explanation
  • Homework-related

Main Points Raised

  • One participant seeks online resources tailored for learning Visual Basic to improve Excel skills, noting a lack of satisfactory results from previous searches.
  • Another participant suggests that Visual Basic for Applications (VBA) might be the relevant area of interest and provides a link to a resource found via Google.
  • A participant shares additional resources and inquires about how to open specific file extensions related to Visual Basic projects, such as vbp, vbw, and frm files.
  • Another participant explains that these file types are text files, with the frm file containing form structure and associated VB code, while providing insights into the vbp and vbw files and their purposes.
  • It is noted that while VB and VBA share similar syntax, their applications differ, with VBA being limited to the environment of applications like Excel and Word.
  • A suggestion is made to download Visual Studio Express for learning VB, highlighting its inclusion of an IDE for program development.

Areas of Agreement / Disagreement

Participants generally agree on the distinction between Visual Basic and VBA, as well as the nature of the file types discussed. However, there is no consensus on the best resources for learning, as suggestions vary.

Contextual Notes

Some participants express uncertainty about the specific functions of the vbw file and the overall management of project files within the IDE.

Who May Find This Useful

This discussion may be useful for beginners in programming, particularly engineers looking to enhance their skills in Visual Basic or VBA for applications in Excel and other environments.

bugatti79
Messages
786
Reaction score
4
Hi Folks,

I have Google'd the above topic but I haven't found anything satisfactory. I am an engineer and I want to learn Visual basic programming (no programming experience) to enhance my excel usability.

Can you advise any good online sources that is geared towards science engineering?

Thanks
Bugatti
 
Technology news on Phys.org
They are all text files, so you can open them with any text editor. The most interesting of the lot is the frm file (the VB form), which contains the structure of the form that is displayed, as well as the VB code that executes when you interact with the form.

The vbp file seems to be some sort of configuration file, but I don't know what the vbw file is for.
 
Although VB and VBA have similar syntax, their usage is different. VBA cannot compile your code into a standalone executable program. It is only used within the target application environment, such as word or excel.

The vbp file is the visual basic project file. It contains the settings for you project, such as forms, modules and references. The vbw file is the visual basic project workspace file. It contains information about how you have your IDE setup. These files are used with VB, not VBA. You do not normally access them directly, the IDE manages them for you. If you're interested in learning VB, the first thing you should do is download the (free) VS Express from Microsoft. It contains the IDE you'll need to write your programs. The new 2012 version also has C# included, which I like because I use both. However, I do not like the look and style of the new version.
 
ok,

Thanks for this info!
 

Similar threads

  • · Replies 13 ·
Replies
13
Views
4K
  • · Replies 6 ·
Replies
6
Views
3K
  • · Replies 7 ·
Replies
7
Views
6K
Replies
8
Views
8K
  • · Replies 6 ·
Replies
6
Views
12K
Replies
11
Views
3K
  • · Replies 4 ·
Replies
4
Views
2K
  • Sticky
  • · Replies 13 ·
Replies
13
Views
8K
Replies
2
Views
3K
  • · Replies 8 ·
Replies
8
Views
3K