RE: [MS_AccessPros] VBA... but excel secondary axix

Liz,


Did you attempt to record a macro in Excel and then use the code?


Duane Hookom,, MVP

MS Access

________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: MS_Access_Professionals@yahoogroups.com
> Date: Wed, 14 Oct 2015 20:39:23 +0000
> Subject: [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.
>
>
>

------------------------------------

------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/