Creating array of specific object types dynamically
little gotcha. Some COM objects requires array of specific type.
To give you example, following DOESN'T work:
[array]$X = @()
However below code works:
[int32]$X = @()
For my framework, array type can be dynamic and I don't know in advance what
type it's going to be. So what I would need is below:
[$PropertyType]$X = @()
This doesn't work with error message "Unable to find type".
As a workaround, I solved it using following:
Invoke-Expression "[$$PropertyType]`$Var = @()"
This code works as expected, I am just curious if ...Help with a formula..
I am trying to create a formula that will take information from a cell on one
sheet and combine it with text on another sheet. I know how to get the two
together. My problem is that I want the part that is brought in to be bolded
type. Here is what I have in the formula. ="we are pleased to submit our
quotation for "&(cell reference)&" according to the following
specifications." What I want to do is have the cell reference part be bold
type. Is there a way to do that? It doesnt work if I bold the cell.. already
tried it.. Any suggestions?
You'...What's this symbol?
In a file I got from elsewhere (can't ask the author), there are gray
colored symbols in the left margin that look like a capital "I" or a
vertical I-beam, a little bigger than the text (could almost be like a
bracket). I can't select them, can't find anything in Help.
What are these?
then look in HELP for Subtotal
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://w...Help needed urgently
Im trying to check that one row of data satifies a criteria, then if it does
it counts an entry in another column adjescent to it.
Column A - Column B
Blay - Y
Blay - N
Blay - Y
Chop - N
Chop - N
High - Y
What i would be asking (of a much bigger table) is If Column A = Blaydon and
then column B (same row) = Y, then count. In this example I would want 2
returned as the answer.
Is this possible?
Try one of these...
Use cells to hold the criteria:
D2 = Blaydon
E2 = Y
If you're using Excel 2007 or later:
=COUNTIFS(A2:A7,...Naming charts on own sheet
I have a series of charts (which are all contained on their own sheets).
I need to name each of the charts (as they will be used by someone else in a
I have tried clicking on them and also pressing shift before clicking on
them, and I am not able to change the name in the name combo box.
Can anyone advise me of how I can change the names.
Thanks for your help.
If you have chart sheets you can change the name by simply changing the
sheet tab name.
What you described is the method used on chartobjects, which are usually on
Andy Pope, Mi...- About Outlook's archiving capabilities...
I am trying to take a load off Outlook (Office XP) by archiving old items,
but I'm new to the process.
Every folder I archive seems to generate its own "Archive" folder in the
Folder List... so essentially, all it did was move the old contents from one
folder to another.
My question is, am I really helping Outlook at all by doing this? The whole
point of archiving was to give it fewer messages to load at bootup. But it's
still loading them in the Archive Folders, isn't it?
What happens if I delete the Archive Folders? Am I helping Outlook's
performance at all? And ...Changing Item #'s
Is it possible to change the item #'s after the item has already been entered?
No there isn't in the "base" product, but MBS does have a tool that you can
use called Item Modifier - this will allow you to change an Item number from
one value to another.
You can email this address below and they can answer any questions you have
about the tool and can tell you what the cost of it is.
Hope that helps you out,
> Is it possible to change the item #'s after the item has already been entered?
...Standalone v's Enterprise Root CA's
I'm new to W2K8 CA's and was wondering if someone could please answer my
1) What are the pro's and con's between a Standalone and an Enterprise Root
2) Does a Root CA always has to been online for NAP with IPsec to work?
3) Does a Root CA have to be online of a Subordinate CA to automatic enrol a
certificate to a client?
4) For HA reasons, can you MSCS cluster Subordinate CA's?
I am not the AD CS expert but hopefully this helps to start:
1. See here for details about, applies also for Windows serv...loan amortisatio chart not updating
I use MS Monet 2007 premium. I have created a loan amortisation account
which breaks up my monthly instslment into pricipal and interest. The loan
commencd from 7 October 2005 and is for a period of 5 years. The problem is
that the loan account does ot show any loan instalments beyond 7 October
2006 (exactly 1 year after the commencement). Why is this happening. Why
is the account not updating with instalments which have been debited to my
account after 7 October 2007.
Were you depending on downloaded transaction data for this account? Did the
download link br...help with dynamic tables
This is a bit complicated to explain but I'll try my best. In columns A, B,
C I have different drop down lists. Column A has Store1, Store2, Store3,
etc. Column B has Dept1, Dept2, Dep3, etc. Column C has ProductA, ProductB,
ProductC. As of right now, these lists are not dependent on each other, I
can choose anything from any list regardless of the previous category. Also,
the length of these lists is undefined, meaning I will constantly be adding
to them in sequential rows below. And then columns D and beyond have data
such as Sales, Profits, # of items, etc.
What I...How do I make a chart with several times during a day
This seems like it may be a simple thing, yet I can not for the life of
me figure out how to do this (or at least semi-easily with VBing it for
I have a simple table filled with the following information (example
12pm 5pm 10pm
11/20 5 4 7
11/21 5 4 7
11/23 5 4 7
11/24 5 4 7
11/25 5 4 7
So basically I am keeping track of a numeric value three times a day. I
would like to make a chart of it with...Analysis Cubes Measures & Facts Mismatch Dynamics GP
i am facing the issue that all data is not populated to cube as is available
for examples monlthly sales does not match with Dynamics monthly sales
for example acccount list in account fact table does not match with Accounts
in dynamics gp
missing information is also variable somewhere week data is missing and
somewhere month data is missing although schedule job for daily update is
also scheduled and running successfully
Configuration: SQL 2005 Analysis Service
...manufacturing scrap not calculating on pick list and serial #'s no
I have entered my percentage of scrap on a MFG BOM and is seems to be
calculating properly in the setup. When I release the components and add
them to a pick list the scrap is not calculating.
I also choose serial numbers and they do not carry thorugh and print on the
Is there some setting that I have missed?
...Help! Problem Referencing Excel 2003 in VB.NET
I am using Visual Studio 2008 Express Edition to develop some VB.NET
code that manipulates Excel files. I am developing on a Vista/Excel
2007 machine, but I need the code to work on an XP/2003 machine as
I initially set a reference to the Microsoft Excel 12.0 Object Library
and imported the Microsoft.Office.Interop.Excel namespace. This works
great on the VIsta/Excel 2007 machine, but it does not work on 2003,
which needs the 11.0 library. I get an error that says "Unhandled
Exception . . . Could not file or assembly
'Microsoft.Office.Interop.Excel, Version 12.0.0....Adding a certain text label in a excel chart
I am plotting in regularly basis a certain set of data in excel.
Based on some data analysis this set of data has to be fitted to these
y = 1/x^a (1) and /or
y = b/x^c (2)
from data analysis, constants a, b and c are found and are placed lets say
in cells A1, B1, C1.
On my graph, I am putting then two small text labels where the real equation
is displayed: smth. like: y = 1/ x^3.45 and / or y = 0.256 / x^3.12 The
whole process is similar with excel curve fitting, when the “show equation on
chart” is checked.
Thank you in advance
My question is: Can ...survival chart
Does anybody have an idea how it would be possible to
trick Excel into making a survival plot? That is a stepped
graph ploting cumulative survival on the y axis and time
slots on the x.
Any suggestion would be most appreciated.
I don't have a 'survival plot' per se, but you could look for ideas on
my web site. The cumulative probability plot sounds like a possible
If it doesn't give you any idea, post back with some typical data, and
we'll have a look.
- Jo...Customizing Excel's Border Defaults
I'm working with Excel 2000 and use Borders frequently.
The preset default border is a thin line, yet I prefer
and always change it to the thick line. How can I change
the Excel default to the thick line rather than the thin
line? I know it's a small problem, but it's driving me
crazy changing it all the time. In WORD, I know how to
easily "add style default to template", but can't figure
it out in Excel. Any help is greatly appreciated!
...Chart "Benchmark" Line Graph Question
I am generating a graph of many team's monthly audit productivity percentages
(bar graph) with a "benchmark" (line graph) at 95% (y axis) across 6 month
period (x axis).
The problem is that the line graph appears on the graph but the ends of the
line are centered in the end columns (left & right). Is there as simple way
to extend the benchmark line out to the edges of the graph?
Have a great day and live life with passion!
...Need Help with drop down list with conditions...
I need help.
I'm having a very difficult time creating a sequence of list which change based on the item selected on the main list, lets call it the index:
The Index list, the first list, would define vendors. In this case Hotel Companies (e.g Hilton, Marriott, Sheraton).
The following list, the 2nd list, would define properties, but the properties would vary based on which hotel company is selected (e.g. If Hilton, then "The Plaza, the Waldorf Astoria. If Marriott, then Marriott Marquis, Marriott Convention Center etc etc...) on list #1.
And Last but not least, the 3rd list would...Chart printing issue in Excel 2007
A spreadsheet with charts was created using Excel 2003. I have Excel 2007
and saved it in compatibility mode.
I inserted a couple colored lines on the chart and created my own legend
based on these. A couple of issues:
1. When I close the file or even minimize, 2 of the colored lines on a
couple of my legends disappear upon reopening.
2. When I try to print a chart, it looks good in Print Preview, but then
looks magnified,half off the page, and only one of my drawn lines is printed.
When someone with 2003 prints, the sizing is correct, but all of the
colored drawn lines are missing...trying to link maps and pie charts
I was trying to link sales data stored in an excel table with a specific
country in MapPoint. This software allows you to do this very easily. You can
even picture the data in piecharts (% sales for each competitor).
However there is very little flexibility with the look of the result: you
cannot choose the color of the slices of the pie, you may not display data on
the graph, and the maps do not look very professional.
I know it is possible to link automatically a table with a shape in visio.
Can this shape be a given country/region on a map? Can the callouts have th...Sum amount if = 2 value's
I have a spreadsheet of payment types for which I want to sum the tota
amount per type per month
A B C
Type Amount Month
I'm able to get the total amount per type by usin
=SUMIF(A:A,"TYPE",B:B), but can't work out how to get a total for eac
type each month
Somthing along these lines: =SUMIF((A:A,"TYPE",B:B)&C:C,"MONTH")) ????
loscherland's Profile: http://www.excelforum.com/member.ph...Excel 2002 converts 'S' to 0 when pasting from Clipboard
I came across the following problem:
I copied some tabular data from IBM Personal Communications into the
clipboard (yes, I am still a user of good old 3270 applications). Then
I pasted the data into Microsoft Excel 2002 and all cells containing a
'S' became a '0' (number zero).
Next I did some tests and found out that every single uppercase 'S'
that is transferred to Excel using copy/paste is translated to '0'.
This would not happen with other letters or with words containing an
Using 'Paste special' I can choose to insert my Clipboard a...Macro Help #18
Well I think this is a macro. I have searched my excel book and i can not
seem to figure out what to do.
I want to write something that if this statement is true, then the font
color changes. But here is the potential problem. THe location of the text
will change. So i need it to search for this text and then change the color.
Does that make sense? Is this possible? If this can be done it will really
help me. Thanks in advance.
This is exactly what i am trying to do.
You type in a persons name into cell a1. you also type a name into cell a2.
These names will transfer over ...Newbie needs help with new Exchange 2003 installation
I am TOTALLY new to Exchange. We just installed Exchange Server 2003
on a Windows 2003 domain.
I have one (test) account set up and it appears to work OK but I keep
getting an error message that says "Task "Microsoft Exchange Server"
reported error (0x8004010F): 'The operation failed. An object could
not be found.'
I know, I know...How could I possibly not understand THIS message?
I appear to be getting mail but I' can't be sure. How can I check to
see what's causing this (and more important...what object it's looking
Thanks for any help!