网站建设 部署与发布题库,工业和信息化部网站备案管理系统,如何做企业网站内链,平安建设网站跟我学VBA#xff0c;我这里专注VBA, 授人以渔。我98年开始#xff0c;从源码接触VBA已经20余年了#xff0c;随着年龄的增长#xff0c;越来越觉得有必要把这项技能传递给需要这项技术的职场人员。希望职场和数据打交道的朋友#xff0c;都来学习VBA,利用VBA,起码可以提高…跟我学VBA我这里专注VBA, 授人以渔。我98年开始从源码接触VBA已经20余年了随着年龄的增长越来越觉得有必要把这项技能传递给需要这项技术的职场人员。希望职场和数据打交道的朋友都来学习VBA,利用VBA,起码可以提高自己的工作效率可以有时间多陪陪父母多陪陪家人何乐而不为呢我的教程一共九套从入门开始一直讲到程序的分发是学习利用VBA的实用教程。这份API资料是随高级教程赠送的.
这讲我们继续学习64位Office API声明语句第112讲这些内容是MS的权威资料看似枯燥但对于想学习API函数的朋友是非常有用的。 【分享成果随喜正能量】如果我们真的有在平时认真的去修行随着我们的修行时间的变化我们自己的你相貌也会随之改变的风度变了、仪态变了会和从前大不一样的在现代这个定义应该是体质的变化你功夫越得力你会发现过去有些毛病现在毛病没有了;从前精神常常提不起来现在精神饱满、容光焕发。。 当学员学习到高级阶段如果引用API这个资料可以直接查到64位写法。大多数情况下我们是将低版本的程序文件升级到高版本这时您就不必为如下的错误提示所困扰了 SpeakerVolume for MODEMSETTINGS
Const MDMVOL_LOW H0
Const MDMVOL_MEDIUM H1
Const MDMVOL_HIGH H2 SpeakerMode for MODEMDEVCAPS
Const MDMSPKRFLAG_OFF H1
Const MDMSPKRFLAG_DIAL H2
Const MDMSPKRFLAG_ON H4
Const MDMSPKRFLAG_CALLSETUP H8 SpeakerMode for MODEMSETTINGS
Const MDMSPKR_OFF H0
Const MDMSPKR_DIAL H1
Const MDMSPKR_ON H2
Const MDMSPKR_CALLSETUP H3 Modem Options
Const MDM_COMPRESSION H1
Const MDM_ERROR_CONTROL H2
Const MDM_FORCED_EC H4
Const MDM_CELLULAR H8
Const MDM_FLOWCONTROL_HARD H10
Const MDM_FLOWCONTROL_SOFT H20
Const MDM_CCITT_OVERRIDE H40
Const MDM_SPEED_ADJUST H80
Const MDM_TONE_DIAL H100
Const MDM_BLIND_DIAL H200
Const MDM_V23_OVERRIDE H400 ***************************************************************************** * * shellapi.h - SHELL.DLL functions, types, and definitions * * * * Copyright (c) 1992-1995, Microsoft Corp. All rights reserved * * * \*****************************************************************************/ Declare PtrSafe Function DragQueryFile Lib shell32.dll Alias DragQueryFileA (ByVal HDROP As LongPtr, ByVal UINT As Long, ByVal lpStr As String, ByVal ch As Long) As Long
Declare PtrSafe Function DragQueryPoint Lib shell32.dll Alias DragQueryPoint (ByVal HDROP As LongPtr, lpPoint As POINTAPI) As Long
Declare PtrSafe Sub DragFinish Lib shell32.dll Alias DragFinish (ByVal hDrop As LongPtr)
Declare PtrSafe Sub DragAcceptFiles Lib shell32.dll Alias DragAcceptFiles (ByVal hwnd As LongPtr, ByVal fAccept As Long)
Declare PtrSafe Function ShellExecute Lib shell32.dll Alias ShellExecuteA (ByVal hwnd As LongPtr, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As LongPtr
Declare PtrSafe Function FindExecutable Lib shell32.dll Alias FindExecutableA (ByVal lpFile As String, ByVal lpDirectory As String, ByVal lpResult As String) As LongPtr Declare PtrSafe Function ShellAbout Lib shell32.dll Alias ShellAboutA (ByVal hwnd As LongPtr, ByVal szApp As String, ByVal szOtherStuff As String, ByVal hIcon As LongPtr) As Long
Declare PtrSafe Function DuplicateIcon Lib shell32.dll Alias DuplicateIcon (ByVal hInst As LongPtr, ByVal hIcon As LongPtr) As LongPtr
Declare PtrSafe Function ExtractAssociatedIcon Lib shell32.dll Alias ExtractAssociatedIconA (ByVal hInst As LongPtr, ByVal lpIconPath As String, lpiIcon As Long) As LongPtr
Declare PtrSafe Function ExtractIcon Lib shell32.dll Alias ExtractIconA (ByVal hInst As LongPtr, ByVal lpszExeFileName As String, ByVal nIconIndex As Long) As LongPtr Type DRAGINFO
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;uSize As Long init with sizeof(DRAGINFO)
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;pt As POINTAPI
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;fNC As Long
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;lpFileList As String
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;grfKeyState As Long
End Type // AppBar stuff Const ABM_NEW H0
Const ABM_REMOVE H1
Const ABM_QUERYPOS H2
Const ABM_SETPOS H3
Const ABM_GETSTATE H4
Const ABM_GETTASKBARPOS H5
Const ABM_ACTIVATE H6 lParam TRUE/FALSE means activate/deactivate
Const ABM_GETAUTOHIDEBAR H7
Const ABM_SETAUTOHIDEBAR H8 this can fail at any time. MUST check the result
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; lParam TRUE/FALSE Set/Unset
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; uEdge what edge
Const ABM_WINDOWPOSCHANGED H9 these are put in the wparam of callback messages
Const ABN_STATECHANGE H0
Const ABN_POSCHANGED H1
Const ABN_FULLSCREENAPP H2
Const ABN_WINDOWARRANGE H3 lParam TRUE means hide flags for get state Const ABS_AUTOHIDE H1
Const ABS_ALWAYSONTOP H2
Const ABE_LEFT 0
Const ABE_TOP 1
Const ABE_RIGHT 2
Const ABE_BOTTOM 3 Type APPBARDATA
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;cbSize As Long
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;hwnd As LongPtr
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;uCallbackMessage As Long
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;uEdge As Long
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;rc As RECT
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;lParam As LongPtr message specific
End Type Declare PtrSafe Function SHAppBarMessage Lib shell32.dll Alias SHAppBarMessage (ByVal dwMessage As Long, pData As APPBARDATA) As LongPtr // EndAppBar Declare PtrSafe Function DoEnvironmentSubst Lib shell32.dll Alias DoEnvironmentSubstA (ByVal szString As String, ByVal cbString As Long) As Long Declare PtrSafe Function ExtractIconEx Lib shell32.dll Alias ExtractIconExA (ByVal lpszFile As String, ByVal nIconIndex As Long, phiconLarge As LongPtr, phiconSmall As LongPtr, ByVal nIcons As Long) As Long // Shell File Operations Const FO_MOVE H1
Const FO_COPY H2
Const FO_DELETE H3
Const FO_RENAME H4
Const FOF_MULTIDESTFILES H1
Const FOF_CONFIRMMOUSE H2
Const FOF_SILENT H4 dont create progress/report
Const FOF_RENAMEONCOLLISION H8
Const FOF_NOCONFIRMATION H10 Dont prompt the user.
Const FOF_WANTMAPPINGHANDLE H20 Fill in SHFILEOPSTRUCT.hNameMappings
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Must be freed using SHFreeNameMappings
Const FOF_ALLOWUNDO H40
Const FOF_FILESONLY H80 on *.*, do only files
Const FOF_SIMPLEPROGRESS H100 means dont show names of files
Const FOF_NOCONFIRMMKDIR H200 dont confirm making any needed dirs Const PO_DELETE H13 printer is being deleted
Const PO_RENAME H14 printer is being renamed
Const PO_PORTCHANGE H20 port this printer connected to is being changed
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; if this id is set, the strings received by
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; the copyhook are a doubly-null terminated
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; list of strings. The first is the printer
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; name and the second is the printer port.
Const PO_REN_PORT H34 PO_RENAME and PO_PORTCHANGE at same time. no POF_ flags currently defined implicit parameters are: if pFrom or pTo are unqualified names the current directories are taken from the global current drive/directory settings managed by Get/SetCurrentDrive/Directory the global confirmation settings Type SHFILEOPSTRUCT
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;hwnd As LongPtr
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;wFunc As Long
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;pFrom As String
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;pTo As String
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;fFlags As Integer
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;fAnyOperationsAborted As Long
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;hNameMappings As LongPtr
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;lpszProgressTitle As String only used if FOF_SIMPLEPROGRESS
End Type 我20多年的VBA实践经验全部浓缩在下面的各个教程中
