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

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


On Apr 27, 2:47 pm, BTNA <beaville...@comcast.net> 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

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



On Apr 27, 3:47 pm, Susan <bogenex...@aol.com> wrote:
> 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
>
> On Apr 27, 2:47 pm, BTNA <beaville...@comcast.net> 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- Hide quoted text -
>
> - Show quoted text -

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 <beaville...@comcast.net> 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