????? ??????

Select the product you need help with

?? ??? ????? ??????? ???????? ??? ??????? ??? CreateObject ?? Excel

???? ???????: 213489 - ??? ???????? ???? ????? ????? ??? ???????.

???????

??? ????? ??? Microsoft Excel ????? ??????? ???????? ?? OLE ???????? ????? CreateObject? ?? ??? ????? ????? ??????? ???????? ???? ??? ?? ???? XLStart ??????? ?????? ?????????.

???? ??? ?????? | ????? ???????

????? ????? ????? ??????? ???????? ????????? ???? Excel ?????? ????? ??? ??????? ?????????? ??? Visual Basic? ????? ???? ??? ???? ????????? ??? ????? ????????? ??? ???? ??????. ??? ????? ??? ??????? ????????? ??????? ?? ??? ????? ??????? ???? ???????.

???? ??? ?????? | ????? ???????

???? ??????

???? Microsoft ??????? ???????? ???? ??????? ???? ??? ?? ???? ???? ?? ????. ?????? ???? ??? ???? ?????? ?? ?????? ???????? ??????? ?????? ???????? ?? ???????? ???? ????. ????? ??? ??????? ??? ????? ??? ??? ??????? ???? ??? ????? ???????? ????????? ?????? ????????? ????????. ???? ??????? ????? ??? Microsoft ??? ????? ????? ????. ??? ????? ?? ???? ?? ?????? ?????? ??? ??????? ?????? ????? ?????? ?? ????? ??????? ???????? ???????? ??????.

?????? ??? ????? ?????? ??? ????? Excel ????? ??????? ???????? ?? OLE? ?? ?????? ??????? ???????? ???????. ????? ??? ????? ??? ??? ???????.

?????? Microsoft Office Excel 2007

Sub LoadAddin()

   ' ????? ????? xl ???? ????.
   Dim xl As Object

   ' ?? ?????? Microsoft Excel xl ??????? ??? ??????? xl.
   Set XL = CreateObject("Excel.Application")?

   ' ???? ??? ??????? ???????? ???? ?????? ????? ??? ?? ??? ??????? XLQUERY.XLAM.
   XL.Workbooks.Open (XL.librarypath & "\MSQUERY\XLQUERY.XLAM")?

   ' ??? ??? ????? ??? ????? ??????? ????????
   ' ???????? ?? ???? (XLL)? ?????? ????? RegisterXLL.
   ' ?? ?????? ?????? ?? ????? ???? ?????
   ' Analys32.xll.
   ' XL.RegisterXLL "Analys32.xll"

   ' ?? ?????? ?? ????? ?????? ????? ?? ??? ??????? ????????
   ' ?? ???? ??????? ???????? ????? ???? ???? ??? ???????
   ' ???????? ??????? "???".
   XL.Workbooks("xlquery.xlam").RunAutoMacros 1

   Set XL = Nothing
 End Sub

??????? Microsoft Office Excel 2003 ?????????? ??????? ?? ?????? Excel

Sub LoadAddin()

   ' ????? ????? xl ???? ????.
   Dim xl As Object

   ' ?? ?????? Microsoft Excel xl ??????? ??? ??????? xl.
   Set XL = CreateObject("Excel.Application")?

   ' ??? ??? ??????? ???????? ???? ?????? ?? ??? ??????? XLQUERY.XLA.
   XL.Workbooks.Open (XL.librarypath & "\MSQUERY\XLQUERY.XLA")?

   ' ??? ??? ????? ??? ????? ??????? ????????
   ' ???????? ?? ???? (XLL)? ?????? ????? RegisterXLL.
   ' ?? ?????? ?????? ?? ????? ???? ?????
   ' Analys32.xll.
   ' XL.RegisterXLL "Analys32.xll"

   ' ?? ?????? ?? ????? ?????? ????? ?? ??? ??????? ????????
   ' ?? ???? ??????? ???????? ????? ???? ???? ??? ???????
   ' ???????? ??????? "???".
   XL.Workbooks("xlquery.xla").RunAutoMacros 1

   Set XL = Nothing
 End Sub

???? ??? ?????? | ????? ???????

??????? ????

????? ???? ????? ???? ???????? Excel ????? ??????? ???????? ?? OLE ???? ?? ????? ????? ?????? ?? ????? ?? ???? XLStart? ??? ???? ?????? ?????? ?? ????? ???????. ??? ???? ????? ????? ?????? ?????? ??????? ??????.

????? ??? ?????? ??? ???? ????? ????? ?? ??????? ??? ????? ?? ??????? ??? ??????? ??? ???? Excel ?? ??????? ????? ??? ???????? ?????? ????? CreateObject. ??? ???? ????? ???? ???? ???????? ??? ??? ?????? ????? ?????? Excel ??? ??? ??????? ??? ????? ????? ?????? ?? ?????.

???? ??? ?????? | ????? ???????

?????

????? ?? ????????? ??? ????? ?????? ??? ?????? Visual Basic for Applications? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":

226118

(http://support.microsoft.com/kb/226118/ )

????? ?? ??????? ???????? ???????? ??? ???? ????? Visual Basic for Applications (????? ?? ??? ?????? ???)

???? ??? ?????? | ????? ???????

???????

???? ???????: 213489 - ????? ??? ??????: 20/????/1432 - ??????: 2.0

????? ???