MSXML4 (Document Object Model XML), read the file, read the variables, fill it, send over socket

Hello together,

I would like to make the following.

- <root>
- <header eventId="" version="" eventName="" timeStamp="">
  <location lineNumber="" stationNumber="" stationIdent=""
toolPosition="0" processName="" application="" />
  </header>
- <event>
  <Processed identifier="" />
  </event>
- <body>
  <identifierType></identifierType>


I would like to read the XML file from harddisk.

I look for the Variables or for all, depend from the customer.
 - lineNumber
 - processName
 - identifierType
and fill these.

After I placed it finished, I will send it over socket to the
customer.

Questions:
a)  How can I read the XML file in memory?
b)  How search I for the variables?
c)  How I provide the new XML telegram?
d)  How can I do examine for validity?
    It is a valid xml file?


I would like to use MSXML 4 (Document Object Model XML DOM)
I need entered for that, I never use XML.
A simple example is for me the best. Thnak you very much.

Regards Andreas
0
2/16/2008 8:36:37 AM
vc.mfc 33608 articles. 0 followers. Follow

7 Replies
471 Views

Similar Articles

[PageSpeed] 46

You'll find samples all over the Internet.

Jst one detail: Use MSXML6. MSXML4 is an older version that is not 
distributed with Windows. MSXML6 OTOH is part of most recent versions of 
Windows and updates are distributed through Windows Update.

As far as coding is concerned, the only difference between the 2 (as far as 
simple parsing is concerned) are the COM ProgIds!

HTH,

Serge.
http://www.apptranslator.com - Localization tool for your MFC applications


"Andreas Hoffmann" <andreas_hoffmann2@arcor.de> wrote in message 
news:7a236d77-bf36-444a-b96c-813d25211abb@v3g2000hsc.googlegroups.com...
> Hello together,
>
> I would like to make the following.
>
> - <root>
> - <header eventId="" version="" eventName="" timeStamp="">
>  <location lineNumber="" stationNumber="" stationIdent=""
> toolPosition="0" processName="" application="" />
>  </header>
> - <event>
>  <Processed identifier="" />
>  </event>
> - <body>
>  <identifierType></identifierType>
>
>
> I would like to read the XML file from harddisk.
>
> I look for the Variables or for all, depend from the customer.
> - lineNumber
> - processName
> - identifierType
> and fill these.
>
> After I placed it finished, I will send it over socket to the
> customer.
>
> Questions:
> a)  How can I read the XML file in memory?
> b)  How search I for the variables?
> c)  How I provide the new XML telegram?
> d)  How can I do examine for validity?
>    It is a valid xml file?
>
>
> I would like to use MSXML 4 (Document Object Model XML DOM)
> I need entered for that, I never use XML.
> A simple example is for me the best. Thnak you very much.
>
> Regards Andreas 

0
serge69 (63)
2/16/2008 1:25:34 PM
Hello,
> You'll find samples all over the Internet.
http://de.search.yahoo.com/search?p=MSXML6+c%2B%2B+mfc&fr=yfp-t-501&ei=UTF-8&rd=r1
yes, but what is really good.
I need a example for my task. Thanks for further help.

> Jst one detail: Use MSXML6. MSXML4 is an older version that is not
What should I install?
Have you a link? I use for this project Visual C++ 6, MFC.
It is a old project, but my customer want a modification.

 Regards Andreas
0
2/16/2008 3:23:12 PM
"Andreas Hoffmann" <andreas_hoffmann2@arcor.de> wrote in message 
news:7a236d77-bf36-444a-b96c-813d25211abb@v3g2000hsc.googlegroups.com...
> Hello together,
>
> I would like to make the following.
>
> - <root>
> - <header eventId="" version="" eventName="" timeStamp="">
>  <location lineNumber="" stationNumber="" stationIdent=""
> toolPosition="0" processName="" application="" />
>  </header>
> - <event>
>  <Processed identifier="" />
>  </event>
> - <body>
>  <identifierType></identifierType>
>
>
> I would like to read the XML file from harddisk.
>
> I look for the Variables or for all, depend from the customer.
> - lineNumber
> - processName
> - identifierType
> and fill these.
>
> After I placed it finished, I will send it over socket to the
> customer.
>
> Questions:
> a)  How can I read the XML file in memory?
> b)  How search I for the variables?
> c)  How I provide the new XML telegram?
> d)  How can I do examine for validity?
>    It is a valid xml file?
>
>
> I would like to use MSXML 4 (Document Object Model XML DOM)
> I need entered for that, I never use XML.
> A simple example is for me the best. Thnak you very much.

Here's a link to a sample that I posted some time ago. I hope that it helps 
you to understand how to do what you need to do.  http://tinyurl.com/32l5vt

-Pete 


0
2/17/2008 5:16:14 AM
Good morning Pete,

thanks.

One question.

BEFORE:

- <root>
- <header eventId="" version="" eventName="" timeStamp="">
  <location lineNumber="" stationNumber="" stationIdent=""
toolPosition="0" processName="" application="" />
  </header>
- <event>
  <Processed identifier="" />
  </event>
- <body>
  <identifierType></identifierType>

AFTER --> Result

- <root>
- <header eventId="321" version="3.01" eventName="evTest"
timeStamp="16.02.2008">
  <location lineNumber="H-45 stationNumber="M-03"
stationIdent="9004534"
toolPosition="0" processName="Pr_Start" application="Connection" />
  </header>
- <event>
  <Processed identifier="2008-02-16-17:25:22 001" />
  </event>
- <body>
  <identifierType>Type-001</identifierType>

Can you give me a little bit more instruction.

Thanks.

Have a nice Sunday.

Best wishes Andreas




#include "stdafx.h"


#import <msxml4.dll>
#include <iostream>
#include <cstdlib>


#ifdef UNICODE
#define _tout wcout
#else
#define _tout cout
#endif


int _tmain(int argc, _TCHAR* argv[])
{
 HRESULT hr = ::CoInitialize ( NULL );


 if (SUCCEEDED ( hr ) )
 {
  MSXML2::IXMLDOMDocument2Ptr pDomDocument;
  hr = pDomDocument.CreateInstance (__uuidof
(MSXML2::DOMDocument40));


  if (SUCCEEDED (hr))
  {
   pDomDocument->async = VARIANT_FALSE ;
   pDomDocument->validateOnParse = VARIANT_TRUE;
   pDomDocument->resolveExternals = VARIANT_TRUE;


   if ( VARIANT_TRUE == pDomDocument->load (
_T("http://rss.slashdot.org/Slashdot/slashdot") ) )
   {
    std::_tout << _T("Success") << std::endl;


    // To prove to yourself that the file actually was downloaded,
save it
locally.
    pDomDocument->save ( _T("Downloaded.xml") );
   }
   else
   {
    MSXML2::IXMLDOMParseErrorPtr pError = NULL;


    if ((pError = pDomDocument->parseError) != NULL)
    {
     hr = pError->errorCode;


     std::_tout << _T("Error Code: ") << pError->errorCode <<
std::endl;
     std::_tout << _T("Reason: ") << pError->Getreason () <<
std::endl;
    }
   }
  }


  pDomDocument.Release ();
  ::CoUninitialize ();
 }


 return SUCCEEDED (hr) ? EXIT_SUCCESS : EXIT_FAILURE;


0
2/17/2008 7:58:19 AM
"Andreas Hoffmann" <andreas_hoffmann2@arcor.de> wrote in message 
news:2366876f-06a1-441e-bba5-59856d6cae46@v3g2000hsc.googlegroups.com...
> Good morning Pete,
>
> thanks.
>
> One question.
>
> BEFORE:
>
> - <root>
> - <header eventId="" version="" eventName="" timeStamp="">
>  <location lineNumber="" stationNumber="" stationIdent=""
> toolPosition="0" processName="" application="" />
>  </header>
> - <event>
>  <Processed identifier="" />
>  </event>
> - <body>
>  <identifierType></identifierType>
>
> AFTER --> Result
>
> - <root>
> - <header eventId="321" version="3.01" eventName="evTest"
> timeStamp="16.02.2008">
>  <location lineNumber="H-45 stationNumber="M-03"
> stationIdent="9004534"
> toolPosition="0" processName="Pr_Start" application="Connection" />
>  </header>
> - <event>
>  <Processed identifier="2008-02-16-17:25:22 001" />
>  </event>
> - <body>
>  <identifierType>Type-001</identifierType>
>
> Can you give me a little bit more instruction.
>
> Thanks.
>
> Have a nice Sunday.

Andreas,
You can accomplish what you desire very easily, however I wonder if you 
looked at the msxml SDK?

As I mentioned in a usenet post some time ago:

"The MSXML implementation is fairly easy to use if you use the #import
directive.  I had posted a sample program last week that shows how little
code is actually required to load an XML file using the DOM interfaces of
MSXML.  However, the important thing to keep in mind is that in order to
read/write and manipulate the DOM you must be familiar with the terminology
of the DOM and parser. There really is no way around knowing what elements,
attributes and namespaces etc. are.

One thing that I have done in order to boost my understanding of the MSXML
interfaces is to exercise the interfaces using VBscript.  This eliminates
the required COM initialization code in C++ and allows you to work with the
interfaces directly in a language that minimizes clutter.  In this manner I
was able to experiment easily and figure out what was going on and then
translate the code into C++. "


-Pete




0
2/18/2008 1:55:28 AM
Hello Pete,

I make this:
It is working, but I think, maybe is not optimize.
Do you know a better way?

I use this file. I read it and change the values.

<?xml version="1.0" encoding="UTF-8"?>
<root>
	<header eventId="Rt-Test Old eventId 000001111" version="Rt-Test Old
version V2.01" timeStamp="Rt-Test Old timeStamp 22.02.2008">
		<location lineNo="Rt-Test Old lineNo Line0931" statNo="Rt-Test Old
statNo 920-270" statIdx="Rt-Test Old statIdx 534523" />
	</header>
	<event>
		<partProcessed identifier="Rt-Test Old identifier 4545353535353"/>
	</event>
	<body>
		<identifierType>FL</identifierType>
		<resHead result="Rt-Test Old result 3333" typeNo="Rt-Test Old typeNo
3333" />
		<partCount>Rt-Test001 partCount Neu</partCount>
		<results>
			<result position="1" state="Rt-Test Old state 3333" removed="Rt-
Test false"/>
		</results>
		<items>
			<item name="Component1.timeStamp" value="Rt-Test001 timeStamp"
dataType="8"/>
			<item name="Component1.Identifier" value="Rt-Test002 Identifier"
dataType="8"/>
		</items>
	</body>
</root>

Regards Andreas


 CoInitialize(NULL);
  try
  {
  IXMLDOMDocument2Ptr pXMLDoc = NULL;
    HRESULT hr = pXMLDoc.CreateInstance(__uuidof(DOMDocument30));

    // Set parser property settings
    pXMLDoc->async =  VARIANT_FALSE;

    // Load the sample XML file
    hr = pXMLDoc->load("C:\\xml_rt2.xml");
  DWORD resCode = -1;
    IXMLDOMNodePtr workNode;
    IXMLDOMNodePtr resultNode;

    resultNode = pXMLDoc->selectSingleNode(_T("//root/header"));
    if (NULL != resultNode)
    {
      workNode = resultNode->attributes->getNamedItem("eventId");
      if (NULL != workNode)
      {
        //resCode = _ttol(workNode->text);
        workNode->text = "Rt-Test New eventId 000001111";
      }

      workNode = resultNode->attributes->getNamedItem("version");
      if (NULL != workNode)
      {
        //resCode = _ttol(workNode->text);
        workNode->text = "Rt-Test New version V2.01";
      }

      workNode = resultNode->attributes->getNamedItem("timeStamp");
      if (NULL != workNode)
      {
        //resCode = _ttol(workNode->text);
        workNode->text = "Rt-Test New timeStamp 22.02.2008";
      }
    }

 //----------------------------------------------------

    resultNode = pXMLDoc->selectSingleNode(_T("//root/header/
location"));
    if (NULL != resultNode)
    {
      workNode = resultNode->attributes->getNamedItem("lineNo");
      if (NULL != workNode)
      {
        //resCode = _ttol(workNode->text);
        workNode->text = "Rt-Test New lineNo Line0931";
      }

      workNode = resultNode->attributes->getNamedItem("statNo");
      if (NULL != workNode)
      {
        //resCode = _ttol(workNode->text);
        workNode->text = "Rt-Test New statNo 920-270";
      }

      workNode = resultNode->attributes->getNamedItem("statIdx");
      if (NULL != workNode)
      {
        //resCode = _ttol(workNode->text);
        workNode->text = "Rt-Test New statIdx 534523";
      }
    }

 //----------------------------------------------------

    resultNode = pXMLDoc->selectSingleNode(_T("//root/event/
partProcessed"));
    if (NULL != resultNode)
    {
      workNode = resultNode->attributes->getNamedItem("identifier");
      if (NULL != workNode)
      {
        //resCode = _ttol(workNode->text);
        workNode->text = "Rt-Test New identifier 4545353535353";
      }
    }

 //----------------------------------------------------

    resultNode = pXMLDoc->selectSingleNode(_T("//root/body/resHead"));
    if (NULL != resultNode)
    {
      workNode = resultNode->attributes->getNamedItem("result");
      if (NULL != workNode)
      {
        //resCode = _ttol(workNode->text);
        workNode->text = "Rt-Test New result 3333";
      }

      workNode = resultNode->attributes->getNamedItem("typeNo");
      if (NULL != workNode)
      {
        workNode->text = "Rt-Test New typeNo 3333";
      }
    }

  //----------------------------------------------------

    resultNode = pXMLDoc->selectSingleNode(_T("//root/body/
partCount"));
    if (NULL != resultNode)
    {
       CString sTest = LPCTSTR(resultNode->text);
       resultNode->text = "Rt-Test001 partCount Neu";
    }

  //----------------------------------------------------


    resultNode = pXMLDoc->selectSingleNode(_T("//root/body/results/
result[@position]"));
    if (NULL != resultNode)
    {
      workNode = resultNode->attributes->getNamedItem("state");
      if (NULL != workNode)
      {
        //resCode = _ttol(workNode->text);
        workNode->text = "Rt-Test New state 3333";
      }

      workNode = resultNode->attributes->getNamedItem("removed");
      if (NULL != workNode)
      {
        workNode->text = "Rt-Test false";
      }
    }



    //----------------------------------------------------
      IXMLDOMNodePtr itemNode;


      itemNode = pXMLDoc->selectSingleNode(_T("//root/body/items/
item[@name='Component1.timeStamp']"));
      if (NULL != itemNode)
      {
         workNode = itemNode->attributes->getNamedItem(_T("value"));
         if (NULL != workNode)
         {
			        CString sTest = LPCTSTR(workNode->text);
              workNode->text = "Rt-Test001 timeStamp";
         }
      }

      itemNode = pXMLDoc->selectSingleNode(_T("//root/body/items/
item[@name='Component1.Identifier']"));
      if (NULL != itemNode)
      {
         workNode = itemNode->attributes->getNamedItem(_T("value"));
         if (NULL != workNode)
         {
			        CString sTest = LPCTSTR(workNode->text);
              workNode->text = "Rt-Test002 Identifier";
         }
      }


  /*  workNode->Release();
      workNode = NULL;

      resultNode->Release();
      resultNode = NULL;

      itemNode->Release();
      itemNode = NULL;
*/

      AfxMessageBox(pXMLDoc->xml);

      hr = pXMLDoc->save("C:\\xml_rt2_NEU.xml");
  }
  catch(_com_error &e)
  {
       dump_com_error(e);
  }
  return TRUE;
0
2/22/2008 9:02:30 PM
Hello together,

 resultNode = pXMLDoc->selectSingleNode(_T("//name"));
    if (NULL != resultNode)

it is that  a good solution or maybe a bad.
If bad, do you know a better solution?

Regards Andreas

0
2/25/2008 8:32:05 PM
Reply:

Similar Artilces:

How to Access description of a Form object
Hi Folks, I need some help in VBA coding.. I have an application in which my backend data is stored in SQL Server 2005 . Front end has been written in MS-Access 2002, so it is obvious that the front end is an Access Database which contains forms, reports and queries. My current task at hand: There are forms and sub-forms in the front end database. Only the form objects and report objects have "description" on them apart from the "form.Name". I need to write the code snippet to read the front-end database and display the form and report Descriptions of only those object...

why is outlook trying to open an executable file in locate link brower? #2
"Kyle Harmon" <kharmon3@nycap.rr.com> wrote in message news:... > In my MS Outlook 2002, every time I click on an url with-in my e-mail > outlook trys to open an executable file in the "Locate link brower". And > this only happens when I do not have a browers open. Is there a fix for > this? > > Thank You, > > Kyle Harmon > > > Navigate to your default browser's executible (iexplore.exe for Internet Explorer) and double click on it. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion in...

delay sending out all emails outlook 2003
How do I permanently delay sending out all emails for 2 minutes if I realize there is an error or I forgot an attachment? Use Rules. http://www.outlook-tips.net/archives/2007/20070508.htm http://www.slipstick.com/emo/2008/up080508.htm#3 -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: dailytips-subscribe-request@lists.outlooktips.net Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Cente...

Linked OLE Objects
I have about 400 - 500 linked embeded objects (this includes Word docs, Excel spreads, and many Adobe Documents). It's a rather large database in size and its hitting the limitations that Access 2007 has, (i think) which is two gig. I was worried the many memo fields and/or database design with indexes was making it much bigger than it needed to be but, I think it's the linked docs. I had the users of the database right-click in the table to make sure all 447 docs are "LINKED". and they are. They deleted any embedded docs so we have only linked docs. To prove a...

Make active contract/contractdetails fields read/write
By default MS CRM makes invoice/Active Contract and it's Contract Lines read-only. Is there a way to make some of Contract Lines/contractdetail fields read-write again ? ...

HELP files not showing
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Email Client: imap Previously, I got help from the Help menu, Entourage Help. Now, all I get is so-called online help, which gives a bunch of tutorials and such. <br><br>Where did it go? <br><br>Specifically, I am trying to find out how to view a reply that I just sent to a certain message. There is a reply notation at the top of the message display but it doesn't do anything when I click on it. On 4/24/10 7:08 PM, roberthgoldstein@officeformac.com wrote: > Specifically, I am...

no warning file in use
Hi. I've got a question about a shared Excel file stored on Windows 2000 server. This file is accessed by two different Windows XP end users running Excel 2002 on their machines. Recently these two different end users have been accessing the same shared Excel file simultaneously without the usual file lock or warning that the file is in use. Sometimes they get the warning, sometimes not. When they don't, they assume they have rights to save to the file, only to find later on that their changes were not saved. I'm having both check for updates so that their Microsoft s...

Sending large mails very slow
Hello, A friend of my works with Outlook 2003 (not Outlook Express) on a HP desktop pc with XP SP2 installed. When he sends a large email, it takes a lot of time before the mail was send. For example: it takes 2 minutes to send a mail of 2 MB, about 6 minutes to send a mail of 6 MB... On a second computer, he does not have that problem. The mailbox (pst-file) is about 476 MB. He uses ZoneAlarm en AVG Grisoft but we turned off those with no results. Also with an new, empty pst file, the system remains slow... Reinstalling Outlook isn't a solution (try that too)... Has anybody ideas? Si...

Workflow for birthday reminder/email sending
I know one can search upcoming contacts birthdays by adding the month to form. But how can i automate it using workflow to send reminders/emails? ...

Outlook Coding
I have code to send emails progamtically from a module in Excel 2000 using OUtlook 2000, but now I need to have the code select 1 of 5 different email addresses and potentially a different mail server. Any ideas? --------------------------------- Set NewMail = CreateObject("Outlook.Application") Set objmail = NewMail.CreateItem(olMailItem) With objmail .To = Email .Subject = "Quotes for " & Name .Body = emailtext .Send End With Set NewMail = Nothing Set objmail = Nothing ---------------------------------- Submitted...

Converting access tables to XML for use in .NET web app
I need to access tables in an .mdb file and convert them to XML for use in my ..NET 2.0 web application. Can anyone point me to any tutorials or references on how to accomplish this? (Note: I am using VB) Thanks! ...

How do I link data from two different excell files?
I have two excell spreadsheets that need to be matched up and merge a certain field. Is there a statement that wou vlookup HTH, -- Gary Brown gary.DeleteThis2SendMeAnEmail.Brown@kinneson.com "twinclstar" wrote: > I have two excell spreadsheets that need to be matched up and merge a certain > field. Is there a statement that wou ...

Searching multiple excel documents
When searching for P.O. numbers in windows 2000 basic search command I enter the *.xls in the files or folders field, and i enter the P.O. number in the Containing text field but no xls documents show up. i've selected to search through all subdirectories and am positive the P.O. number is in a xls document, as i've cut and pasted it to test this. I've tried doing alpha numeric searches that are withing xls documents and this returns nothing aswell. doing a pure text search in all documents does return positive, so my search funtion does work for containting text. does wind...

Larger backup file
Why is the backup file larger than the original .mny file. I can see them being the same size, if not using compression, but actually being about 30% larger is a big difference. Does anyone know the answer for this? Thanks Not for me it isn't. Money file is 10mb and backup is 2mb. -- Regards Bob Peel, Microsoft MVP - Money Hints/Tips http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny UK Wishes/Suggestions mnyukwsh@microsoft.com "Perry" <sikespa@earthlink.net> wrote in message news:119501c3847d$3b679b50$a101280a@phx.gbl... > Why is the backu...

Possible to open word documents in Excel using hyperlinks?
Hi, I wondered whether it was possible to open office documents from within MS Excel using hyperlinks to the related files. The documents in question are MS Word format. Cheers Have you try it ? Ctrl-K Existing file ...... -- Regards Ron de Bruin http://www.rondebruin.nl "DobieM" <DobieM@discussions.microsoft.com> wrote in message news:2DFD72F1-0F21-4414-929D-4D9307997D68@microsoft.com... > Hi, > I wondered whether it was possible to open office documents from within MS > Excel using hyperlinks to the related files. The documents in question are MS > Wor...

Importing QIF files in Money 2004 produces duplicate transactions
Hi. After importing all my accounts into Money 2004 from QIF files, trnasfers between accounts generate duplicated records in related accounts. How to fix this problem? In microsoft.public.money, Adrian Guinsburg wrote: >Hi. After importing all my accounts into Money 2004 from QIF files, trnasfers >between accounts generate duplicated records in related accounts. >How to fix this problem? Restore your file to the way it was before import. Then import again. This time import all QIF files at once using Ctrl+<click> to select the QIF files. During the File->Import process...

Can receive but can't send emails on Windows Mail
An unknown error has occurred. Subject 'good site for random camping sales', Account: 'Rowena', Server: 'smtp.slingshot.co.nz', Protocol: SMTP, Server Response: '421 Cannot connect to SMTP server 202.180.66.218 (202.180.66.218:25), connect error 10060', Port: 25, Secure(SSL): No, Server Error: 421, Error Number: 0x800CCC67 This is the error message I get when I try to send emails. Up until a couple of days ago I have been able so send emails fine but now it has stopped working. Any idea of how I can fix this and send emails again? Cheers This...

Send automatic reply through specific account
I have setup my Outlook 2002 to work with 3 different email accounts. I also have rules to send automatic replies for 2 of those accounts. However, the problem is, the SMTP servers of the 2 accounts through which the auto replies are routed allow only 1 outgoing message per day. The third account (being a hotmail account) does not work with the rules wizard. So, can somebody out there tell me how Outlook can be set up such that all outgoing messages are routed through the third (hotmail) account (because hotmail seems to have no such limit)? Thanks in advance. you'll need to find a SMTP t...

how do I omit a duplicate field in a merged document?
I want to merge a list from Excel to a Mail Merge in Word. It works, but there are fields that are duplicates in Excel that I do not want in Word. For example, Mr. Smith has two lines of information in Excel which generages two letters in Word. Is there a way to eliminate this? You could add a column in which you count the occurrences of each entry. For example, if you have a customer number in column A, enter the following formula in row 2, and copy down to the last row of data: =COUNTIF($A$1:A2,A2) When merging in Word, filter this column for rows with a 1. dawnlin wrote: > ...

Stop opening multiple versions of Excel when click on xls files
Excel 2002 SP3 Win XP HE Hi, If I click on an xls file in Windows Explorer, it properly starts Excel and opens the file. However, if I need another file opened, and click on another xls file within Windows Explorer, instead of opening the file only, it starts up a new instance of Excel. So I can find myself with 3 or 4 (or more) instances of Excel running simultaneously. It's not a huge problem but I believe not necessary and would like to see if I can find a way of only opening the file in question once Excel is already opened, etc. Any ideas? Thanks. On Jun 28, 2:55 pm, ste...

Reading unicode keys from keyboard
Hi! In our application we need to read the unicode keypresses as we support multiple languages. The Form keypress event does not return unicode keycodes. Is there any way of reading the last pressed key ? For example using API ? Then we could put this code in the For Keypress event, and find the correct unicode keycode. We using this to output the correct unicode letters using 3rd party controls. David David De Bono submitted this idea : > Hi! > > In our application we need to read the unicode keypresses as we support > multiple languages. > &...

POP Marked Messages as read
Setup: Server 2003 with Exchange 2003 Client: Outlook 2003 (Exchange cached mode) and Snappermail (POP) on Treo 650 When the user pPps his email before he checks his messages in Outlook they show up in Outlook as Read messages. Is there a way to configure when the messages arrive they are marked as Unread? On Thu, 22 Jun 2006 17:58:01 -0700, Jeff <Jeff@discussions.microsoft.com> wrote: >Setup: Server 2003 with Exchange 2003 >Client: Outlook 2003 (Exchange cached mode) and Snappermail (POP) on Treo 650 > >When the user pPps his email before he checks his messages in ...

accessing XML data
Hi, I need to import data from XML to Access97 , what is the best way??? Is there any ODBC solution?? Thanx! Domac This was written with Access 2000 in view, but the idea should work. Check out the article at DBJ. http://www.databasejournal.com/features/msaccess/article.php/3310901 -- Danny J. Lesandrini dlesandrini@hotmail.com http://amazecreations.com/datafast "Domac" <dd.cc@cc.cc> wrote ... > Hi, > > I need to import data from XML to Access97 , what is the best way??? > > Is there any ODBC solution?? > > Thanx! > Domac > ...

Sending xls files to pc xlsx users
Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Hello, <br> My xls files are opening on my associates pc Office 2007 machines as a blue screen (shows toolbars, though). <br><br>Whats' missing? ...

Find the depth of XML
I have following XML: How can I find the depth of XML? in other word max level of the XML <Root> ----- level 0 <Name>----- level 1 <FirstName>name</FirstName> ---- level 2 <LasName>lname</LastName> <MiddleName>mName<MiddleName> </Name> <Information> <Info1> <Info2> --- level 3 <Info3>asdasd</Info> -- level 4 </Info2> </Info1> </Information> </Root> Raed Sawalha wrote: > I have following XML:...