insight about excel programming needed

  • Thread starter Thread starter bala
  • Start date Start date
B

bala

hi excel gurus

am planning to learn excel programming using VBA preferrably. i am
with MS Access (VBA) and Visual Basic skillset. would appreciate if u
people can give me pointers as to what all topics/ areas that i have
to cover/learn inorder to start programming in ms excel using vba.
also would appreciate if u people can give me an insight as to what
type of application is being created in ms excel apart from reporting.
also is there is any sorta packaging (like in ms access and vb) in ms
excel.

thanx in advance and have a great weekend

regards
bala
 
Bala,

I'd start with printing the Excel Object Model
from VBA help and stick it to the wall next to my monitor.

Then I'd spend time to learn the ins and outs of cell referencing.
(Chip Pearson's site would be a good start)

By the time you realize that you aint got VB's clipboard and printer
objects.. you should be well versed to attack your first app.

Types of applications?
Everything under the moon...
From Invoicing to Production Scheduling, it's being done in Excel.

If you extend your thought from reporting to number crunching..
Any combination of text and numbers, calculus and layout.

The main advantage is: You'll have lots of potential users, that HAVE it
and who are comfortable with the interface. Exchanging data with other
progs is easy etc etc.

BUT:

From a developer pov : protection in excel is weak as in all office
apps. Your code is uncompiled and standard password breaking software
can/will be used to "review" your code.


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
hi buddy

thanx for the information, it is certainly helpful. take care, be safe
and have a great day. best of luck

bala
 
Back
Top