Best way to learn to programm with Excel

[BTNA]

Hi all,

I am looking for resources where I can quickly learn some basic
programming with Excel. If this is not the right group to ask this
question, please let me know. I am basically looking to create nice
reports out of a flat file with columns. I don't need it to be too
fancy but I need to be able to create nice columns with some nice
formatting. My flat file would look like:

header1;header2;header3
0;1;2
0;4;5
0;3;5

1;3;4
1;2;6
1;5;6
2;5;6

2;8;9

Header1 will alwys be either 0,1,2 and I would need to be able to sum
the second and third columns for each header1 and so on.

Can you point me to a good easy book and or web page resource where I
can learn to do this?

Thanks in advance,

BTNA

 

[Susan]

one of the best ways to learn to do what you want is..........

start a new, blank workbook
up in the toolbar, choose Tools, Macro, RecordNewMacro
save the macro in "this workbook"
then go thru the workbook & format everything the way you want it
column widths, coloring, putting in the formulas @ the top of the
headers: =sum(b2:b25) etc.
then stop the macro recorder
up in the toolbar, choose Tools, Macro, Visual Basic Editor
this will open up a new window, where the code you just recorded will
be written - look in Module1.
recording code is not the most efficient code, but it works & is good
to help you learn.

copy the entire code
open a new workbook
open the VB editor in the new workbook
paste the code in a new module (up in the top VB editor toolbar use
Insert, Module)
close the old workbook
VB editor toolbar = Run, Run Macro
look @ your new workbook - is it formatted the same way as the first
one?


susan

 

[Susan]

actually, btna, you don't even have to open a new workbook & paste the
code.
just insert a new worksheet
while on the NEW worksheet,
Tools, Macro, Macros
& choose the one you just recorded
the new worksheet will now be formatted the way you did the previous
one.
worked for me
hope this helps!
susan

 

[ilia]

What you didn't mention is whether or not you are already familiar
with object-oriented programming. If you are, this is the site you
want:

http://www.microsoft.com/downloads/details.aspx?familyid=2204a62e-4877-4563-8e83-4848dda796e4

Of course this is also available in help files.

One way to think of it is: anything you use in Excel is a programmable
object. Anything you do in Excel can be expressed as a series of
commands acting upon the objects, their methods and properties. Your
main goal is to learn some OOP techniques, and then learn the object
model, or those portions of it that are pertinent to you.