Good morning Claudio,

> ...
> Please. What it is: VBA macro recorder (how could I read more about it)
> ....

The macro recorder is a very useful tool, which records whatever you do in Word, Excel and PowerPoint (with a very few exceptions). It is available in Word, Excel and PowerPoint, unfortunately not in Outlook, Access, FrontPage (this refers to Off97 and Off2K, earlier I do not know). As I use the Developer Edition I do not know whether the macro recorder will be included in the other versions of the Office package (e.g. Professional).

You will find the macro recorder in the main menu under Tools > Macro > Record New Macro. In order to use it you have to open a(n) (empty) document / workbook / presentation. Then it will not only "record" your keystrokes, but it will document them nicely in working VBA code (assuming you did something useful). This code is not optimized (see Word/Excel/PowerPoint Help), but - properly used - will save hours of developing and testing VBA code.

This VBA code, by the way, can easily be "transported" into VFP to use it for automation. Especially usefully for people like me, who only seldom work in VB/VBA, but use Word or Excel as an alternate output vehicle besides the VFP report generator.

The macro recorder will not be any kind of substitute for a sound knowledge basis: I recommend MS Office 97/2K VBA Programmers´ Guide (a very good reference guide, not a study book, comes with the Developer Edition) and strongly recommend "MS Office Automation with VFP" by Tamar E. Granor and Della Martin (www.hentzenwerke.com), which - among others - explains the use of the macro recorder and how to convert the macros to VFP code.

Also see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoffdev/html/vsofficedev.asp
Unfortunately there are only a few items about the macro recorder (up to now) in UT / Microsoft Office

Hope this helps.

Enjoy your Sunday!

Hans

CC: Sorry for forgetting the PRE.