TO HOW: Excel 2000 ??? ???????? ??? ?????? ?????????? ????????? ????

???? ?????? ???? ??????
???? ID: 211926 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

?? ??? ?? ??? ???? ???? Excel 2000 ??? ???????? ??? ?????? ?????????? ????????? ???? ?? ??? ???? ?????? ??? ??? ?????? ?? ???? ?????????, ???????, ?? ?????? ???? ??? ?? ???????? ???? ??????? ???? ?? ??? ???? ?????? ???? ??? ??? ??? ?????? ????? ????????, ???????? ????????, ?? ????? ?? ?? ?????? ?? ????? ?? ????? ????? ???????? ?? ??? ???????? ???? ???? ??? ?? ????? ???? ??????; ???????? ???????? ?? ??? ???????? ?? ????? ?? ??? ????? ????? ???????? ?????? ??? ?? ?????? ?? ???? ?????? ?? ?? ??????? ?? ???? ??????? ?? ???? ????????? ???? ?? pulled ??, ?? ?????? ???? ?????????? ??? ??? ???? ????

?? ?? ???????? ???????? ?? ????? ????, ???????? ??? ??????? ???? ?? ??? ????? ??? ??????? ??? ????? ?? ???? ???:
  • ?? ????? ????? ??? ??? ???? ???? ?? ??? ????? ???? ?? ?? ?? ????? ?????
  • ?? ????? ???? ?? ??? ??? ????????? ?????
  • ???? ?????????? ???? ?? ??? ??????? ?????
?? ???? ?? ????? ???????? ??? ?????? ?? ????? ?? ??? ??????? ?? ????? ???? ???, ?????? ?? ??? ???????? ??? ??? ???? ?? ??? ?????? ????? ??? ???????? ?? ??????, ??? ?? ?? ??? ?????? ???? ???? ????????????? ??? ???? ????????? ?????? ??????? ???? ?? ??? ????? ???? ???? ??? ???? ?? ???? ?????????? ?? ????? ?? ??? ??? ?????? ???? ???? ?? ??? ??? ?????? ???? ?? ?? ????? ?????????? ??? ???? ?????? ???? ?? ???; ?????? ?????????? ??? ???????? ???

??? ???? ??? ?? ??????, ??? ?? ?? ?????????????????? ????? ??? ??? ?????? ???????? ??? ???????? ???? ?? ??? ??? ??? ???? ?? ?? ?????????? ?? ????? ?? ???????? ???? ?????? ?? ????? ?? ??? ??? ?????? ???? ?? ???????? ???? ??; ?????????? ??? ??? ?? ???????? ???? ?? ??? ?????? ???????? ???????? ????

???:: Microsoft ?? ?????? ???? ?? ?????? indefinitely ??? ??????

?????? 1: ????? ???????? ??? ????? ????? ??? ???? ????

  1. ?????? ?? ???? ???? ????????????? ??? ????, ?? ???? ??? ?? ?? ????????????? ??????
  2. ????? ????????:???? ??,????? ???? ??????? ?????? ????-????? ????, ?? ???? ???????? ?? ?????? ?????.
  3. ????? ????,Microsoft Investor ????? Quotes.iqy??????????? ?????????? ????? ??? ??? ????? ?? ???? ????, ?? ???? ??????? ??????? ????.

    ???:: ????????? Files\Microsoft Office\Queries ??????? ??? Microsoft Investor ????? Quotes.iqy ????? ???
  4. ?????Microsoft Excel ??? ????? ???? ?? ??? ??????? ????? ???, ????? ????OK.
  5. ????????????? ??? ???? ????????? ????? ???, ??????msft????? ???, ?? ???? ??? ???OK.
?????????? ?? ??? ??? ??????? ????? ?????? ?? ??? Microsoft Corp. (MSFT) ?? ?? ???

?????? 2: ???? ?? ??? ????????? ????

  1. ????????????? ??? Sheet2 ????, ?? ??? ???? ????msftin cell A1.
  2. With A2 selected, point to????? ???? ??????? ????????? ????????:????, ?? ???? ???Run Saved Query.
  3. ????? ????,Microsoft Investor Stock Quotes.iqy??????????? ?????????? ????? ??? ??? ????? ?? ???? ????, ?? ???? ??????? ??????? ????.
  4. ?????Returning External Data to Microsoft Excel????? ????? ???, ????? ????????????.

    The????????????? ?????,. Notice the option for this Web query uses a prompt for the parameter value.
  5. ?????????????????? ????? ???, ????? ????Get the value from the following cell, click cell A1 to insert the reference=Sheet2!$a$1in the box, and then clickOK.
  6. ????? ????,OK?????Returning External Data to Microsoft Excel????? ????? ?? ??????? ?? ??? ?? ..

    A detailed stock quote for Microsoft Corp. (MSFT) is returned to the worksheet.
  7. ??? A1 ??? Sheet2 ?? ??????? ?? ???? ????? (?????) ????? ?????? ?? ??? ????????? ?????
  8. ????? ????????? ????????? ?????, ????? ???????? ???? ??????? ???
??? A1 ?? ??????? ???? ??, ??????? ??? ????? ?? ?????? ?? ??? ??????? ????? ?????? ?????????? ?? ??? ???? ??? ???

?????? 3: ???????? ??? ??? ????

  1. ????????????? ??? ????? 3 ?? ????, ?? ???? ??? ?????msft???? A1.
  2. A2, ?? ??? ???? ?? ??? ????? ?? ???????? ???? ??????? ????????? ????????:????, ?? ???? ???????? ?? ?????? ?????.
  3. ????? ????,Microsoft Investor ????? Quotes.iqy??????????? ?????????? ????? ??? ??? ????? ?? ???? ????, ?? ???? ??????? ??????? ????.
  4. ?????Microsoft Excel ??? ????? ???? ?? ??? ??????? ????? ???, ????? ????????????.
  5. ?????????????????? ????? ???, ????? ????????? ??? ?? ????? ??????????:msft????? ???, ?? ???? ??? ???OK.
  6. ?????Microsoft Excel ??? ????? ???? ?? ??? ??????? ????? ???, ????? ????OK.

    ?????????? ?? ??? ??? ??????? ????? ?????? ?? ??? Microsoft Corp. (MSFT) ?? ?? ???
  7. ????? ????????? ????????? ?????, ????? ???????? ???? ??????? ???
?? ???? ?? ??? ?? ??? ????? ???? ???, ?? ???? ?????????? ??? ?? ?? ?????? ??? ?? ???? ???????, ??? ???? ????? ????????? ??? ?? ???? ???? ????, ?????????? ?? ??? Microsoft Corp. ?? ??? ??? ?????? ???? ??? ????? ?????? ???? ??? ???

???????? ??? ?? ????????? ???? ?? ??? ???? ????

??? ?? ????? ?????? ??? ?? ??? ???, ???? ???????? ?? ??? ??? ??????? ??? ?? ????? ?? ?? ??? ?? ??? ???? ???????????????? ????? ?? ??????? ?? ??? ?? ..
  1. Sheet3 ??? ?? ??? ?? ?????? ??? ???? ?? ??? ?? ????? ?????
  2. ????? ????????? ????????? ?????, ????? ?????????? ????????????? ???
  3. ?????????????????? ????? ???, ?? ??????? ?? ?????????? ??? ?? ????? ???????? ????? ????? ?? ?????? ?? ??? ????? ???, ?? ???? ??? ????? ????OK.
  4. ????? ????????? ????????? ?????, ????? ???????? ???? ??????? ???
??? ????? ????? ?? ???? ??? 3 ??? ?????? ?? ??? ????? ?????? Sheet3 ??? ????????? ???? ???? ???

??????

??? ?????? ?? ???? ??? ???? ??????? ?? ??? ????? ????Microsoft Excel ???????? ???????????, ????????? ??? ?????? ?????Office ????? ?? ????? ????????, ?? ???? ?????????? ?? ??????

???

???? ID: 211926 - ????? ???????: 02 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft Excel 2000 Standard Edition
??????: 
kbhowtomaster kbweb kbmt KB211926 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:211926

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com