跟我學(xué)VBA我這里專注VBA, 授人以漁。我98年開始從源碼接觸VBA已經(jīng)20余年了隨著年齡的增長越來越覺得有必要把這項技能傳遞給需要這項技術(shù)的職場人員。希望職場和數(shù)據(jù)打交道的朋友都來學(xué)習VBA,利用VBA,起碼可以提高自己的工作效率可以有時間多陪陪父母多陪陪家人何樂而不為呢我的教程一共九套從入門開始一直講到程序的分發(fā)是學(xué)習利用VBA的實用教程。這份API資料是隨高級教程贈送的。這些內(nèi)容是MS的權(quán)威資料看似枯燥但對于想學(xué)習API函數(shù)的朋友是非常有用的。這講我們繼續(xù)學(xué)習VBA 64位API聲明語句第025講【分享成果隨喜正能量】一般薄福之人從來不懂感恩。古人云:“一碗米養(yǎng)恩人一擔米養(yǎng)仇人。”薄福的人活在自我錯誤的認知世界里個性固執(zhí)且多疑總是被情緒牽著鼻子走。既然有幸遇到佛法首先要打開自己的心胸去除心魔常懷感恩心。多積福積德幸運之神一定會眷顧你。至于有些負能量的人你度不了他那就選擇遠離。修行需要清靜無論環(huán)境還是心情。Const R2_NOTXORPEN 10 DPxnConst R2_NOP 11 DConst R2_MERGENOTPEN 12 DPnoConst R2_COPYPEN 13 PConst R2_MERGEPENNOT 14 PDnoConst R2_MERGEPEN 15 DPoConst R2_WHITE 16 1Const R2_LAST 16 Ternary raster operationsConst SRCCOPY HCC0020 (DWORD) dest sourceConst SRCPAINT HEE0086 (DWORD) dest source OR destConst SRCAND H8800C6 (DWORD) dest source AND destConst SRCINVERT H660046 (DWORD) dest source XOR destConst SRCERASE H440328 (DWORD) dest source AND (NOT dest )Const NOTSRCCOPY H330008 (DWORD) dest (NOT source)Const NOTSRCERASE H1100A6 (DWORD) dest (NOT src) AND (NOT dest)Const MERGECOPY HC000CA (DWORD) dest (source AND pattern)Const MERGEPAINT HBB0226 (DWORD) dest (NOT source) OR destConst PATCOPY HF00021 (DWORD) dest patternConst PATPAINT HFB0A09 (DWORD) dest DPSnooConst PATINVERT H5A0049 (DWORD) dest pattern XOR destConst DSTINVERT H550009 (DWORD) dest (NOT dest)Const BLACKNESS H42 (DWORD) dest BLACKConst WHITENESS HFF0062 (DWORD) dest WHITEConst GDI_ERROR HFFFFFFFFConst HGDI_ERROR As LongPtr -1 -1 Long (HFFFFFFFF) on 32-bit VBA; -1 LongLong (HFFFFFFFFFFFFFFFF^) on 64-bit VBA Region FlagsConst ERRORAPI 0Const NULLREGION 1Const SIMPLEREGION 2Const COMPLEXREGION 3 CombineRgn() StylesConst RGN_AND 1Const RGN_OR 2Const RGN_XOR 3Const RGN_DIFF 4Const RGN_COPY 5Const RGN_MIN RGN_ANDConst RGN_MAX RGN_COPY StretchBlt() ModesConst BLACKONWHITE 1Const WHITEONBLACK 2Const COLORONCOLOR 3Const HALFTONE 4Const MAXSTRETCHBLTMODE 4 PolyFill() ModesConst ALTERNATE 1Const WINDING 2Const POLYFILL_LAST 2 Text Alignment OptionsConst TA_NOUPDATECP 0Const TA_UPDATECP 1Const TA_LEFT 0Const TA_RIGHT 2Const TA_CENTER 6Const TA_TOP 0Const TA_BOTTOM 8Const TA_BASELINE 24Const TA_MASK (TA_BASELINE TA_CENTER TA_UPDATECP)Const VTA_BASELINE TA_BASELINEConst VTA_LEFT TA_BOTTOMConst VTA_RIGHT TA_TOPConst VTA_CENTER TA_CENTERConst VTA_BOTTOM TA_RIGHTConst VTA_TOP TA_LEFTConst ETO_GRAYED 1Const ETO_OPAQUE 2Const ETO_CLIPPED 4Const ASPECT_FILTERING H1Const DCB_RESET H1Const DCB_ACCUMULATE H2Const DCB_DIRTY DCB_ACCUMULATEConst DCB_SET (DCB_RESET Or DCB_ACCUMULATE)Const DCB_ENABLE H4Const DCB_DISABLE H8 Metafile FunctionsConst META_SETBKCOLOR H201Const META_SETBKMODE H102Const META_SETMAPMODE H103Const META_SETROP2 H104Const META_SETRELABS H105Const META_SETPOLYFILLMODE H106Const META_SETSTRETCHBLTMODE H107Const META_SETTEXTCHAREXTRA H108Const META_SETTEXTCOLOR H209Const META_SETTEXTJUSTIFICATION H20AConst META_SETWINDOWORG H20BConst META_SETWINDOWEXT H20CConst META_SETVIEWPORTORG H20DConst META_SETVIEWPORTEXT H20EConst META_OFFSETWINDOWORG H20FConst META_SCALEWINDOWEXT H410Const META_OFFSETVIEWPORTORG H211Const META_SCALEVIEWPORTEXT H412Const META_LINETO H213Const META_MOVETO H214Const META_EXCLUDECLIPRECT H415Const META_INTERSECTCLIPRECT H416Const META_ARC H817Const META_ELLIPSE H418Const META_FLOODFILL H419Const META_PIE H81AConst META_RECTANGLE H41BConst META_ROUNDRECT H61CConst META_PATBLT H61DConst META_SAVEDC H1EConst META_SETPIXEL H41FConst META_OFFSETCLIPRGN H220Const META_TEXTOUT H521Const META_BITBLT H922Const META_STRETCHBLT HB23Const META_POLYGON H324Const META_POLYLINE H325Const META_ESCAPE H626Const META_RESTOREDC H127Const META_FILLREGION H228Const META_FRAMEREGION H429Const META_INVERTREGION H12AConst META_PAINTREGION H12BConst META_SELECTCLIPREGION H12CConst META_SELECTOBJECT H12DConst META_SETTEXTALIGN H12EConst META_CHORD H830Const META_SETMAPPERFLAGS H231Const META_EXTTEXTOUT HA32Const META_SETDIBTODEV HD33Const META_SELECTPALETTE H234Const META_REALIZEPALETTE H35Const META_ANIMATEPALETTE H436Const META_SETPALENTRIES H37Const META_POLYPOLYGON H538Const META_RESIZEPALETTE H139Const META_DIBBITBLT H940Const META_DIBSTRETCHBLT HB41Const META_DIBCREATEPATTERNBRUSH H142Const META_STRETCHDIB HF43Const META_EXTFLOODFILL H548Const META_DELETEOBJECT H1F0Const META_CREATEPALETTE HF7Const META_CREATEPATTERNBRUSH H1F9Const META_CREATEPENINDIRECT H2FAConst META_CREATEFONTINDIRECT H2FBConst META_CREATEBRUSHINDIRECT H2FCConst META_CREATEREGION H6FF GDI EscapesConst NEWFRAME 1Const AbortDocC 2Const NEXTBAND 3Const SETCOLORTABLE 4Const GETCOLORTABLE 5Const FLUSHOUTPUT 6Const DRAFTMODE 7Const QUERYESCSUPPORT 8Const SETABORTPROC 9Const StartDocC 10當學(xué)員學(xué)習到高級階段如果引用API這個資料可以直接查到64位寫法。大多數(shù)情況下我們是將低版本的程序文件升級到高版本這時您就不必為如下的錯誤提示所困擾了我20多年的VBA實踐經(jīng)驗全部濃縮在下面的各個教程中 VBA 64位API聲明語句第025講
跟我學(xué)VBA我這里專注VBA, 授人以漁。我98年開始從源碼接觸VBA已經(jīng)20余年了隨著年齡的增長越來越覺得有必要把這項技能傳遞給需要這項技術(shù)的職場人員。希望職場和數(shù)據(jù)打交道的朋友都來學(xué)習VBA,利用VBA,起碼可以提高自己的工作效率可以有時間多陪陪父母多陪陪家人何樂而不為呢我的教程一共九套從入門開始一直講到程序的分發(fā)是學(xué)習利用VBA的實用教程。這份API資料是隨高級教程贈送的。這些內(nèi)容是MS的權(quán)威資料看似枯燥但對于想學(xué)習API函數(shù)的朋友是非常有用的。這講我們繼續(xù)學(xué)習VBA 64位API聲明語句第025講【分享成果隨喜正能量】一般薄福之人從來不懂感恩。古人云:“一碗米養(yǎng)恩人一擔米養(yǎng)仇人。”薄福的人活在自我錯誤的認知世界里個性固執(zhí)且多疑總是被情緒牽著鼻子走。既然有幸遇到佛法首先要打開自己的心胸去除心魔常懷感恩心。多積福積德幸運之神一定會眷顧你。至于有些負能量的人你度不了他那就選擇遠離。修行需要清靜無論環(huán)境還是心情。Const R2_NOTXORPEN 10 DPxnConst R2_NOP 11 DConst R2_MERGENOTPEN 12 DPnoConst R2_COPYPEN 13 PConst R2_MERGEPENNOT 14 PDnoConst R2_MERGEPEN 15 DPoConst R2_WHITE 16 1Const R2_LAST 16 Ternary raster operationsConst SRCCOPY HCC0020 (DWORD) dest sourceConst SRCPAINT HEE0086 (DWORD) dest source OR destConst SRCAND H8800C6 (DWORD) dest source AND destConst SRCINVERT H660046 (DWORD) dest source XOR destConst SRCERASE H440328 (DWORD) dest source AND (NOT dest )Const NOTSRCCOPY H330008 (DWORD) dest (NOT source)Const NOTSRCERASE H1100A6 (DWORD) dest (NOT src) AND (NOT dest)Const MERGECOPY HC000CA (DWORD) dest (source AND pattern)Const MERGEPAINT HBB0226 (DWORD) dest (NOT source) OR destConst PATCOPY HF00021 (DWORD) dest patternConst PATPAINT HFB0A09 (DWORD) dest DPSnooConst PATINVERT H5A0049 (DWORD) dest pattern XOR destConst DSTINVERT H550009 (DWORD) dest (NOT dest)Const BLACKNESS H42 (DWORD) dest BLACKConst WHITENESS HFF0062 (DWORD) dest WHITEConst GDI_ERROR HFFFFFFFFConst HGDI_ERROR As LongPtr -1 -1 Long (HFFFFFFFF) on 32-bit VBA; -1 LongLong (HFFFFFFFFFFFFFFFF^) on 64-bit VBA Region FlagsConst ERRORAPI 0Const NULLREGION 1Const SIMPLEREGION 2Const COMPLEXREGION 3 CombineRgn() StylesConst RGN_AND 1Const RGN_OR 2Const RGN_XOR 3Const RGN_DIFF 4Const RGN_COPY 5Const RGN_MIN RGN_ANDConst RGN_MAX RGN_COPY StretchBlt() ModesConst BLACKONWHITE 1Const WHITEONBLACK 2Const COLORONCOLOR 3Const HALFTONE 4Const MAXSTRETCHBLTMODE 4 PolyFill() ModesConst ALTERNATE 1Const WINDING 2Const POLYFILL_LAST 2 Text Alignment OptionsConst TA_NOUPDATECP 0Const TA_UPDATECP 1Const TA_LEFT 0Const TA_RIGHT 2Const TA_CENTER 6Const TA_TOP 0Const TA_BOTTOM 8Const TA_BASELINE 24Const TA_MASK (TA_BASELINE TA_CENTER TA_UPDATECP)Const VTA_BASELINE TA_BASELINEConst VTA_LEFT TA_BOTTOMConst VTA_RIGHT TA_TOPConst VTA_CENTER TA_CENTERConst VTA_BOTTOM TA_RIGHTConst VTA_TOP TA_LEFTConst ETO_GRAYED 1Const ETO_OPAQUE 2Const ETO_CLIPPED 4Const ASPECT_FILTERING H1Const DCB_RESET H1Const DCB_ACCUMULATE H2Const DCB_DIRTY DCB_ACCUMULATEConst DCB_SET (DCB_RESET Or DCB_ACCUMULATE)Const DCB_ENABLE H4Const DCB_DISABLE H8 Metafile FunctionsConst META_SETBKCOLOR H201Const META_SETBKMODE H102Const META_SETMAPMODE H103Const META_SETROP2 H104Const META_SETRELABS H105Const META_SETPOLYFILLMODE H106Const META_SETSTRETCHBLTMODE H107Const META_SETTEXTCHAREXTRA H108Const META_SETTEXTCOLOR H209Const META_SETTEXTJUSTIFICATION H20AConst META_SETWINDOWORG H20BConst META_SETWINDOWEXT H20CConst META_SETVIEWPORTORG H20DConst META_SETVIEWPORTEXT H20EConst META_OFFSETWINDOWORG H20FConst META_SCALEWINDOWEXT H410Const META_OFFSETVIEWPORTORG H211Const META_SCALEVIEWPORTEXT H412Const META_LINETO H213Const META_MOVETO H214Const META_EXCLUDECLIPRECT H415Const META_INTERSECTCLIPRECT H416Const META_ARC H817Const META_ELLIPSE H418Const META_FLOODFILL H419Const META_PIE H81AConst META_RECTANGLE H41BConst META_ROUNDRECT H61CConst META_PATBLT H61DConst META_SAVEDC H1EConst META_SETPIXEL H41FConst META_OFFSETCLIPRGN H220Const META_TEXTOUT H521Const META_BITBLT H922Const META_STRETCHBLT HB23Const META_POLYGON H324Const META_POLYLINE H325Const META_ESCAPE H626Const META_RESTOREDC H127Const META_FILLREGION H228Const META_FRAMEREGION H429Const META_INVERTREGION H12AConst META_PAINTREGION H12BConst META_SELECTCLIPREGION H12CConst META_SELECTOBJECT H12DConst META_SETTEXTALIGN H12EConst META_CHORD H830Const META_SETMAPPERFLAGS H231Const META_EXTTEXTOUT HA32Const META_SETDIBTODEV HD33Const META_SELECTPALETTE H234Const META_REALIZEPALETTE H35Const META_ANIMATEPALETTE H436Const META_SETPALENTRIES H37Const META_POLYPOLYGON H538Const META_RESIZEPALETTE H139Const META_DIBBITBLT H940Const META_DIBSTRETCHBLT HB41Const META_DIBCREATEPATTERNBRUSH H142Const META_STRETCHDIB HF43Const META_EXTFLOODFILL H548Const META_DELETEOBJECT H1F0Const META_CREATEPALETTE HF7Const META_CREATEPATTERNBRUSH H1F9Const META_CREATEPENINDIRECT H2FAConst META_CREATEFONTINDIRECT H2FBConst META_CREATEBRUSHINDIRECT H2FCConst META_CREATEREGION H6FF GDI EscapesConst NEWFRAME 1Const AbortDocC 2Const NEXTBAND 3Const SETCOLORTABLE 4Const GETCOLORTABLE 5Const FLUSHOUTPUT 6Const DRAFTMODE 7Const QUERYESCSUPPORT 8Const SETABORTPROC 9Const StartDocC 10當學(xué)員學(xué)習到高級階段如果引用API這個資料可以直接查到64位寫法。大多數(shù)情況下我們是將低版本的程序文件升級到高版本這時您就不必為如下的錯誤提示所困擾了我20多年的VBA實踐經(jīng)驗全部濃縮在下面的各個教程中