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

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/d...3-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.


On Apr 27, 2:47 pm, BTNA wrote:
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