473,703 Members | 3,037 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Visual Basic for Applications

AK
I don't want any part of the previous discussion on Visual Basic
versus Visual Basic.Net.

My query is about using Visual Basic for Applications; and whether it
is better to use Visual Basic 6 or Visual Basic.Net as a springboard
for studying VBA.

I use Office 2000 and would like to use VBA as a tool to customize it.
I have zero programming experience.
I would like to read through and work on the examples of a beginners
books (Dummies/Idiots/Absolute begginers or whatever) on either Visual
Basic 6 or Visual Basic.Net before I delve into VBA itself.

Has MicroSoft indicated whether or not they are changing the
background of future versions of Office VBA from VB6 to VB.Net?
Jul 17 '05 #1
2 4231

"AK" <cw**@aol.com > wrote in message
news:db******** *************** ***@posting.goo gle.com...
My query is about using Visual Basic for Applications; and whether it
is better to use Visual Basic 6 or Visual Basic.Net as a springboard
for studying VBA.
VB6 is definitely the better springboard, but see the comment in the next
paragraph. The.NET 'thing' is called VB, but is really quite a different
language in many respects to 'classic' VB and certainly NOT relevant to VBA.

Why do you need to use VB as a springboard? - VBA works within a development
environment very similar to the VB one, except you can't create ActiveX
components or 'independent' executables.
Has MicroSoft indicated whether or not they are changing the
background of future versions of Office VBA from VB6 to VB.Net?


Not sure about this one, but I don't believe that Office 2003 has .full (if
any) NET functionality (not that I've heard of, anyway).

BTW, for questions relating to Office Object Model issues, you're probably
better off using msnews.microsof t.com newsgroups relevant to the MS products
you are using as the VBA host (eg, Word, Excel, etc.).

Good luck, and ask here if you have any further questions.

HTH

Rob.
Jul 17 '05 #2
If you don't have experience programming, don't bother with VB at all. It
will confuse you. Although many things are similar in VB there are a lot of
differences between VB and VBA. I program in both. In a LOT of cases
(especially in Excel) you can use the macro learn function as a springboard
to work with.

Here's a book that might help
http://www.target.com/gp/detail.html...sin=B0000BYQ4Z

Ken Getz is an instructor with AppDev and a MVP.

another option if you are going to do a LOT in VBA is the AppDev course
http://www.appdev.com/prodfamily.asp...ame=VBAProduct

I got it after programming for some time and learned some nifty stuff.

Of course the least expensive way is to start, use the help screens and post
to the newsgroups for help. I've always have great luck.

Sue

"AK" <cw**@aol.com > wrote in message
news:db******** *************** ***@posting.goo gle.com...
I don't want any part of the previous discussion on Visual Basic
versus Visual Basic.Net.

My query is about using Visual Basic for Applications; and whether it
is better to use Visual Basic 6 or Visual Basic.Net as a springboard
for studying VBA.

I use Office 2000 and would like to use VBA as a tool to customize it.
I have zero programming experience.
I would like to read through and work on the examples of a beginners
books (Dummies/Idiots/Absolute begginers or whatever) on either Visual
Basic 6 or Visual Basic.Net before I delve into VBA itself.

Has MicroSoft indicated whether or not they are changing the
background of future versions of Office VBA from VB6 to VB.Net?

Jul 17 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
7268
by: angelag | last post by:
I am currently taking a college course in Visual Basic.Net and I am a beginner. I bought Visual Studio.Net 2003 to do my homework at home. I built my first project and e-mailed it to myself at school. When I tried to open it in the lab, I got a message saying I couldn't open it because it was created with a newer version. Evidently the lab is using Visual Studio.Net 2002. My professor doesn't just want the executable file, he wants...
3
3830
by: Raja | last post by:
Dear Members, Has anyone used the Vector Draw (www.vdraw.com) Component in Visual Basic. I need to create an application to be able to draw the plan view of a building. Any help in this regard would be highly appreciated. Best Regards RSB
5
524
by: john | last post by:
I searched http://www.sellsbrothers.com. and could not find anything about this subject. How do I make C# User Controls Visible to Visual Basic 6.0 Applications? Thanks, John
8
2095
by: Zardax | last post by:
Hi !!! I need to know if there is compatibility between VB 6.0 and Visual Basic 2005 Express Everything I need is to compile the VB 6.0 code in Visual Basic 2005 Express without re-write the code. So If anyone has any idea about this...
4
6191
by: jeff | last post by:
We current a VS 2005 Professional license ... what does this Microsoft Visual Studio 2005 Tools for Applications offer that VS 2005 does not? Any help would be greatly appreciated. Thanks JEff.
97
5498
by: Master Programmer | last post by:
An friend insider told me that VB is to be killled off within 18 months. I guess this makes sence now that C# is here. I believe it and am actualy surprised they ever even included it in VS 2003 in the first place. Anyone else heard about this development? The Master
1
1665
by: FlyingBuckner | last post by:
All right be kind, this is my first question on a forum. I need help on selecting the right software to purchase. I have a database set up using Access, 6 users. It is split into Tables and Applications, no more then 65MB of data in the tables right now. I have 2 college courses in Visual Basic 6 and have written VBA code in Access and AutoCad. I work for a steel fabricator and the database is written to track material usage, purchase...
4
3096
by: Chris Asaipillai | last post by:
Hi there My compay has a number of Visual Basic 6 applications which are front endeed onto either SQL Server or Microsoft Access databases. Now we are in process of planning to re-write these applications into Visual Basic.Net. My managers main thought is that Visual Basic 6 is (or has!) stopped being supported by Microsoft.
8
2860
by: Chris Asaipillai | last post by:
Hi there I have some questions for those experienced Visual Basic 6 programmers out there who have made the transition from VB6 to Vb.net. How long did it take you to learn at least the basic elements of VB.net....so that you were confident to write a application from scratch. This wouldnt necessarily
0
8759
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
1
9017
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8963
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7872
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5922
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4433
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4687
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2453
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2069
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.