How Do I control the Gradient using VBA?

[kalukaley]

Hello All,

I have a Macro that inserts a WordArt object to simulate a Watermark.

The problem that I'm having is that I cannot seem to control the Gradient Effect that's been applied to the text.

I see how I can control the rotation and other properties of the WordArt Object, but I haven't been able to control the appearance of the text.

The pre-canned text effects available are not an option unfortunately.

Any ideas?

I'm doing this for 2007

 

[Legacy 98055]

Have you recorded a macro? I am a fairly accomplished VBAer but when it comes to something like this I'll definitely be using the recorder to at least get me on my way.

 

[kalukaley]

Excel 2003 will record a Macro. However, the folks at Microsoft didn't think it necessary to record the actions of creating a WordArt Object.

Bottom line, if you turn on the Macro Recorder in 2003 then insert a WordArt Object then use the context menus to make your adjustments you will find a nicely recorded Macro when you're done.

Try it in 2007 and you'll see nothing but blank space where you thought your Macro would be.

I also tried using the Macro that I recorded in 2003 in 2007. Well, you know the old story ... the object model is sufficiently different enough to make you start pulling out your hair.

Thanks for your suggestion. If you can come up with any other ideas, it would be greatly appreciated.