Minggu, 11 September 2011

Re: [ExcelVBA] Re: Error and shutdown

 

Hello David,
 
I have done this to a certain extent. One of the problems is that you do not know when the shutdown is coming. Thus I found myself stopping the code after each iteration of the Do Loop, saving the file then continuing until it does shut down. The code is run against 3 indexes, so it is time consuming.
 
It may still be possible to Define the Default better than I have and hopefully reducing the number of Fonts to less than the 512. At a minimum there are 2 completely different charts, do primarily to the 2ndary Y-axis. The order you address the elements in a chart seems crucial also, since they can interact with each other. All have legends, but only 1 has a Title.
 
I think Placement (location) is first, Size (Width and Height), Legend (location, height, width), Title (location, height, width), X-axis center, which affects the X-axis title and on and on.
 
The problem is that often one affects the other. Maybe several default charts can be created?
 
Thanks,
David

From: David Braithwaite <dbraithwaite@charter.net>
To: ExcelVBA@yahoogroups.com
Sent: Sunday, September 11, 2011 7:45 AM
Subject: RE: [ExcelVBA] Re: Error and shutdown

 
David

What keeps you from breaking this into multiple workbooks to get around problem?

I was thinking that if it were smooth "presentation" of the data,

Using a "pile" of workbooks could be (at least partially) hidden by using hyperlinks to instrument the navigation.

Db

From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf Of David Lanman
Sent: Sunday, September 11, 2011 10:39 AM
To: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] Re: Error and shutdown

Thanks David. Charting and trying to do it with VBA is not very good. The order you do it in makes a difference and almost anything you do to the worksheet seems to make a difference.

With ActiveChart.Parent
.Placement = xlFreeFloating
End With

The above seems to help some, but does not seem to "stay in place."
Selection.TickLabels.AutoScaleFont = True
Will void the previous VBA and seems to be the norm when you record a macro. MSN help documentation is pretty poor too.

David

From: david braithwaite <dbraithwaite@charter.net <mailto:dbraithwaite%40charter.net> >
To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
Sent: Saturday, September 10, 2011 7:48 PM
Subject: Re: [ExcelVBA] Re: Error and shutdown

Hi david

It appears that there is a maximum of 512 font types in an excel workbook.

Microsoft posted this

http://support.microsoft.com/kb/215573

The article indicates that the number often grows out of control due to
auto-sizing ---

I have found that if you google the error message you often come up with
something useful.

Do this and you will find that other people have been where you are.

Db

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
MARKETPLACE
A Bad Credit Score is 600 or Below. Your Score? Find out at freecreditscore.com.

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar