Rabu, 14 Oktober 2015

[MS_AccessPros] VBA... but excel secondary axix

 

Pros, and well, I bet Crystal knows this…

 

I’m programmatically trying to create a secondary axis to an excel chart from an Access DB (there’s the Access – ha!)  and this is not working:

 

        .activechart.HasAxis(xlValue, xlSecondary) = True

        .activechart.SetElement (msoElementSecondaryValueAxisShow)

 

The google results also show xlCategory instead of xlValue but they both don’t compile as they are being considered some type of undeclared variable.

 

What am I missing?

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-4808

beaerospace.com

Passion to Innovate. Power to Deliver

 



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar