I’ve seen this sort of thing in excel before, some better than others. I tested it in a live journal account i set up and it work perfectly. Not sure about pictures though!
December 2005
P -code??????
I’m working on a big dictor app at the moment. It’s starting to crash big time! – Often after making a small change to a VBA module it will refuse to open again in excel. I have to do a “detect and repair” to get the workbook to open. I’m not sure if it’s a registry problem or something else – but I’ll find out!
Anyway all this lead me to finding this post, which I think I have read before, but forgot about!!! P code me up kidder!
Oh and dont for get Robs Code cleaner!!!
Lets Split!
Came across the VB Split fucntion which I had never used before today, fom help: (anoted)
Description
Returns a zero-based, one-dimensional array containing a specified number of substrings.
Syntax
Split(expression[, delimiter[, limit[, compare]]])
Expression, Required. ”the string
Delimiter, Optional. ”String character used to identify substring limits. If omitted, the space character (” “) is assumed to be the delimiter.
Limit, Optional. ”Number of substrings to be returned; 1 indicates that all substrings are returned.
Compare, Optional. ”Numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values.
might be handy to have this around!
gbCodeLib
I’ve been using this for about 6 months and it’s a brilliant tool! Gary has also been kind enough to make the full version available for free too. Excellent!
Not only can you manage all you code snippets, but you can store example file right along side them; there’s even a version that runs right off your flash drive.
Give it a whril and never find yourself scratching though old workbooks again!
Exporting to excel from owc (and pivot tables)
EXPORTING TO EXCEL FROM OWC
Some customers have reported difficulties in exporting data from Office PivotTable Components to Excel. Microsoft has investigated these reports and determined that:
“¢ OWC does not pass the expand state to Excel correctly, so Excel expands everything. Because all rows are set to visible, all data must be downloaded and all empty rows must be filtered out. This can cause a significant slowdown in the export operation. Rectifying this situation is not as easy as it would seem because the two programs handle the expanded state very differently.
“¢ There is also an issue with the formula and the data caches. The OLAP client caches both data and formulas. By default, the cache is limited to 25 percent of available system memory. If that is exceeded, the cache is purged. To continue processing, the same data must be downloaded over and over. This may cause the export operation not to work. Try setting the cache memory higher as described in Microsoft Knowledge Base article 814030.
This cache dump issue is not limited to OWC, but may also occur in Excel PivotTables.
I’ve never liked the fact that pivots are stored in cache, but having decided to do this why limit it to 25%?