>Hi Bret,
>
>The best way to work with VFP and Excel is to use the macro recorder
>and 'steal' from the results.
>
>VBA uses intrinsic constants--you see these when you use the Macro Recorder (which is a GREAT way to learn to automate Excel). VFP, however, does not have these values as a part of its language. To find these values, use an Object Browser. Excel's is available within Excel by Alt-F11, then F2. If you have VFP 7, use its own Object Browser. You can search for the constant name, and the value is shown in the bottom panel.
>
>
>Ger
Yeah I know about the recorder, but I have had no luck translating what it is doing with a Text Box Shape into VFP. I was hoping that someone else out there has some experience with a Text Box Shape and would lend some code help.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope