working with tables
 

Is there a site where I could find a list of the functions so I can work
with Excel?

I never programmed with VB and Excel before, but I usually find my way
out.(I programmed a bit in VB, but a long time ago and in Basic, even before
that. I have a good basis in C)
I intend my "programme" to search through a table and if the first cell of
the row meets a condition, then insert a row after the last one entered and
paste the information in the following cells of the row on that line in the
columns I want.
So.
1- can I look right into a table or must I copy the info into a variable
(which would be a table).
2- Can i programme all the actions I can do in Excel? Like inserting a row.
3- can i indicate a cell where I want a variable to print it's data.

Thank you

Marie

working with tables
 

Probably the best teacher is the macro recorder. Just
start recording a macro, do what you want to do, and take
a look at the code. This is how I started learning VBA
Programming in Excel. :) And from what I have read about
what you want to do, the macro recorder should be able to
give you everthing that you need.

Then about the only thing that you have to worry about is
how to incorporate variables into the statements since
obviously all of the statements in the auto generated
code are going to be hard coded values.

Anything you can do manually, you can find a way to do it
in VBA.

Also, highlighting a command and pressing F1 will bring
up the help for that command, and although Microsoft's
help is lacking in some of its applications, it is quite
good with VBA, complete with examples of most commands.

-----Original Message-----
Is there a site where I could find a list of the
functions so I can work
with Excel?

I never programmed with VB and Excel before, but I
usually find my way
out.(I programmed a bit in VB, but a long time ago and
in Basic, even before
that. I have a good basis in C)
I intend my "programme" to search through a table and if
the first cell of
the row meets a condition, then insert a row after the
last one entered and
paste the information in the following cells of the row
on that line in the
columns I want.
So.
1- can I look right into a table or must I copy the info
into a variable
(which would be a table).
2- Can i programme all the actions I can do in Excel?
Like inserting a row.
3- can i indicate a cell where I want a variable to
print it's data.

Thank you

Marie


.

working with tables
 

LOL, I was recording a macro where I insert a line to see the code, when I
decided to come see if I had an answer! ;-)
Thank you, I guess you're right, that will be the best way.

Now, I've just finished recording it, but I can't find where I can see the
code (My VB is open and it is not there as an object... normal? I'm not sure
where to look)

Marie

"Kris" a écrit dans le message de
...
Probably the best teacher is the macro recorder. Just
start recording a macro, do what you want to do, and take
a look at the code. This is how I started learning VBA
Programming in Excel. :) And from what I have read about
what you want to do, the macro recorder should be able to
give you everthing that you need.

Then about the only thing that you have to worry about is
how to incorporate variables into the statements since
obviously all of the statements in the auto generated
code are going to be hard coded values.

Anything you can do manually, you can find a way to do it
in VBA.

Also, highlighting a command and pressing F1 will bring
up the help for that command, and although Microsoft's
help is lacking in some of its applications, it is quite
good with VBA, complete with examples of most commands.

-----Original Message-----
Is there a site where I could find a list of the
functions so I can work
with Excel?

I never programmed with VB and Excel before, but I
usually find my way
out.(I programmed a bit in VB, but a long time ago and
in Basic, even before
that. I have a good basis in C)
I intend my "programme" to search through a table and if
the first cell of
the row meets a condition, then insert a row after the
last one entered and
paste the information in the following cells of the row
on that line in the
columns I want.
So.
1- can I look right into a table or must I copy the info
into a variable
(which would be a table).
2- Can i programme all the actions I can do in Excel?
Like inserting a row.
3- can i indicate a cell where I want a variable to
print it's data.

Thank you

Marie


.

working with tables
 

Assuming you selected "Store macro in this workbook"

Hit ALT+F11 and this will open the VBE (Visual Basic Editor)
Top left you will hopefully see an explorer style pane. Within this pane you
need to search for
your workbook's name, and when you find it you may need to click on the + to
expand it. Within
that you should see the following:-

VBAProject(Your_Filename)
Microsoft Excel Objects
Sheet1(Sheet1)
Sheet2(Sheet2)
Sheet3(Sheet3)
ThisWorkbook
Modules
Module1
Module2
etc etc (You likely just have just one of these though)

If you have named your sheets then those names will appear in the brackets above
as opposed to
what you see at the moment in my note.

Doubleclick on the Module1 bit to see the code stored within it. When done,
simply hit File / Close and return to Microsoft Excel and save the file.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Marie Lavoie" wrote in message
...
LOL, I was recording a macro where I insert a line to see the code, when I
decided to come see if I had an answer! ;-)
Thank you, I guess you're right, that will be the best way.

Now, I've just finished recording it, but I can't find where I can see the
code (My VB is open and it is not there as an object... normal? I'm not sure
where to look)

Marie

"Kris" a écrit dans le message de
...
Probably the best teacher is the macro recorder. Just
start recording a macro, do what you want to do, and take
a look at the code. This is how I started learning VBA
Programming in Excel. :) And from what I have read about
what you want to do, the macro recorder should be able to
give you everthing that you need.

Then about the only thing that you have to worry about is
how to incorporate variables into the statements since
obviously all of the statements in the auto generated
code are going to be hard coded values.

Anything you can do manually, you can find a way to do it
in VBA.

Also, highlighting a command and pressing F1 will bring
up the help for that command, and although Microsoft's
help is lacking in some of its applications, it is quite
good with VBA, complete with examples of most commands.

-----Original Message-----
Is there a site where I could find a list of the
functions so I can work
with Excel?

I never programmed with VB and Excel before, but I
usually find my way
out.(I programmed a bit in VB, but a long time ago and
in Basic, even before
that. I have a good basis in C)
I intend my "programme" to search through a table and if
the first cell of
the row meets a condition, then insert a row after the
last one entered and
paste the information in the following cells of the row
on that line in the
columns I want.
So.
1- can I look right into a table or must I copy the info
into a variable
(which would be a table).
2- Can i programme all the actions I can do in Excel?
Like inserting a row.
3- can i indicate a cell where I want a variable to
print it's data.

Thank you

Marie


.





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.686 / Virus Database: 447 - Release Date: 14/05/2004

working with tables
 

Marie,

Now, I've just finished recording it, but I can't find where I can see the
code (My VB is open and it is not there as an object... normal? I'm not sure
where to look)

In the VBA editor find Module1 in the Project Browser
- or -
in Excel ToolsMacroMacros, select your macro and click Edit

HTH
Anders Silven

working with tables
 

in xl go to tools-macro-vb editor
that will open vba
if you do not see the project - vbaproject window
go to view-project explorer
in that window you will see all xl workbooks opend
click on the plus sgin next to the one your recoreded the
macro in
if it is a - then you can already see the object folders
click on the modules +
if it is a - you can already see all the modules
double click on all the modules untill you find the one
that contains the code you recoreded

ya i dont care about spelling or grammer :)

-----Original Message-----
LOL, I was recording a macro where I insert a line to
see the code, when I
decided to come see if I had an answer! ;-)
Thank you, I guess you're right, that will be the best
way.

Now, I've just finished recording it, but I can't find
where I can see the
code (My VB is open and it is not there as an object...
normal? I'm not sure
where to look)

Marie

"Kris" a écrit
dans le message de
...
Probably the best teacher is the macro recorder. Just
start recording a macro, do what you want to do, and
take
a look at the code. This is how I started learning VBA
Programming in Excel. :) And from what I have read
about
what you want to do, the macro recorder should be able
to
give you everthing that you need.

Then about the only thing that you have to worry about
is
how to incorporate variables into the statements since
obviously all of the statements in the auto generated
code are going to be hard coded values.

Anything you can do manually, you can find a way to do
it
in VBA.

Also, highlighting a command and pressing F1 will bring
up the help for that command, and although Microsoft's
help is lacking in some of its applications, it is
quite
good with VBA, complete with examples of most commands.

-----Original Message-----
Is there a site where I could find a list of the
functions so I can work
with Excel?

I never programmed with VB and Excel before, but I
usually find my way
out.(I programmed a bit in VB, but a long time ago and
in Basic, even before
that. I have a good basis in C)
I intend my "programme" to search through a table and
if
the first cell of
the row meets a condition, then insert a row after the
last one entered and
paste the information in the following cells of the
row
on that line in the
columns I want.
So.
1- can I look right into a table or must I copy the
info
into a variable
(which would be a table).
2- Can i programme all the actions I can do in Excel?
Like inserting a row.
3- can i indicate a cell where I want a variable to
print it's data.

Thank you

Marie


.



.