Random access of XML file
I have the XML file which has a structure similar to one I pasted at the end
of this post. As you can see many elements are using different id attributes.
For example element Window uses WinID attribute as ID, the ViewData uses
ViewID attribute as an ID and so on. I need to read this file without
assuming what is the order of the elements, in other words I can't read it
sequentially. The reason for this requirement is that whole WindowsInfo
element might be missing for example or Object Info might be first and
WindowsInfo second etc.
Since many elements have the same name and diffe...need assistance with sorting a list of numbers
I've tried to achieve this problem with formulas and lookups and if
statements and conditinal formatting however was not able to achieve
desired results, so asking for help since I am not good with XL
marcros..if someone can start me up I can navigate myself..
There is a list.. say of numbers and there is a possiblity that
numbers will be repeats like:
I want to read say A1 (numbers) disregard the repeats and put info A2
12345 fail fail pass
11111 fail pass
333...Re: Re: api to check wheter xml is well formed #2
You mean the XmlTextReader.
> Are there any functions in .Net which can be used to verify whether xml is
> well formed?
That's quite unusual requirement. Usually, when XML is built using XML
API such as XmlTextWriter you don't need to check if it's well-formed -
you can trust standard API. When your XML is loaded into in-memory
store, such as XmlDocument - it's well-formed by definition.
And when you just have a string or file and want to check it's
well-formdness, use XmlTestReader:
XmlReader r = new XmlTextReader(...);
while (r.Read()...Set public folder as default address list
Is there a way that I can set a public contact folder as the default address
list when composing a message on all of my clients?
JBeckett [MCSA] <JBeckettMCSA@discussions.microsoft.com> wrote:
> Is there a way that I can set a public contact folder as the default
> address list when composing a message on all of my clients?
This is an Outlook thing. You can change the Outlook Address Book to display
whatever you like as its initial view, in the settings in the address book
menu, I believe. You don't want to make Outlook do *lookups* first from the
public contacts folder, ...Generate a unique number of list
I have a list of number which some is repeated, how can I regenerate a
list with unique number. e.g
Thanks for any one who can help.
Terence Chan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26963
View this thread: http://www.excelforum.com/showthread.php?threadid=467164
Mark your range of data, Data>Filter>Advanced Filter and Select Unique
Copy the data to a new location.
Rega...Automatically Deleting a List from Another List
I'm new to these parts and I'm hoping someone can help me. I have a simple
email list of 4000 addresses (List A) and some are no good. I've made a
separate list (List B) of those and want to delete all of them from the
initial list (List A). Is there a way of doing this without doing it
manually? A formula of some sort? Thank you for your help.
Look in the vba help index for FIND (FINDNEXT if more than one). Then a for
Microsoft MVP Excel
"ddethomas" <email@example.com...Pretty print XML?
I am sure this has been asked enough to warrant an FAQ but I could not find
Does anyone have some code and maybe an XSLT stylesheet that would allow me
to transform an XML string to a "pretty" version (nodes indented on separate
Thank you for your help.
Kevin Burton wrote:
> I am sure this has been asked enough to warrant an FAQ but I could not
> find it.
> Does anyone have some code and maybe an XSLT stylesheet that would allow
> me to transform an XML string to a "pretty" version (nodes indented on
> separate lines, et...XML Root Node
I have a file I'm using as a Configuration file (configuration as in options and
such). When I create the xml file in the .Net IDE, it places the following
This is the way I'd like it but it doesn't work this way :( When I validate it
against the xsd file, it says that it's invalid. (Can't remember error, don't
have time to reproduce). The fix is changing it to the following:
So, just need 1 of the two (...Buils your own mailing list!
...how to have excel repeat a template on each page of each workshee.
i have created a template that i want to have on each page of each worksheet.
is there command to make this happen/
You can create a new default template, with your preferred settings:
Open a new workbook.
Copy your template onto each worksheet
Choose Save As
From the Save As Type dropdown, choose Template (*.xlt)
Name the File "Book.xlt"
Save it in the XLStart folder
(usually in Program Files/Microsoft Office/Office)
When you click the New button on the toolbar, the new workbook will be
based on this template.
If you want new sheets to be inser...Paragraph spacing of bulleted lists
I am trying to increase the paragraph spacing between my bulleted lines but
want to keep the line spacing at 1 line. When I try to change the paragraph
spacing, it accepts and displays the number I choose (e.g., 3pts, 6pts) but
it does not make the change. What can I do to enable paragraph spacing
There's an inconspicuous box in the Format Paragraph pane for
something like "Don't Add Space Between Paragraphs of the Same Style."
(Note that you're not limited to the Space After numbers in the
dropdown -- you can t...Looking for a way how to get currently selected item from List control
There is a task. I have a window that is something like CListCtrl (but
different framework, not MFC). I know only the HWND for that window. Inside
are items. In fact it looks like usual ListCtrl but with some options like
background and small buttons in the bottom to add/delete items. So I'm
looking for a way how to find out which item is currently selected. I mean i
need coordinates of that item. Is it possible to do using some WinAPI
functions or so?
For every complex problem, there's solution t...Is there a template available for a grocery list?
In my older version of Windows, I had a template for a grocery list. It was
in the Works tool. In my newer desktop, Windows XP, I don't seem to have one
in Word or Publisher. Microsoft Online did not have any either. Any
suggestions on where I might find one?
The Cook wrote:
> In my older version of Windows, I had a template for a grocery list. It was
> in the Works tool. In my newer desktop, Windows XP, I don't seem to have one
> in Word or Publisher. Microsoft Online did not have any either. Any
> suggestions on where I might find one?
takes less typing on...Macro to check data from excel list against access query and return value back to excel
(I posted this yesterday but am tryign to make it clearer)
I have an excel list with "name" and "title" and there are many erros
and mis-spellings. I havbe an acess quesry that has the correct names
and titles and also some mis-spellings and foreign language spellings
pointing to the correct english name and title.
I would like to write a macro in excel to do a lookup of the excel
value in the access quesry and find EITHER an exact match or close
match and return the value of a specified field back into an excel
Here is a hypothetic example:
PK=Van G...Contact List
Anyone know of a simple -- painless -- non frustrating
method to compile a folder with say 15 of my existing
contacts within OUTLOOK 2002 (using Office XP as well)...
complete with company name & full address. Intention is to
email the folder as an attachment. This sounds quite
simple, but has someone actually completed the task??
Thanks in advance for correct & detailed instructions.
...2nd cry for help-3 variable length lists of data that need to be concatenated in to one column
I have 3 variable length lists of data that need to be concatenated in to
Presently the following formula works (This is typed in to A1 and copied
down the column using the drag handle so in cell A2 refs to C1,D1,E1 are
automatically changed to C2,D2,E2 and so on):
Result - a list of data in column A which is the list of data in column C
plus data in column D plus ...Replace INI with XML
Looking for sample VB6 code to replace the functionality of INI related code
with code to do the same using XML. Googling did not help me.
WriteXMLString sSec,sKey, sItem
"Bee" <Bee@discussions.microsoft.com> wrote in message
> Looking for sample VB6 code to replace the functionality of INI related
> with code to do the same using XML. Googling did not help me.
> WriteXMLS...Compare two XML Files and save to One
I feel like this question has been asked before but I just cannot seem
to find a good answer.
Q: Is there a way to have two XML files and compare them and save them
Output to XML-C would be:
I downloaded and ins...combo box on a form, I want it to list the maximum number of marks
I have a combo box on a form, I want it to list the maximum number of marks
allowed for a task. So in tbltask table I have set the following:
Task Name Max Mark
So on a form will have the task1 and task2 listed on the it and I want the
combo box next to the task to list all of the marks up to and including the
Student Name Task Mark (Combo box would list the following numbers)
a Task1 1,2,3
b Task2 1,2,3,4,5,6,7,8,9,10
c Task1 1,2,3
On M...Data Validation list #6
I have a data validation cell that controls a pivot table. I want to help
the user browse through the list that appear in the cell. It is a long list.
I've seen some lists that prompt the names with the letters that you press
in the key board. How can I make my list work like that.
DV drop-downs are not capable of providing autocomplete.
For workaround using a combo-box see Debra Dalgleish's site.
Gord Dibben Excel MVP
On Thu, 29 Sep 2005 06:29:05 -0700, "FA" <FA@discussions.microsoft.com> wrot...Contacts List #4
Could you please tell me how to change the "default" contacts list from
Global to contacts? When clicking the "to" button, the address book seems to
want to look in global contacts, when I would like to it just display the
contacts. Using Outlook 2003. Thank you for your help.
Open your Address Book (Ctrl+Shift+B) and select Tools->Options. Set your
order for which contacts folder you use first there.
Milly Staples [MVP - Outlook]
ALWAYS post your Outlook version!
Post all replies to the group to keep the discussion intact.
How to ask a question: http://su...numbered lists
I installed Word 2002 in my new Windows 7 laptop in addition to the
Office 2007 I had previously installed and noticed something weird when
I create a numbered list as I type.
The way I recall it, when I want to go to next level of numbering I
would press enter, and when the next number in sequence appeared I would
hit tab to move it to the next indented level. Now, when I hit tab, it
does nothing. If I go to the number and hit tab, it deletes the number
and moves the text one level forward. I cannot create a sublevel.
Is there a Word option I am missing? I went to AutoCorr...Publish a PF Contacts folder as an address list
Using Exchange Server 2003, is it possible to publish or query a Public
Folder Contacts folder as an address list in Exchange 2003 to appear under
the All Address Lists.
I want this available for all users to view.
I know the contact folder can be added by each user as an email address
Raji Arulambalam wrote:
> Using Exchange Server 2003, is it possible to publish or query a
> Public Folder Contacts folder as an address list in Exchange 2003 to
> appear under the All Address Lists.
> I want this available for all users to view.
&...Runtime Error 381 Couldn't set list property, invalid array index
I opened a 97 spreadsheet in 2003 and now each time a user form is
initialized a runtime error comes up in the following line in the vba
ComboDeptNum.List = Sheets("Definitions").Range("$J$1:$I$12")
It is the same thing if I specify a named range:
ComboDeptNum.List = Sheets("Definitions").Range("DeptList")
This exact same codes works fine in 97 and the security is set to low
in 2003. The number of columns is set propoerly but the list box just
won't load values. I'm a newbie to Excel vba but have more experience
with Access and never sa...I need to manage an email mailing list
Can anyone suggest an add-inn that can help Outlook 2003 managean email
mailing list. I need to manage opt in's and outs etc
"Stephen Connolly" <StephenConnolly@discussions.microsoft.com> wrote in
> Can anyone suggest an add-inn that can help Outlook 2003 managean email
> mailing list. I need to manage opt in's and outs etc
> Stephen Connolly
Search www.slipstick.com for third party utilities that might h...