Want use results of Drop down list to look up a value
I am using Excel 2002 and I have a multisheet workbook and on the first sheet
I have created a series of 6 drop down lists pulling from predefined named
ranges. I also have limited subsequent choices based on what is selected in
the other lists. The end result is the user will be selecting parameters that
identify a product and now I am stuck with an easy way to look up the
associated part number based on the parameters they selected. Essentially,
once they have chosen the parameters in the list, I would like to create a
macro that uses those values to locate the associated part...Compressing xml file
I am using sharpziplib ti compress & zip an XML file. But the compression
ration is very bad for this utility compared to that i do with winzip. Any
idea how to integrate winzip with our VB.net application to compress xml
files. Or is there any other utility to do the kob
"Devesh Aggarwal" <firstname.lastname@example.org> schreef in bericht
> I am using sharpziplib ti compress & zip an XML file. But the compression
> ration is very bad for this utility compared to that i do with winzip. Any
> idea how to integrate...Nested schemas
I have a schema that references a child schema via a "xs:import" node.
In that child schema it references several other grand children
schemas. Is there an object in the VS 2K5 suite which will allow me to
consolidate all the nested schemas into one giant schema?
I've tried using the XmlSchemaSet object, but I cannot find a way to
serialize the compile schema. I'd appreciate any help or advice.
If you are using <xs:import>, these schemas are in different namespaces.
You can only have one namespace per file. So unless you want to
remove/merge namespaces, you cannot...How to used HOOK in OutLook Express
Hello All :
I want to use hook control .When outlook express received new mail and
remove the new eamil to myself mailbox .
PS:Use C++ or HOOK .(not outlook express rule)
Thanks Stiwin Lee
...Using the "IF" function?
I setup a worksheet like below
1 Jan 123
2 Feb 543
3 Mar 654
4 Apr 456
5 May 645
6 Jun 543
7 Jul 0
8 Aug 0
9 Sep 0
10 Oct 0
11 Nov 0
12 Dec 0
When the end of the month, the user will enter some value in the B column,
And now I would to setup a formula at A13, if the user enter the value in
the B7, then the A13 will show Jul, when the user carry on to enter the
value in the B8, then the A13 will change to show Aug, is it possible to
setup a if formula or other formula rather than use the macro to doing this?
=INDEX...Shared use of excel work books
Can anyone tell me "if I have an excel workbook (with multiple worksheets
that report to the first worksheet) on a shared drive whether it can be set
up for multiple users to access it and use it at the same time?" These users
will be accessing their single worksheet to update it periodically with the
first worksheet being the project leaders sheet where he gets to see all the
other worksheets on his one sheet.
You can do this by selcting "shareworkbook" from the tools menu and checking
the 'allow changes by more than one use'.
Beware th...multiple outlets centralized Inventory needs POS solution
One of our customer has multiple outlets. Selling is conducted through the
outlets. they have a centralized warehouse. A POS solution is required
Contact your local RMS dealer he can help. Store ops in each location then
HQ in warehouse.
"Haresh_ahuja" <Haresh_ahuja@discussions.microsoft.com> wrote in message
> One of our customer has multiple outlets. Selling is conducted through the
> outlets. they have a centralized warehouse. A POS solution is required
You need a HQ for the warehouse and store op...XML Deserialization #3
Im building an object model so I can deserialize my incoming XML and
Ive got a wee problem
My incoming XML looks like this
Have 3 classes - AlternativeSurname, AlternativeSurnamesCollection and
[Syste...Bluetooth: After pair without using a code, CreateFile asks for co
I am trying to use a Bluetooth device in Vista Home Premium.
The device does not have a pairing code or any way to enter one.
I use "Add Wireless device" in the Bluetooth Devices control panel.
My device is found and I choose "pair without using a code".
The device pairs OK and its properties show under Services,
Serial port ( SPP) 'AT Serial' COM4
But when I call CreateFile to open COM4, Vista shows a "click here" box
informing me that a device is trying to connect.
When I click the box, I get a dialog asking for the pairing code.
How ca...multiple or conditions
I have written syntax that doesn't seem to be picking up all my or conditions
thus leaving me with an inaccurate answer. What am I doing wrong?
Look in HELP index for the proper syntax for OR
"lschuh" <email@example.com> wrote in message
> I have written syntax ...Example using MFC WinInet classes with POST of FILE and other INPUT data
I am looking for a good example for POSTing both FILE and other INPUT
data to a URL. I understand that the FILE must use a multi-part encoding
but I do not understand how the atcual file contents get POSTed or how
the INPUT data gets POSTed also. I am guessing the INPUT data can be
added as part of the query parameters to the URL.
...Writing XML File from Dataset
Read many of the posting but still doen't understand the process.
I have a dataset with child records.
I have a specific XML "Account.XSD" format that I need to write this out to.
How do I marry these (2) items to create the output file.
Dim dataSet As DataSet = New DataSet("AccountRecord")
Dim AccountRecord As DataRelation =
data...Data Validation in XL2007 suddenly stops functioning
I created a workbook in XL2003 that included some named ranges on Sheet2 that
fed some data validation lists on Sheet1. Everything worked as expected. My
colleague opened up the workbook in XL2007 and used it several times, and
everything worked as expected.
Then she called me, saying that it was broken. Of the 6 named ranges and
related data validation columns on the other sheet, none of them were working
anymore. I went over to her PC, and checked everything I could think of- I
could set up working data validation test cells on Sheet2, but could not get
the ones on Sheet1 to...in what order should i place multiple brochure pages?
i am wondering in what order should i lay out my pages in my brochure so it
will print correctly . . .
I would use one of the brochure templates, create, print it out and edit to
"critic" <firstname.lastname@example.org> wrote in message
>i am wondering in what order should i lay out my pages in my brochure so it
> will print correctly . . .
...Can multiple cell results be displayed in a single cell?
Is it possible to display the contents of multiple separate cells in another
If the results of several cells say B1, B2, and B3 are the amounts $10, $15
and $20, I would like to display them in cell A1 as follows:
I could do this statically by using text and the 'Alt|Enter' function within
the cell. However, these amounts will change from time to time so I'd like a
Is this possible or not?
Thanks for any help.
="$"&B1&CHAR(10)&"$"&B2&CHAR(10)&"$"&B3&am...Using Custom Properties
I want to use custom properties to capture process task data while
documenting business processes. I am having problems understanding how
to make it work. The desired outcome is that I define 8-10 fields in
the shape on the stencil so that anytime I drag that shape to the
drawing it has all 8-10 fields to be filled in. Currently I can drag a
shape to the page, define fields FOR THAT ONE INSTANCE OF THE SHAPE,
but I cannot figure out how to change the custom properties on the
master shape in a way that ANY TIME I drag the shape to the page the
custom properties come with it. Please Help!
...Importing vcalendar data to multiple users
I'm running Exchange 5.5. Several times a year I have to create a large
group of users. I'd like to be able to pre-populate each user's
calendar with pertinent calendar events.
Is there a way to import this type of data in batch mode?
See if http://www.slipstick.com/calendar/holidays.htm#company helps.
> I'm running Exchange 5.5. Several times a year I have to create a
> large group of users. I'd like to be able to pre-populate each user's
> calendar with pertinent calendar events.
> Is there a way to import this type of data in batch...Worksheet Change Event log for multiple cells
I have a spreadsheet that is available here:
(although I scanned it for viruses please make sure you do it again prior to
opening it as I cannot guarantee it's worm free).
I would like to create a log file in an additional sheet (hidden probably)
that would record every activity from column E after clicking a button
assigned to a cell in that column and show these records in a worksheet
Totals in a specific row.
For example: Column A from a worksheet „Totals” corresponds with column A in ...XML Schema Validation Question
How can I use XSD to ignore certain nodes of an XML document. Specifically,
we have an event that I want to define using XSD. I then want to validate
incoming XML events with that XSD. However, I want the payload section of
the event to be freeform and thus, *NOT* validated.
Is there a way to define a node (and all of it's contents) in an XSD so that
the validator requires that the node exists, but does not attempt to
validate the contents of the node?
Example of the event:
<Header attribute1="true" attribute2="23"/>
<Payl...How move multiplicity labels in UML diagrams?
How can you move the multiplicity labels on lines in UML diagrams? Also, is
it possible to move the name labels?
...Using Excel error #N/A in a formula
I would like to capture the error message #N/A in an IF statement
Would like to use IF(MATCH(C1,Range,0)=#N/A,"OK","STOP") but it does not seem to work. What is the correct syntax to capture the #N/A error message and display "OK" instead of #N/A?
>I would like to capture the error message #N/A in an IF
>Would like to use IF(MATCH(C1,Range,0)=#N/A,"OK","STOP")
but it does not seem to work. What is the...Fonts name using CDC
I am drawing text using CDC (MFC control). How can I know all the Fonts
available? does anyone know the font list available (if so please, and it is
not so long, please write it, or at least tell me how to get it)
"Mathieu Fregeau" <email@example.com> wrote in message
> I am drawing text using CDC (MFC control). How can I know all the
> available? does anyone know the font list available (if so please, and
> not so long, please write it, or at least te...Publisher should allow the deletion of multiple pages
I wish publisher would allow for the deletion of muliple pages much like the
options available when printing pages.
lejianzhong <firstname.lastname@example.org> was very recently
heard to utter:
> I wish publisher would allow for the deletion of muliple pages much
> like the options available when printing pages.
Suggestion: Try here:
How to Contact the Microsoft Wish Program
Ed Bennett - MVP Microsoft Publisher
...How do I reformat a doc to eliminate an extra line between paras?
The document has an extra line between each para., and also the paras. are
blocked. I want them indented. Creating and applying a new style does not
solve the problem because the new style does not recognize [or "care"?] that
these two aspects are different in the original format.
I'm very frustrated @ this.
Thank you for suggestions to try.
If you click on the Show/Hide button ¶, do you see a ¶ between each of the
paragraphs (in addition to the one at the end of the text)
If so, use Edit>Replace to replace ^p^p by ^p
That will get rid of the e...How to Create a Grid using CEditView
I have an MDI Application. one of the view need
to be Editable that should display the contents in a grid format. The
Grid should be editable and should also be a scrollable. how to do it.
Plz Reply Me Fast
I had sent you a msg at codeguru.com informing you that
i've made a sample for you. I think that you havent read
that msg. yet. I'll send it to you now.