Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro programming in Excel
I'd like to get a recommended source of info (books,CD's, etc.) where I can
learn how to program macros in Excel. I know the embedded recording method, but I need to program spcial activities i.e. in a given table, move the cursor until a certain value is found and if so delete the row. Basically, I need to know the language syntax, the method of inserting and saving the macro, its availability for other spreadsheets, etc. Thanks -- CarlosD_LongIsland |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro programming in Excel
You have specific needs rather than just a learning situation, so I would
suggest that you record basic macros, try and amend, and post detailed questions (code and data as well) when you have a problem to this NG. You will soon improve, especially if you so some research of your own (using Help and the object browser). -- HTH RP (remove nothere from the email address if mailing direct) "CarlosD_LongIsland" wrote in message ... I'd like to get a recommended source of info (books,CD's, etc.) where I can learn how to program macros in Excel. I know the embedded recording method, but I need to program spcial activities i.e. in a given table, move the cursor until a certain value is found and if so delete the row. Basically, I need to know the language syntax, the method of inserting and saving the macro, its availability for other spreadsheets, etc. Thanks -- CarlosD_LongIsland |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro programming in Excel
A personal recommendation is John Walkenbach's "Excel 2002 Power Programming
with VBA" which comes with a CD full of practical examples. Combine this (or any other recommended book) with the encyclopaedic knowledge of the experts who support this NG - providing endless examples of both good code and good practice - and you can't go wrong! "CarlosD_LongIsland" wrote: I'd like to get a recommended source of info (books,CD's, etc.) where I can learn how to program macros in Excel. I know the embedded recording method, but I need to program spcial activities i.e. in a given table, move the cursor until a certain value is found and if so delete the row. Basically, I need to know the language syntax, the method of inserting and saving the macro, its availability for other spreadsheets, etc. Thanks -- CarlosD_LongIsland |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro programming in Excel
Thanks, Bob. You are correct in your assessment. However, I'd still like to
read a book that might contain the subject in a structured manner. I'll explain: in the 1-2-3 days, I had a great command of the Lotus macro language, from the syntax chapter in Lotus handbooks. Is there a similar book on Excel programming? "Bob Phillips" wrote: You have specific needs rather than just a learning situation, so I would suggest that you record basic macros, try and amend, and post detailed questions (code and data as well) when you have a problem to this NG. You will soon improve, especially if you so some research of your own (using Help and the object browser). -- HTH RP (remove nothere from the email address if mailing direct) "CarlosD_LongIsland" wrote in message ... I'd like to get a recommended source of info (books,CD's, etc.) where I can learn how to program macros in Excel. I know the embedded recording method, but I need to program spcial activities i.e. in a given table, move the cursor until a certain value is found and if so delete the row. Basically, I need to know the language syntax, the method of inserting and saving the macro, its availability for other spreadsheets, etc. Thanks -- CarlosD_LongIsland |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro programming in Excel
Well John Walkenbach does Excel VBA Programming For Dummies ISBN:
0-7645-7412-4 which is probably the best starter book. Once mastered, look at John Green's VBA 2002 Programmers Reference Manual (avoid the 2003 version). -- HTH RP (remove nothere from the email address if mailing direct) "CarlosD_LongIsland" wrote in message ... Thanks, Bob. You are correct in your assessment. However, I'd still like to read a book that might contain the subject in a structured manner. I'll explain: in the 1-2-3 days, I had a great command of the Lotus macro language, from the syntax chapter in Lotus handbooks. Is there a similar book on Excel programming? "Bob Phillips" wrote: You have specific needs rather than just a learning situation, so I would suggest that you record basic macros, try and amend, and post detailed questions (code and data as well) when you have a problem to this NG. You will soon improve, especially if you so some research of your own (using Help and the object browser). -- HTH RP (remove nothere from the email address if mailing direct) "CarlosD_LongIsland" wrote in message ... I'd like to get a recommended source of info (books,CD's, etc.) where I can learn how to program macros in Excel. I know the embedded recording method, but I need to program spcial activities i.e. in a given table, move the cursor until a certain value is found and if so delete the row. Basically, I need to know the language syntax, the method of inserting and saving the macro, its availability for other spreadsheets, etc. Thanks -- CarlosD_LongIsland |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro programming in Excel
My thanks to you Bob and Toppers... I have already placed my order with
Amazon and will get started from there (I am a good learner from books, thus my insistence) Again, thank you and I am sure I'll be back here with specifics... CarlosD "Bob Phillips" wrote: Well John Walkenbach does Excel VBA Programming For Dummies ISBN: 0-7645-7412-4 which is probably the best starter book. Once mastered, look at John Green's VBA 2002 Programmers Reference Manual (avoid the 2003 version). -- HTH RP (remove nothere from the email address if mailing direct) "CarlosD_LongIsland" wrote in message ... Thanks, Bob. You are correct in your assessment. However, I'd still like to read a book that might contain the subject in a structured manner. I'll explain: in the 1-2-3 days, I had a great command of the Lotus macro language, from the syntax chapter in Lotus handbooks. Is there a similar book on Excel programming? "Bob Phillips" wrote: You have specific needs rather than just a learning situation, so I would suggest that you record basic macros, try and amend, and post detailed questions (code and data as well) when you have a problem to this NG. You will soon improve, especially if you so some research of your own (using Help and the object browser). -- HTH RP (remove nothere from the email address if mailing direct) "CarlosD_LongIsland" wrote in message ... I'd like to get a recommended source of info (books,CD's, etc.) where I can learn how to program macros in Excel. I know the embedded recording method, but I need to program spcial activities i.e. in a given table, move the cursor until a certain value is found and if so delete the row. Basically, I need to know the language syntax, the method of inserting and saving the macro, its availability for other spreadsheets, etc. Thanks -- CarlosD_LongIsland |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro programming in Excel
"CarlosD_LongIsland" wrote in message ... My thanks to you Bob and Toppers... I have already placed my order with Amazon and will get started from there (I am a good learner from books, thus my insistence) You are in an elite group then, most people I know (me included) are useless :-) Seriously though, all mentioned are good books that will get you going nicely. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro programming in Excel
Try the forthcoming "Excel Basics to Blackbelt" www.excel-blackbelt.com
Lot's of gems - catered to Excel 2007 but useful for all prior versions as well. "CarlosD_LongIsland" wrote: I'd like to get a recommended source of info (books,CD's, etc.) where I can learn how to program macros in Excel. I know the embedded recording method, but I need to program spcial activities i.e. in a given table, move the cursor until a certain value is found and if so delete the row. Basically, I need to know the language syntax, the method of inserting and saving the macro, its availability for other spreadsheets, etc. Thanks -- CarlosD_LongIsland |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007-macro programming logic for data validation | Excel Discussion (Misc queries) | |||
Excel VBA/Macro programming for beginners | New Users to Excel | |||
Macro programming | Excel Programming | |||
Excel Macro programming | Excel Programming | |||
Website about excel macro programming | Excel Programming |