ÇÔ¸Õ¡ÒÃÊÃéÒ§â¤Ã§¡ÒôÓà¹Ô¹¡ÒÃÍѵâ¹ÁѵԷÕèãªé MFC áÅÐäźÃÒÃÕª¹Ô´

ÊÃéÒ§â¤Ã§¡ÒáÒ÷ӧҹâ´ÂÍѵâ¹ÁѵÔ

1. ´éÇ Studio ÊÓËÃѺ¹Ñ¡¾Ñ²¹Ò Microsoft àÃÔèÁµé¹áººãËÁè "MFC AppWizard (exe) "â¤Ã§¡Ò÷Õèª×èÍÇèÒ"AutoProject"
2. ã¹¢Ñ鹵͹·Õè 1 ¢Í§ MFC AppWizard àÅ×Í¡ "¡ÒÃâµéµÍºâ´Âãªé" ÊÓËÃѺ ª¹Ô´¢Í§â»Ãá¡ÃÁ»ÃÐÂØ¡µì¨Ò¡¹Ñ鹤ÅÔ¡àÊÃç¨ÊÔé¹
   
   â¤Ã§¡ÒÃãËÁè ¡ÅèͧâµéµÍº»ÃÒ¡¯¢Öé¹ áÅк觪ÕéÇèÒ ¤ÅÒÊ·Õèµéͧ¡ÒèÐÊÃéÒ§ ÃÇÁ:

         Application: CAutoProjectApp in AutoProject.h and AutoProject.cpp
         Dialog: CAutoProjectDlg in AutoProject.h and AutoProjectDlg.cpp
   						

   ¤ÅÔ¡µ¡Å§à¾×èÍÊÃéÒ§â¤Ã§¡ÒÃ
3. ¡ÅèͧâµéµÍº "IDD_AUTOPROJECT_DIALOG" à»Ô´ã¹ Visual ¾×é¹·Õè¡ÒÃÍ͡Ẻ/á¡éä¢ studio »ÃѺà»ÅÕè¹µÒÁ·Õèá¹Ð¹Óã¹¶Ñ´ä» ¢Ñ鹵͹·ÕèÊͧ
4. àÍÒµÑǤǺ¤ØÁ»éÒª×èÍ (IDC_STATIC) áÅлØèÁ¡àÅÔ¡ (IDCANCEL)
5. à»ÅÕ蹪×èͧ͢»ØèÁ'µ¡Å§'à¾×èÍ "IDRUN" áÅФÓ͸ԺÒÂ੾ÒÐ àÁ×è͵éͧ¡Òà "Ãѹ" »Ô´áºº¿ÍÃìÁÍ͡Ẻ¡ÅèͧâµéµÍº AutoProject.rc
6. ¤ÅÔ¡' ClassWizard 'º¹àÁ¹Ù'ÁØÁÁͧ' (ËÃ×Í¡´ CTRL + W)
7. àÅ×Í¡ IDRUN àÅ×Í¡á·çº¡ÒÃáÁ»¢éͤÇÒÁã¹ÃËÑÊÇѵ¶Ø ÃÒ¡ÒáÅèͧ áÅÐàÅ×Í¡ "BN_CLICKED" 㹡ÅèͧàÅ×Í¡ÃÒ¡ÒâéͤÇÒÁ ¤ÅÔ¡à¾ÔèÁ¿Ñ§¡ìªÑ¹ áÅÐÂÍÁÃѺª×èͿѧ¡ìªÑ¹ "OnRun" ¤ÅÔ¡µ¡Å§à¾×èͻԴ ClassWizard
   
   ËÁÒÂà˵Ø: ¢Ñ鹵͹¹Õéà¾ÔèÁ¡ÒûÃСÒÈÊÓËÃѺÊÁÒªÔ¡¢Í§¿Ñ§¡ìªÑ¹ "OnRun() ¡ÑºËÑÇ¢éÍ ä¿Åìª×èÍ AutoProjectDLG.h ¢Ñ鹵͹¹ÕéÂѧà¾ÔèÁ¡Òà ź¢éÍÁÙÅ㹿ѧ¡ìªÑ¹µÑǨѴ¡ÒâéͤÇÒÁ skeleton ·Õèª×èÍÇèÒ CAutoProjectDlg::OnRun() à¾×èÍ á¿éÁ·Õèª×èÍÇèÒ AutoProjectDLG.cpp
8. ¤ÅÔ¡' ClassWizard 'º¹àÁ¹Ù'ÁØÁÁͧ' (ËÃ×Í¡´ CTRL + W)
9. àÅ×Í¡á·çº Automation ¤ÅÔ¤ÅÒÊà¾ÔèÁ áÅÐàÅ×Í¡" Ẻª¹Ô´äźÃÒÃÕ ¡ÒùӷҧãËéàÅ×Í¡äźÃÒÃÕÇѵ¶ØÊÓËÃѺâ»Ãá¡ÃÁ»ÃÐÂØ¡µì·Õè¤Ø³ µéͧ¡ÒÃâ´ÂÍѵâ¹ÁÑµÔ (ÊÓËÃѺµÑÇÍÂèÒ§¹Õé¡çµÒÁ ¶éҤس¡ÓÅѧ·Ó¡ÒÃâ´ÂÍѵâ¹ÁÑµÔ Excel 97 àÅ×Í¡ äźÃÒÃÕÇѵ¶Ø Microsoft Excel 8.0 µÓá˹觷ÕèµÑé§àÃÔèÁµé¹¤×Í C:\Program Files\Microsoft Office\Office\Excel8.olb)
   
   ¶éҤس·Óâ´ÂÍѵâ¹ÁÑµÔ Microsoft Excel 2000, Microsoft Excel 9.0 ¡ÒÃäźÃÒÃÕÇѵ¶Ø·ÕèàÅ×Í¡·Õè¨Ð µÓá˹觷ÕèµÑé§àÃÔèÁµé¹¤×Í C:\Program Files\Microsoft Office\Office\Excel9.olb
   
   ¶éҤس¡ÓÅѧ·ÓãËé Microsoft Excel 2002 áÅÐ Microsoft Office Excel 2003 â´ÂÍѵâ¹ÁÑµÔ äźÃÒÃÕÇѵ¶Ø·Õè¶Ù¡½Ñ§ÍÂÙèã¹á¿éÁ Excel.exe µÓá˹觷ÕèµÑé§àÃÔèÁµé¹ÊÓËÃѺ Excel.exe ã¹ Office 2002 ¤×Í C:\program Files\Microsoft Office\Office10\Excel.exe µÓá˹觷ÕèµÑé§àÃÔèÁµé¹ÊÓËÃѺ Excel.exe ã¹ Office 2003 C:\program Office\Office11\Excel.exe ¢Í§ Files\Microsoft àÁ×èͤسàÅ×Í¡ äźÃÒÃÕÇѵ¶Ø·ÕèàËÁÒÐÊÁ ¤ÅÔ¡à»Ô´ àÅ×Í¡»ÃÐàÀ·ÊÔ¹¤éÒ·Ñé§ËÁ´ã¹¡ÒÃÂ×¹Âѹ ¤ÅÒÃÒ¡Òà ¨Ò¡¹Ñ鹤ÅÔ¡µ¡Å§
   
   ËÁÒÂà˵Ø: ¡ÅèͧÃÒ¡ÒÃ㹡ÒÃÂ×¹Âѹ ¡ÅèͧâµéµÍº¢Í§¤ÅÒÊ·Õè»ÃСͺ´éÇÂÍÔ¹àµÍÃìà¿Ê IDispatch («Öè§ÁÕ·Ñé§ËÁ´ ẺàÊÁ×͹¨ÃÔ§àËÁ×͹¡Ñº¤ÅÒÊ·Õè) ã¹äźÃÒÃÕª¹Ô´¢Í§ Microsoft Excel 㹡Òà ¤ÃÖè§ÅèÒ§¢Í§¡ÅèͧâµéµÍº·Õè¤Ø³¨ÐàËç¹ÇèÒ ª×èÍá¿éÁ·ÕèÁÕ¡ÒÃãªé§Ò¹ Excel8.cpp »ÃСͺ´éÇ wrappers ¤ÅÒÊ·ÕèÊÃéÒ§ÁÒ¨Ò¡ ColeDispatchDriver() áÅÐá¿éÁËÑÇ¢éÍ»ÃСÒÈ·ÕèàËÁÒÐÊÁ¶Ù¡µÑ駪×èÍÇèÒ Excel8.h (ÊÓËÃѺ Excel 2002 áÅÐ Excel 2003 ä¿Åì·Õèª×èÍ Excel.cpp áÅÐ Excel.h)
10. ¤ÅÔ¡µ¡Å§à¾×èͻԴ¡ÅèͧâµéµÍº MFC ClassWizard
11. à¾ÔèÁÃËÑʵèÍ仹Õéä»Âѧ ¿Ñ§¡ìªÑ¹ CAutoProjectApp::InitInstance() «Öè§âËÅ´ áÅЪèÇÂãËé¡Òà COM äźÃÒÃբͧºÃÔ¡ÒÃ:

          BOOL CAutoProjectApp::InitInstance()
          {
             if(!AfxOleInit())  // Your addition starts here
             {
                AfxMessageBox("Could not initialize COM dll");
                return FALSE;
             }                 // End of your addition
    
             AfxEnableControlContainer();
          .
          .
          .
    
          }
    					

12. à¾ÔèÁÃÒ¡ÒõèͺÃ÷Ѵ#ÃÇÁ¤ÓÊÑ觷Õè¨Ð ´éÒ¹º¹¢Í§á¿éÁâ»Ãá¡ÃÁ AutoProject.cpp:

          #include <afxdisp.h>
    					

13. à¾ÔèÁ§ºÃÇÁÊÓËÃѺ excel8.h ËÅѧ¨Ò¡¡ÒÃÃÇÁµÑÇ ¤ÓªÕéᨧÊÓËÃѺ stdafx.h ÍÂÙè´éÒ¹º¹¢Í§á¿éÁâ»Ãá¡ÃÁ AutoProjectDlg.cpp:

          #include "stdafx.h"
          #include "excel8.h" // excel.h in the case of Excel 2002 and Excel 2003.
    					

14. à¾ÔèÁÃËÑÊ¡Ò÷ӧҹâ´ÂÍѵâ¹ÁѵÔä» CAutoProjectDlg::OnRun() à¾×èÍãËé »ÃÒ¡¯´Ñ§áÊ´§´éÒ¹ÅèÒ§:

          void CAutoProjectDlg::OnRun()
          {
              _Application app;  // app is the Excel _Application object
    
              // Start Excel and get Application object...
             if(!app.CreateDispatch("Excel.Application"))
             {
                AfxMessageBox("Couldn't start Excel.");
             }
             else
             {
                //Make Excel Visible and display a message
              app.SetVisible(TRUE);
              AfxMessageBox ("Excel is Running!");
             }
          }
    					

15. ÊÃéÒ§ áÅÐàÃÕ¡ãªéâ¤Ã§¡Òà ¼ÅÅѾ¸ì: àÁ×èͤس¤ÅÔ¡àÃÕ¡ãªé ¨Ðà»Ô´»ØèÁ㹡ÅèͧâµéµÍº Microsoft Excel à»Ô´ãªé§Ò¹¡Òà ¡ÒÃâµéµÍº Auto_Excel ¡Åèͧ áÅСàÅÔ¡¡Åèͧ¢éͤÇÒÁ Microsoft Excel ¨Ð¨º¡Ò÷ӧҹ àÁ×èͿѧ¡ìªÑ¹ CAutoProjectDlg::OnRun() ¨ÐÊÔé¹Êشŧà¹×èͧ¨Ò¡á;ÅÔपѹ µÑÇá»Ã¨ÐÁÕâÅâ¡é¢Í§¢Íºà¢µ

ËÁÒÂà˵Øà¾ÔèÁàµÔÁ

   Application                           Type Library
   --------------------------------------------------

   Microsoft Access 97                   Msacc8.olb
   Microsoft Jet Database 3.5            DAO350.dll
   Microsoft Binder 97                   Msbdr8.olb
   Microsoft Excel 97                    Excel8.olb
   Microsoft Graph 97                    Graph8.olb
   Microsoft Office 97                   Mso97.dll
   Microsoft Outlook 97                  Msoutl97.olb
   Microsoft PowerPoint 97               Msppt8.olb

   Microsoft Word 97                     Msword8.olb
   Microsoft Access 2000                 Msacc9.olb
   Microsoft Jet Database 3.51           DAO360.dll
   Microsoft Binder 2000                 Msbdr9.olb
   Microsoft Excel 2000                  Excel9.olb
   Microsoft Graph 2000                  Graph9.olb
   Microsoft Office 2000                 Mso9.dll
   Microsoft Outlook 2000                Msoutl9.olb
   Microsoft PowerPoint 2000             Msppt9.olb
   Microsoft Word 2000                   Msword9.olb 

   Microsoft Access 2002                 Msacc.olb
   Microsoft Excel 2002                  Excel.exe
   Microsoft Graph 2002                  Graph.exe 
   Microsoft Office 2002                 MSO.dll
   Microsoft Outlook 2002                MSOutl.olb
   Microsoft PowerPoint 2002             MSPpt.olb
   Microsoft Word 2002                   MSWord.olb

   Microsoft Office Access 2003          Msacc.olb
   Microsoft Office Excel 2003           Excel.exe
   Microsoft Graph 2003                  Graph.exe 
   Microsoft Office 2003                 MSO.dll
   Microsoft Office Outlook 2003         MSOutl.olb
   Microsoft Office PowerPoint 2003      MSPpt.olb
   Microsoft Office Word 2003            MSWord.olb
				

¡ÅѺ仴éÒ¹º¹ | ãËé¢éÍàʹÍá¹Ð