[AccessD] OT: Excel Question

Debbie,

If you are using XL2007, MS broke a lot of the macro recording functionality
for charting (and a few other areas) and not much is captured by the
recorder at all.  In XL2010 it is meant to be fixed again.  Indeed Charting
functionaly in XL2007 is less than stellar. It commonly behaves like it is
not fully operational, which is pretty accurate seeing it wasn't when MS
pushed XL2007 onto the world.  Of course you can fix most of these charting
issues by upgrading to XL2010 - great business plan really ;)

You can also have Access VBA call and run an code procedure in Excel from
Access. I use this a lot. Have the XL code in the XL template and just call
it to run from Access.

Cheers
Darryl.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie
Sent: Saturday, 24 September 2011 6:51 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] OT: Excel Question

I do that myself all the time. Trouble is I couldn't find how to do it  
in Excel. Until I found that, there was no macro to record and no code  
to crib.

Debbie

Sent from my iPhone

On Sep 23, 2011, at 3:37 PM, "Rocky Smolin" <rockysmolin at bchacc.com>  
wrote:

> Are you asking to fix it from the VBA in the Access mdb? If so, I've  
> been
> able to automate everything in Excel from Access by recording a  
> macro in
> Excel to do what I want and then cribbing the Excel code into the  
> Access
> module.
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie
> Sent: Friday, September 23, 2011 11:39 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] OT: Excel Question
>
> I have a database pushing data out to an Excel 2007 template. From  
> this data
> I am creating a variety of graphs that are stored in the template.
>
> Everything works fine except the relative scales on 2 of the graphs.
> They are side by side and the customer is adamant that the top and  
> bottom
> line up. This seems really easy, but it is not. One graph has a  
> dynamic y
> axis because the values can vary a lot. When they do vary, the whole  
> chart
> area will change height just a bit.
>
> Is there a way to fix the total chart height, while still allowing  
> the y
> axis to automatically determine the best tick marks and scaling  
> within that
> area?
>
> Debbie
>
> Sent from my iPhone
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com