Option Explicit<\/p>\n\n\n\n
Private Type OPENFILENAME
lStructSize As Long
hwnd As Long
hInstance As Long
lpstrFilter As String
lpstrCustomFilter As String
nMaxCustFilter As Long
nFilterIndex As Long
lpstrFile As String
nMaxFile As Long
lpstrFileTitle As String
nMaxFileTitle As Long
lpstrInitialDir As String
lpstrTitle As String
Flags As Long
nFileOffset As Integer
nFileExtension As Integer
lpstrDefExt As String
lCustData As Long
lpfnHook As Long
lpTemplateName As String
End Type<\/p>\n\n\n\n
Private Type COLORSTRUC
lStructSize As Long
hwnd As Long
hInstance As Long
rgbResult As Long
lpCustColors As String
Flags As Long
lCustData As Long
lpfnHook As Long
lpTemplateName As String
End Type<\/p>\n\n\n\n
Private Const LF_FACESIZE = 32<\/p>\n\n\n\n
Private Type LogFont
lfHeight As Long
lfWidth As Long
lfEscapement As Long
lfOrientation As Long
lfWeight As Long
lfItalic As Byte
lfUnderline As Byte
lfStrikeOut As Byte
lfCharSet As Byte
lfOutPrecision As Byte
lfClipPrecision As Byte
lfQuality As Byte
lfPitchAndFamily As Byte
lfFaceName(LF_FACESIZE) As Byte
End Type<\/p>\n\n\n\n
Private Type FONTSTRUC
lStructSize As Long
hwnd As Long
hDC As Long
lpLogFont As Long
iPointSize As Long
Flags As Long
rgbColors As Long
lCustData As Long
lpfnHook As Long
lpTemplateName As String
hInstance As Long
lpszStyle As String
nFontType As Integer
MISSING_ALIGNMENT As Integer
nSizeMin As Long
nSizeMax As Long
End Type<\/p>\n\n\n\n
Public Type DEVMODE
dmDeviceName As String * 32
dmSpecVersion As Integer
dmDriverVersion As Integer
dmSize As Integer
dmDriverExtra As Integer
dmFields As Long
dmOrientation As Integer
dmPaperSize As Integer
dmPaperLength As Integer
dmPaperWidth As Integer
dmScale As Integer
dmCopies As Integer
dmDefaultSource As Integer
dmPrintQuality As Integer
dmColor As Integer
dmDuplex As Integer
dmYResolution As Integer
dmTTOption As Integer
dmCollate As Integer
dmFormName As String * 32
dmUnusedPadding As Integer
dmBitsPerPel As Integer
dmPelsWidth As Long
dmPelsHeight As Long
dmDisplayFlags As Long
dmDisplayFreq As Long
End Type<\/p>\n\n\n\n
Private Type PRINTDLGSTRUC
lStructSize As Long
hwnd As Long
hDevMode As Long
hDevNames As Long
hDC As Long
Flags As Long
nFromPage As Integer
nToPage As Integer
nMinPage As Integer
nMaxPage As Integer
nCopies As Integer
hInstance As Long
lCustData As Long
lpfnPrintHook As Long
lpfnSetupHook As Long
lpPrintTemplateName As String
lpSetupTemplateName As String
hPrintTemplate As Long
hSetupTemplate As Long
End Type<\/p>\n\n\n\n
Public Type PRINTPROPS
Cancel As Boolean
Device As String
Copies As Integer
Collate As Boolean
File As Boolean
All As Boolean
Pages As Boolean
Selection As Boolean
FromPage As Integer
ToPage As Integer
DM As DEVMODE
End Type<\/p>\n\n\n\n
Private Type SHITEMID
cb As Long
abID As Byte
End Type<\/p>\n\n\n\n
Private Type ITEMIDLIST
mkid As SHITEMID
End Type<\/p>\n\n\n\n
Private Type BROWSEINFO
hOwner As Long \u2018\u4e3b\u53e5\u67c4
pidlRoot As Long \u2018\u5c55\u5f00\u6839\u76ee\u5f55
pszDisplayName As String
lpszTitle As String \u2018\u5217\u8868\u6846\u6807\u9898,\u8fd9\u91cc\u662f\u7528\u7684long,\u6240\u4ee5\u5f97\u7528lstrcat\u83b7\u53d6\u5b57\u7b26\u6307\u9488\u4e86
ulFlags As Long \u2018\u89c4\u5b9a\u53ea\u80fd\u9009\u62e9\u6587\u4ef6\u5939\uff0c\u5176\u4ed6\u65e0\u6548
\u2018lpfn As Long
lpfnCallback As Long
lParam As Long
iImage As Long
End Type<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ Win32s (Private Functions for Wrappers Below)
\u2018\/\/<\/p>\n\n\n\n
Private Declare Function GetOpenFileName Lib \u201ccomdlg32.dll\u201d Alias \u201cGetOpenFileNameA\u201d (pOpenfilename As OPENFILENAME) As Long
Private Declare Function GetSaveFileName Lib \u201ccomdlg32.dll\u201d Alias \u201cGetSaveFileNameA\u201d (pOpenfilename As OPENFILENAME) As Long
Private Declare Function PrintDlg Lib \u201ccomdlg32.dll\u201d Alias \u201cPrintDlgA\u201d (pPrintdlg As PRINTDLGSTRUC) As Long
Private Declare Function ChooseColor Lib \u201ccomdlg32.dll\u201d Alias \u201cChooseColorA\u201d (pChoosecolor As COLORSTRUC) As Long
Private Declare Function ChooseFont Lib \u201ccomdlg32.dll\u201d Alias \u201cChooseFontA\u201d (pChoosefont As FONTSTRUC) As Long
Private Declare Function GlobalAlloc Lib \u201ckernel32\u201d (ByVal wFlags As Long, ByVal dwBytes As Long) As Long
Private Declare Function GlobalFree Lib \u201ckernel32\u201d (ByVal hMem As Long) As Long
Private Declare Function GlobalLock Lib \u201ckernel32\u201d (ByVal hMem As Long) As Long
Private Declare Function GlobalUnlock Lib \u201ckernel32\u201d (ByVal hMem As Long) As Long
Private Declare Sub CopyMemory Lib \u201ckernel32\u201d Alias \u201cRtlMoveMemory\u201d (hpvDest As Any, hpvSource As Any, ByVal cbCopy As Long)
Private Declare Function SHGetPathFromIDList Lib \u201cshell32.dll\u201d Alias \u201cSHGetPathFromIDListA\u201d (ByVal pidl As Long, ByVal pszPath As String) As Long
Private Declare Function SHGetSpecialFolderLocation Lib \u201cshell32.dll\u201d (ByVal hwndOwner As Long, ByVal nFolder As Long, pidl As ITEMIDLIST) As Long
Private Declare Function SHBrowseForFolder Lib \u201cshell32.dll\u201d Alias \u201cSHBrowseForFolderA\u201d (lpBrowseInfo As BROWSEINFO) As Long \u2018ITEMIDLIST
Private Declare Function WriteProfileString Lib \u201ckernel32\u201d Alias \u201cWriteProfileStringA\u201d (ByVal lpszSection As String, ByVal lpszKeyName As String, ByVal lpszString As String) As Long
Private Declare Function GetProfileString Lib \u201ckernel32\u201d Alias \u201cGetProfileStringA\u201d (ByVal lpAppName As String, ByVal lpKeyName As String, ByVal lpDefault As String, ByVal lpReturnedString As String, ByVal nSize As Long) As Long
Private Declare Function SendMessageByString Lib \u201cuser32\u201d Alias \u201cSendMessageA\u201d (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, ByVal lParam As String) As Long
Private Declare Function SendMessage Lib \u201cuser32\u201d Alias \u201cSendMessageA\u201d (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, ByVal IParam As String) As Long
Private Declare Function lstrcat Lib \u201ckernel32\u201d Alias \u201clstrcatA\u201d (ByVal lpStringl As String, ByVal lpString2 As String) As Long
Private Declare Sub CoTaskMemFree Lib \u201cole32.dll\u201d (ByVal hMem As Long)
\u2018\/\/
\u2018\/\/ Win32s (Public)
\u2018\/\/<\/p>\n\n\n\n
Declare Function WinHelp Lib \u201cuser32\u201d Alias \u201cWinHelpA\u201d (ByVal hwnd As Long, ByVal lpHelpFile As String, ByVal wCommand As Long, ByVal dwData As Any) As Long
Declare Function HTMLHelp Lib \u201chhctrl.ocx\u201d Alias \u201cHtmlHelpA\u201d (ByVal hwnd As Long, ByVal szFilename As String, ByVal dwCommand As Long, ByVal dwData As Any) As Long<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ Constants (Public for Print Dialog Box)
\u2018\/\/<\/p>\n\n\n\n
Public Const PD_NOSELECTION = &H4
Public Const PD_DISABLEPRINTTOFILE = &H80000
Public Const PD_PRINTTOFILE = &H20
Public Const PD_RETURNDC = &H100
Public Const PD_RETURNDEFAULT = &H400
Public Const PD_RETURNIC = &H200
Public Const PD_SELECTION = &H1
Public Const PD_SHOWHELP = &H800
Public Const PD_NOPAGENUMS = &H8
Public Const PD_PAGENUMS = &H2
Public Const PD_ALLPAGES = &H0
Public Const PD_COLLATE = &H10
Public Const PD_HIDEPRINTTOFILE = &H100000<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ Constants (Public for WinHelp)
\u2018\/\/<\/p>\n\n\n\n
Public Const HELP_COMMAND = &H102&
Public Const HELP_CONTENTS = &H3&
Public Const HELP_CONTEXT = &H1
Public Const HELP_CONTEXTPOPUP = &H8&
Public Const HELP_FORCEFILE = &H9&
Public Const HELP_HELPONHELP = &H4
Public Const HELP_INDEX = &H3
Public Const HELP_KEY = &H101
Public Const HELP_MULTIKEY = &H201&
Public Const HELP_PARTIALKEY = &H105&
Public Const HELP_QUIT = &H2
Public Const HELP_SETCONTENTS = &H5&
Public Const HELP_SETINDEX = &H5
Public Const HELP_SETWINPOS = &H203&<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ Constants (Public for HTMLHelp)
\u2018\/\/<\/p>\n\n\n\n
Public Const HH_DISPLAY_TOPIC = &H0&
Public Const HH_HELP_FINDER = &H0&
Public Const HH_DISPLAY_TOC = &H1& \u2018\/\/ Currently Not Implemented
Public Const HH_DISPLAY_INDEX = &H2& \u2018\/\/ Currently Not Implemented
Public Const HH_DISPLAY_SEARCH = &H3& \u2018\/\/ Currently Not Implemented
Public Const HH_SET_WIN_TYPE = &H4&
Public Const HH_GET_WIN_TYPE = &H5&
Public Const HH_GET_WIN_HANDLE = &H6&
Public Const HH_ENUM_INFO_TYPE = &H7&
Public Const HH_SET_INFO_TYPE = &H8&
Public Const HH_SYNC = &H9&
Public Const HH_ADD_NAV_UI = &H10& \u2018\/\/ Currently Not Implemented
Public Const HH_ADD_BUTTON = &H11& \u2018\/\/ Currently Not Implemented
Public Const HH_GETBROWSER_APP = &H12& \u2018\/\/ Currently Not Implemented
Public Const HH_KEYWORD_LOOKUP = &H13&
Public Const HH_DISPLAY_TEXT_POPUP = &H14&
Public Const HH_HELP_CONTEXT = &H15&
Public Const HH_TP_HELP_CONTEXTMENU = &H16&
Public Const HH_TP_HELP_WM_HELP = &H17&
Public Const HH_CLOSE_ALL = &H18&
Public Const HH_ALINK_LOOKUP = &H19&
Public Const HH_GET_LAST_ERROR = &H20& \u2018\/\/ Currently Not Implemented
Public Const HH_ENUM_CATEGORY = &H21&
Public Const HH_ENUM_CATEGORY_IT = &H22&
Public Const HH_RESET_IT_FILTER = &H23&
Public Const HH_SET_INCLUSIVE_FILTER = &H24&
Public Const HH_SET_EXCLUSIVE_FILTER = &H25&
Public Const HH_SET_GUID = &H26&
Public Const HH_INTERNAL = &H255&<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ Constants (Private)
\u2018\/\/<\/p>\n\n\n\n
Private Const FW_BOLD = 700
Private Const GMEM_MOVEABLE = &H2
Private Const GMEM_ZEROINIT = &H40
Private Const GHND = (GMEM_MOVEABLE Or GMEM_ZEROINIT)
Private Const OFN_ALLOWMULTISELECT = &H200
Private Const OFN_CREATEPROMPT = &H2000
Private Const OFN_ENABLEHOOK = &H20
Private Const OFN_ENABLETEMPLATE = &H40
Private Const OFN_ENABLETEMPLATEHANDLE = &H80
Private Const OFN_EXPLORER = &H80000
Private Const OFN_EXTENSIONDIFFERENT = &H400
Private Const OFN_FILEMUSTEXIST = &H1000
Private Const OFN_HIDEREADONLY = &H4
Private Const OFN_LONGNAMES = &H200000
Private Const OFN_NOCHANGEDIR = &H8
Private Const OFN_NODEREFERENCELINKS = &H100000
Private Const OFN_NOLONGNAMES = &H40000
Private Const OFN_NONETWORKBUTTON = &H20000
Private Const OFN_NOREADONLYRETURN = &H8000
Private Const OFN_NOTESTFILECREATE = &H10000
Private Const OFN_NOVALIDATE = &H100
Private Const OFN_OVERWRITEPROMPT = &H2
Private Const OFN_PATHMUSTEXIST = &H800
Private Const OFN_READONLY = &H1
Private Const OFN_SHAREAWARE = &H4000
Private Const OFN_SHAREFALLTHROUGH = 2
Private Const OFN_SHARENOWARN = 1
Private Const OFN_SHAREWARN = 0
Private Const OFN_SHOWHELP = &H10
Private Const PD_ENABLEPRINTHOOK = &H1000
Private Const PD_ENABLEPRINTTEMPLATE = &H4000
Private Const PD_ENABLEPRINTTEMPLATEHANDLE = &H10000
Private Const PD_ENABLESETUPHOOK = &H2000
Private Const PD_ENABLESETUPTEMPLATE = &H8000
Private Const PD_ENABLESETUPTEMPLATEHANDLE = &H20000
Private Const PD_NONETWORKBUTTON = &H200000
Private Const PD_PRINTSETUP = &H40
Private Const PD_USEDEVMODECOPIES = &H40000
Private Const PD_USEDEVMODECOPIESANDCOLLATE = &H40000
Private Const PD_NOWARNING = &H80
Private Const CF_ANSIONLY = &H400&
Private Const CF_APPLY = &H200&
Private Const CF_BITMAP = 2
Private Const CF_PRINTERFONTS = &H2
Private Const CF_PRIVATEFIRST = &H200
Private Const CF_PRIVATELAST = &H2FF
Private Const CF_RIFF = 11
Private Const CF_SCALABLEONLY = &H20000
Private Const CF_SCREENFONTS = &H1
Private Const CF_BOTH = (CF_SCREENFONTS Or CF_PRINTERFONTS)
Private Const CF_DIB = 8
Private Const CF_DIF = 5
Private Const CF_DSPBITMAP = &H82
Private Const CF_DSPENHMETAFILE = &H8E
Private Const CF_DSPMETAFILEPICT = &H83
Private Const CF_DSPTEXT = &H81
Private Const CF_EFFECTS = &H100&
Private Const CF_ENABLEHOOK = &H8&
Private Const CF_ENABLETEMPLATE = &H10&
Private Const CF_ENABLETEMPLATEHANDLE = &H20&
Private Const CF_ENHMETAFILE = 14
Private Const CF_FIXEDPITCHONLY = &H4000&
Private Const CF_FORCEFONTEXIST = &H10000
Private Const CF_GDIOBJFIRST = &H300
Private Const CF_GDIOBJLAST = &H3FF
Private Const CF_INITTOLOGFONTSTRUCT = &H40&
Private Const CF_LIMITSIZE = &H2000&
Private Const CF_METAFILEPICT = 3
Private Const CF_NOFACESEL = &H80000
Private Const CF_NOVERTFONTS = &H1000000
Private Const CF_NOVECTORFONTS = &H800&
Private Const CF_NOOEMFONTS = CF_NOVECTORFONTS
Private Const CF_NOSCRIPTSEL = &H800000
Private Const CF_NOSIMULATIONS = &H1000&
Private Const CF_NOSIZESEL = &H200000
Private Const CF_NOSTYLESEL = &H100000
Private Const CF_OEMTEXT = 7
Private Const CF_OWNERDISPLAY = &H80
Private Const CF_PALETTE = 9
Private Const CF_PENDATA = 10
Private Const CF_SCRIPTSONLY = CF_ANSIONLY
Private Const CF_SELECTSCRIPT = &H400000
Private Const CF_SHOWHELP = &H4&
Private Const CF_SYLK = 4
Private Const CF_TEXT = 1
Private Const CF_TIFF = 6
Private Const CF_TTONLY = &H40000
Private Const CF_UNICODETEXT = 13
Private Const CF_USESTYLE = &H80&
Private Const CF_WAVE = 12
Private Const CF_WYSIWYG = &H8000
Private Const CFERR_CHOOSEFONTCODES = &H2000
Private Const CFERR_MAXLESSTHANMIN = &H2002
Private Const CFERR_NOFONTS = &H2001
Private Const CC_ANYCOLOR = &H100
Private Const CC_CHORD = 4
Private Const CC_CIRCLES = 1
Private Const CC_ELLIPSES = 8
Private Const CC_ENABLEHOOK = &H10
Private Const CC_ENABLETEMPLATE = &H20
Private Const CC_ENABLETEMPLATEHANDLE = &H40
Private Const CC_FULLOPEN = &H2
Private Const CC_INTERIORS = 128
Private Const CC_NONE = 0
Private Const CC_PIE = 2
Private Const CC_PREVENTFULLOPEN = &H4
Private Const CC_RGBINIT = &H1
Private Const CC_ROUNDRECT = 256 \u2018
Private Const CC_SHOWHELP = &H8
Private Const CC_SOLIDCOLOR = &H80
Private Const CC_STYLED = 32
Private Const CC_WIDE = 16
Private Const CC_WIDESTYLED = 64
Private Const CCERR_CHOOSECOLORCODES = &H5000
Private Const LOGPIXELSY = 90
Private Const CCHDEVICENAME = 32
Private Const CCHFORMNAME = 32
Private Const SIMULATED_FONTTYPE = &H8000
Private Const PRINTER_FONTTYPE = &H4000
Private Const SCREEN_FONTTYPE = &H2000
Private Const BOLD_FONTTYPE = &H100
Private Const ITALIC_FONTTYPE = &H200
Private Const REGULAR_FONTTYPE = &H400
Private Const WM_CHOOSEFONT_GETLOGFONT = (&H400 + 1)
Private Const LBSELCHSTRING = \u201ccommdlg_LBSelChangedNotify\u201d
Private Const SHAREVISTRING = \u201ccommdlg_ShareViolation\u201d
Private Const FILEOKSTRING = \u201ccommdlg_FileNameOK\u201d
Private Const COLOROKSTRING = \u201ccommdlg_ColorOK\u201d
Private Const SETRGBSTRING = \u201ccommdlg_SetRGBColor\u201d
Private Const FINDMSGSTRING = \u201ccommdlg_FindReplace\u201d
Private Const HELPMSGSTRING = \u201ccommdlg_help\u201d
Private Const CD_LBSELNOITEMS = -1
Private Const CD_LBSELCHANGE = 0
Private Const CD_LBSELSUB = 1
Private Const CD_LBSELADD = 2
Private Const NOERROR = 0
Private Const CSIDL_DESKTOP = &H0
Private Const CSIDL_PROGRAMS = &H2
Private Const CSIDL_CONTROLS = &H3
Private Const CSIDL_PRINTERS = &H4
Private Const CSIDL_PERSONAL = &H5
Private Const CSIDL_FAVORITES = &H6
Private Const CSIDL_STARTUP = &H7
Private Const CSIDL_RECENT = &H8
Private Const CSIDL_SENDTO = &H9
Private Const CSIDL_BITBUCKET = &HA
Private Const CSIDL_STARTMENU = &HB
Private Const CSIDL_DESKTOPDIRECTORY = &H10
Private Const CSIDL_DRIVES = &H11
Private Const CSIDL_NETWORK = &H12
Private Const CSIDL_NETHOOD = &H13
Private Const CSIDL_FONTS = &H14
Private Const CSIDL_TEMPLATES = &H15
Private Const BIF_RETURNONLYFSDIRS = &H1
Private Const BIF_DONTGOBELOWDOMAIN = &H2
Private Const BIF_STATUSTEXT = &H4
Private Const BIF_RETURNFSANCESTORS = &H8
Private Const BIF_BROWSEFORCOMPUTER = &H1000
Private Const BIF_BROWSEFORPRINTER = &H2000
Private Const HWND_BROADCAST = &HFFFF&
Private Const WM_WININICHANGE = &H1A
Private Const WM_USER = &H400
Private Const BFFM_INITIALIZED = 1
Private Const BFFM_SELCHANGED = 2
Private Const BFFM_SETSTATUSTEXT = (WM_USER + 100)
Private Const BFFM_SETSelectION = (WM_USER + 102)
Private Const BIF_USENEWUI = &H40 \u2018\u5bf9\u8bdd\u6846\u4e0a\u5e26\u201c\u65b0\u5efa\u6587\u4ef6\u5939\u201d\u6309\u94ae<\/p>\n\n\n\n
Private m_CurrentDirectory As String \u2018The current directory<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ SetDefaultPrinter Function
\u2018\/\/
\u2018\/\/ Description:
\u2018\/\/ Sets the user\u2019s default printer to the printer represented by the passed printer object.
\u2018\/\/
\u2018\/\/ Syntax:
\u2018\/\/ BOOL = SetDefaultPrinter(object)
\u2018\/\/
\u2018\/\/ Example:
\u2018\/\/ Dim objNewPrinter As Printer
\u2018\/\/ Set objNewPrinter = Printers(2)
\u2018\/\/ SetDefaultPrinter objNewPrinter
\u2018\/\/
Public Function SetDefaultPrinter(objPrn As Printer) As Boolean
Dim szTmp As String
szTmp = objPrn.DeviceName & \u201c,\u201d & objPrn.DriverName & \u201c,\u201d & objPrn.Port
lRet = WriteProfileString(\u201cwindows\u201d, \u201cdevice\u201d, szTmp)
lRet = SendMessageByString(HWND_BROADCAST, WM_WININICHANGE, 0&, \u201cwindows\u201d)
End Function<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ GetDefaultPrinter Function
\u2018\/\/
\u2018\/\/ Description:
\u2018\/\/ Retuns the device name of the default printer.
\u2018\/\/
\u2018\/\/ Syntax:
\u2018\/\/ StrVar = GetDefaultPrinter()
\u2018\/\/
\u2018\/\/ Example:
\u2018\/\/ szDefPrinter = GetDefaultPrinter
\u2018\/\/
Public Function GetDefaultPrinter() As String
Dim szTmp As String, dwBuf As Long
dwBuf = 1024
szTmp = Space$(dwBuf + 1)
lRet = GetProfileString(\u201cwindows\u201d, \u201cdevice\u201d, \u201c\u201d, szTmp, dwBuf)
GetDefaultPrinter = Trim(Left(szTmp, lRet))
End Function<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ ResetDefaultPrinter Function
\u2018\/\/
\u2018\/\/ Description:
\u2018\/\/ Resets the default printer to the passed device name.
\u2018\/\/
\u2018\/\/ Syntax:
\u2018\/\/ BOOL = ResetDefaultPrinter(StrVar)
\u2018\/\/
\u2018\/\/ Example:
\u2018\/\/ szDefPrinter = GetDefaultPrinter()
\u2018\/\/ If Not ResetDefaultPrinter(szDefPrinter) Then
\u2018\/\/ MsgBox \u201cCould not reset default printer.\u201d, vbExclamation
\u2018\/\/ End If
\u2018\/\/
Public Function ResetDefaultPrinter(szBuf As String) As Boolean
lRet = WriteProfileString(\u201cwindows\u201d, \u201cdevice\u201d, szBuf)
lRet = SendMessageByString(HWND_BROADCAST, WM_WININICHANGE, 0&, \u201cwindows\u201d)
End Function<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ BrowseFolder Function
\u2018\/\/
\u2018\/\/ Description:
\u2018\/\/ Allows the user to interactively browse and select a folder found in the file system.
\u2018\/\/
\u2018\/\/ Syntax:
\u2018\/\/ StrVar = BrowseFolder(lhWnd, StrVar)
\u2018\/\/
\u2018\/\/ Example:
\u2018\/\/ szFilename = BrowseFolder(Me.hWnd, \u201cBrowse for application folder:\u201d)
\u2018\/\/
Public Function BrowseFolder(lhWnd As Long, szDialogTitle As String) As String
Dim BI As BROWSEINFO, dwIList As Long, szPath As String, wPos As Integer
BI.hOwner = lhWnd
BI.lpszTitle = szDialogTitle
BI.ulFlags = BIF_RETURNONLYFSDIRS
dwIList = SHBrowseForFolder(BI)
szPath = Space$(512)
lRet = SHGetPathFromIDList(ByVal dwIList, ByVal szPath)
If lRet Then
wPos = InStr(szPath, Chr(0))
BrowseFolder = Left$(szPath, wPos \u2013 1)
Else
BrowseFolder = \u201c\u201d
End If
End Function<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ DialogConnectToPrinter Function
\u2018\/\/
\u2018\/\/ Description:
\u2018\/\/ Allows users to interactively selection and connect to local and network printers.
\u2018\/\/
\u2018\/\/ Syntax:
\u2018\/\/ DialogConnectToPrinter
\u2018\/\/
\u2018\/\/ Example:
\u2018\/\/ DialogConnectToPrinter
\u2018\/\/
Public Function DialogConnectToPrinter() As Boolean
Shell \u201crundll32.exe shell32.dll,SHHelpShortcuts_RunDLL AddPrinter\u201d, vbNormalFocus
End Function<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ ByteToString Function
\u2018\/\/
\u2018\/\/ Description:
\u2018\/\/ Converts an array of bytes into a string
\u2018\/\/
\u2018\/\/ Syntax:
\u2018\/\/ StrVar = ByteToString(ARRAY)
\u2018\/\/
\u2018\/\/ Example:
\u2018\/\/ szBuf = BytesToString(aChars(10))
\u2018\/\/
Private Function ByteToString(aBytes() As Byte) As String
Dim dwBytePoint As Long, dwByteVal As Long, szOut As String
dwBytePoint = LBound(aBytes)
While dwBytePoint <= UBound(aBytes)
dwByteVal = aBytes(dwBytePoint)
If dwByteVal = 0 Then
ByteToString = szOut
Exit Function
Else
szOut = szOut & Chr$(dwByteVal)
End If
dwBytePoint = dwBytePoint + 1
Wend
ByteToString = szOut
End Function<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ DialogColor Function
\u2018\/\/
\u2018\/\/ Description:
\u2018\/\/ Displays the Color common dialog box and sets a passed controls foreground color.
\u2018\/\/
\u2018\/\/ Syntax:
\u2018\/\/ BOOL = DialogColor(lhWnd, CONTROL)
\u2018\/\/
\u2018\/\/ Example:
\u2018\/\/ Dim yn as Boolean
\u2018\/\/ yn = DialogColor(Me.hWnd, txtEditor)
\u2018\/\/
Public Function DialogColor(lhWnd As Long, C As Control) As Boolean
Dim CS As COLORSTRUC, CustColor(16) As Long
CS.lStructSize = Len(CS)
CS.hwnd = lhWnd
CS.hInstance = App.hInstance
CS.Flags = CC_SOLIDCOLOR
CS.lpCustColors = String$(16 * 4, 0)
lRet = ChooseColor(CS)
If lRet = 0 Then
DialogColor = False
Else
DialogColor = True
C.ForeColor = CS.rgbResult
End If
End Function<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ DialogFont Function
\u2018\/\/
\u2018\/\/ Description:
\u2018\/\/ Displays the Font common dialog box and sets a passed controls font properties.
\u2018\/\/
\u2018\/\/ Syntax:
\u2018\/\/ BOOL = DialogFont(lhWnd, CONTROL)
\u2018\/\/
\u2018\/\/ Example:
\u2018\/\/ Dim yn as Boolean
\u2018\/\/ yn = DialogFont(Me.hWnd, txtEditor)
\u2018\/\/
Public Function DialogFont(lhWnd As Long, C As Control) As Boolean
Dim lf As LogFont, FS As FONTSTRUC
Dim lLogFontAddress As Long, lMemHandle As Long
If C.Font.Bold Then lf.lfWeight = FW_BOLD
If C.Font.Italic = True Then lf.lfItalic = 1
If C.Font.Underline = True Then lf.lfUnderline = 1
FS.lStructSize = Len(FS)
lMemHandle = GlobalAlloc(GHND, Len(lf))
If lMemHandle = 0 Then
DialogFont = False
Exit Function
End If
lLogFontAddress = GlobalLock(lMemHandle)
If lLogFontAddress = 0 Then
DialogFont = False
Exit Function
End If
CopyMemory ByVal lLogFontAddress, lf, Len(lf)
FS.lpLogFont = lLogFontAddress
FS.iPointSize = C.Font.Size * 10
FS.Flags = CF_SCREENFONTS Or CF_EFFECTS
If ChooseFont(FS) = 1 Then
CopyMemory lf, ByVal lLogFontAddress, Len(lf)
If lf.lfWeight >= FW_BOLD Then
C.Font.Bold = True
Else
C.Font.Bold = False
End If
If lf.lfItalic = 1 Then
C.Font.Italic = True
Else
C.Font.Italic = False
End If
If lf.lfUnderline = 1 Then
C.Font.Underline = True
Else
C.Font.Underline = False
End If
C.Font.Name = ByteToString(lf.lfFaceName())
C.Font.Size = CLng(FS.iPointSize \/ 10)
DialogFont = True
Else
DialogFont = False
End If
End Function<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ DialogFile Function
\u2018\/\/
\u2018\/\/ Description:
\u2018\/\/ Displays the File Open\/Save As common dialog boxes.
\u2018\/\/
\u2018\/\/ Syntax:
\u2018\/\/ StrVar = DialogFile(lhWnd, IntVar, StrVar, StrVar, StrVar, StrVar, StrVar, IntVar)
\u2018\/\/
\u2018\/\/ Example:
\u2018\/\/ szFilename = DialogFile(Me.hWnd, 1, \u201cOpen\u201d, \u201cMyFileName.doc\u201d, \u201cDocuments\u201d & \u201c|\u201d & \u201c.doc\u201d & \u201c|\u201d & \u201cAll files\u201d & \u201c|\u201d & \u201c.*\u201d, App.Path, \u201cdoc\u201d, Path, 1)
\u2018\/\/
Public Function DialogFile(lhWnd As Long, wMode As Integer, szDialogTitle As String, ByVal szFilename As String, szFilter As String, ByVal szDefDir As String, szDefExt As String, szDestDir As String, ByVal iFilterIndex As Integer) As String
szFilter = Replace(szFilter, \u201c|\u201d, Chr(0), 1, -1, vbBinaryCompare)
Dim OFN As OPENFILENAME, szFile As String, szFileTitle As String
OFN.lStructSize = Len(OFN)
OFN.hwnd = lhWnd
OFN.lpstrTitle = szDialogTitle
OFN.lpstrFile = szFilename & String$(250 \u2013 Len(szFilename), 0)
OFN.nMaxFile = BUFFER
OFN.lpstrFileTitle = String$(BUFFER, 0)
OFN.nMaxFileTitle = BUFFER
OFN.lpstrFilter = szFilter
OFN.nFilterIndex = iFilterIndex
OFN.lpstrInitialDir = szDefDir
OFN.lpstrDefExt = szDefExt
If wMode = 1 Then
OFN.Flags = OFN_HIDEREADONLY Or OFN_PATHMUSTEXIST Or OFN_FILEMUSTEXIST
lRet = GetOpenFileName(OFN)
Else
OFN.Flags = OFN_HIDEREADONLY Or OFN_OVERWRITEPROMPT Or OFN_PATHMUSTEXIST
lRet = GetSaveFileName(OFN)
End If
If lRet <> 0 Then
\u2018\/\/ If InStr(OFN.lpstrFileTitle, Chr$(0)) > 0 Then
\u2018\/\/ szFileTitle = Left$(OFN.lpstrFileTitle, InStr(OFN.lpstrFileTitle, Chr$(0)) \u2013 1)
\u2018\/\/ End If
If InStr(OFN.lpstrFile, Chr$(0)) > 0 Then
szFile = Left$(OFN.lpstrFile, InStr(OFN.lpstrFile, Chr$(0)) \u2013 1)
End If
\u2018\/\/ OFN.nFileOffset is the number of characters from the beginning of the
\u2018\/\/ full path to the start of the file name
\u2018\/\/ OFN.nFileExtension is the number of characters from the beginning of the
\u2018\/\/ full path to the file\u2019s extention, including the (.)
\u2018\/\/ MsgBox \u201cFile Name is \u201d & szFileTitle & Chr$(13) & Chr$(10) & \u201cFull path and file is \u201d & szFile, , \u201cOpen\u201d<\/p>\n\n\n\n
‘\/\/ DialogFile = szFile & “|” & szFileTitle
DialogFile = szFile
szDestDir = Left(szFile, OFN.nFileOffset)
Else
DialogFile = “”
End If
End Function<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ DialogOpenFile Function
\u2018\/\/
\u2018\/\/ Description:
\u2018\/\/ Displays the MultiFile Open As common dialog boxes.
\u2018\/\/
\u2018\/\/ Syntax:
\u2018\/\/ StrVar = DialogOpenFile(lhWnd, StrVar, StrVar, StrVar)
\u2018\/\/
\u2018\/\/ Example:
\u2018\/\/ szFilename = DialogOpenFile(Me.hWnd, \u201cOpen MultiFile\u201d, \u201cDocuments\u201d & \u201c|\u201d & \u201c.doc\u201d & \u201c|\u201d & \u201cAll files\u201d & \u201c|\u201d & \u201c.*\u201d, App.Path)
\u2018\/\/
Public Function DialogOpenFile(lhWnd As Long, szDialogTitle As String, szFilter As String, ByVal szDefDir As String) As String
szFilter = Replace(szFilter, \u201c|\u201d, Chr(0), 1, -1, vbBinaryCompare)
Dim OFN As OPENFILENAME, szFile As String, szFileTitle As String
OFN.lStructSize = Len(OFN)
OFN.hwnd = lhWnd
OFN.lpstrTitle = szDialogTitle
OFN.lpstrFile = Space$(BUFFER \u2013 1) \u2018String$(BUFFER, 0) \u2018szFilename & String$(250 \u2013 Len(szFilename), 0)
OFN.nMaxFile = BUFFER
OFN.lpstrFileTitle = Space$(BUFFER \u2013 1) \u2018String$(BUFFER, 0)
OFN.nMaxFileTitle = BUFFER
OFN.lpstrFilter = szFilter
\u2018OFN.nFilterIndex = iFilterIndex
OFN.lpstrInitialDir = szDefDir
\u2018OFN.lpstrDefExt = szDefExt
OFN.Flags = OFN_ALLOWMULTISELECT Or OFN_EXPLORER Or OFN_FILEMUSTEXIST
lRet = GetOpenFileName(OFN)
If lRet <> 0 Then
DialogOpenFile = OFN.lpstrFile
Else
DialogOpenFile = \u201c\u201d
End If
End Function<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ DialogPrint Function
\u2018\/\/
\u2018\/\/ Description:
\u2018\/\/ Displays the Print common dialog box and returns a structure containing user entered
\u2018\/\/ information from the common dialog box.
\u2018\/\/
\u2018\/\/ Syntax:
\u2018\/\/ PRINTPROPS = DialogPrint(lhWnd, BOOL, DWORD)
\u2018\/\/
\u2018\/\/ Example:
\u2018\/\/ Dim PP As PRINTPROPS
\u2018\/\/ PP = DialogPrint(Me.hWnd, True, PD_PAGENUMS or PD_SELECTION or PD_SHOWHELP)
\u2018\/\/
Public Function DialogPrint(lhWnd As Long, bPages As Boolean, Flags As Long) As PRINTPROPS
Dim DM As DEVMODE, PD As PRINTDLGSTRUC
Dim lpDM As Long, wNull As Integer, szDevName As String
PD.lStructSize = Len(PD)
PD.hwnd = lhWnd
PD.hDevMode = 0
PD.hDevNames = 0
PD.hDC = 0
PD.Flags = Flags
PD.nFromPage = 0
PD.nToPage = 0
PD.nMinPage = 0
If bPages Then PD.nMaxPage = bPages \u2013 1
PD.nCopies = 0
DialogPrint.Cancel = True
If PrintDlg(PD) Then
lpDM = GlobalLock(PD.hDevMode)
CopyMemory DM, ByVal lpDM, Len(DM)
lpDM = GlobalUnlock(PD.hDevMode)
DialogPrint.Cancel = False
DialogPrint.Device = Left$(DM.dmDeviceName, InStr(DM.dmDeviceName, Chr(0)) \u2013 1)
DialogPrint.FromPage = 0
DialogPrint.ToPage = 0
DialogPrint.All = True
If PD.Flags And PD_PRINTTOFILE Then DialogPrint.File = True Else DialogPrint.File = False
If PD.Flags And PD_COLLATE Then DialogPrint.Collate = True Else DialogPrint.Collate = False
If PD.Flags And PD_PAGENUMS Then
DialogPrint.Pages = True
DialogPrint.All = False
DialogPrint.FromPage = PD.nFromPage
DialogPrint.ToPage = PD.nToPage
Else
DialogPrint.Pages = False
End If
If PD.Flags And PD_SELECTION Then
DialogPrint.Selection = True
DialogPrint.All = False
Else
DialogPrint.Pages = False
End If
If PD.nCopies = 1 Then
DialogPrint.Copies = DM.dmCopies
End If
DialogPrint.DM = DM
End If
End Function<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ DialogPrintSetup Function
\u2018\/\/
\u2018\/\/ Description:
\u2018\/\/ Displays the Print Setup common dialog box.
\u2018\/\/
\u2018\/\/ Syntax:
\u2018\/\/ BOOL = DialogPrintSetup(lhWnd)
\u2018\/\/
\u2018\/\/ Example:
\u2018\/\/ If DialogPrintSetup(Me.hWnd) Then
\u2018\/\/ End If
\u2018\/\/
Public Function DialogPrintSetup(lhWnd As Long) As Boolean
Dim PD As PRINTDLGSTRUC
PD.lStructSize = Len(PD)
PD.hwnd = lhWnd
PD.Flags = PD_PRINTSETUP
lRet = PrintDlg(PD)
End Function<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ BrowseForFolder Function
\u2018\/\/
\u2018\/\/ Description:
\u2018\/\/ Allows the user to interactively browse and select a folder found from a folder in the file system.
\u2018\/\/
\u2018\/\/ Syntax:
\u2018\/\/ StrVar = BrowseForFolder(lhWnd, StrVar, StrVar)
\u2018\/\/
\u2018\/\/ Example:
\u2018\/\/ szFilename = BrowseForFolder(Me.hWnd, \u201cBrowse for application folder:\u201d, App.Path)
\u2018\/\/
\u2018Public Function BrowseForFolder(oWner As Form, sTitle As String, sStartDir As String) As String
Public Function BrowseForFolder(lhWnd As Long, sTitle As String, sStartDir As String) As String
Dim lpIDList As Long
Dim szTitle As String
Dim sBuffer As String
Dim tBrowseInfo As BROWSEINFO
m_CurrentDirectory = sStartDir & vbNullChar
szTitle = sTitle
With tBrowseInfo
.hOwner = lhWnd
.lpszTitle = szTitle \u2018lstrcat(szTitle, \u201c\u201d)
.ulFlags = BIF_RETURNONLYFSDIRS + BIF_DONTGOBELOWDOMAIN + BIF_STATUSTEXT
.lpfnCallback = GetAddressofFunction(AddressOf BrowseCallbackProc) \u2018get address of function.
End With
lpIDList = SHBrowseForFolder(tBrowseInfo)
If (lpIDList) Then
sBuffer = Space$(BUFFER)
SHGetPathFromIDList lpIDList, sBuffer
sBuffer = Left(sBuffer, InStr(sBuffer, vbNullChar) \u2013 1)
BrowseForFolder = sBuffer
Else
BrowseForFolder = \u201c\u201d
End If
End Function<\/p>\n\n\n\n
\u2018\/\/
\u2018\/\/ BrowseForNewFolder Function
\u2018\/\/
\u2018\/\/ Description:
\u2018\/\/ Allows the user to interactively browse and select a folder found from a folder in the file system with new folder.
\u2018\/\/
\u2018\/\/ Syntax:
\u2018\/\/ StrVar = BrowseForNewFolder(lhWnd, StrVar, StrVar)
\u2018\/\/
\u2018\/\/ Example:
\u2018\/\/ szFilename = BrowseForNewFolder(Me.hWnd, \u201cBrowse for application folder:\u201d, App.Path)
\u2018\/\/
\u2018Public Function BrowseForNewFolder(oWner As Form, sTitle As String, sStartDir As String) As String
Public Function BrowseForNewFolder(lhWnd As Long, sTitle As String, sStartDir As String) As String
Dim iNull As Integer
Dim lpIDList As Long
Dim szTitle As String
Dim sBuffer As String
Dim tBrowseInfo As BROWSEINFO
m_CurrentDirectory = sStartDir & vbNullChar
szTitle = sTitle
With tBrowseInfo
.hOwner = lhWnd \u2018\u8bbe\u7f6e\u4e3b\u7a97\u4f53\u53e5\u67c4
.lpszTitle = szTitle \u2018lstrcat(szTitle, \u201c\u201d)
.ulFlags = BIF_RETURNONLYFSDIRS Or BIF_USENEWUI \u2018\u65b0\u5efa\u6587\u4ef6\u5939
.lpfnCallback = GetAddressofFunction(AddressOf BrowseCallbackProc) \u2018get address of function.
End With
\u2018\u663e\u793a\u5217\u8868\u6846
lpIDList = SHBrowseForFolder(tBrowseInfo)
If (lpIDList) Then
sBuffer = String$(BUFFER, 0)
\u2018\u83b7\u53d6\u8fd4\u56de\u7684\u8def\u5f84
SHGetPathFromIDList lpIDList, sBuffer
\u2018\u91ca\u653e\u5185\u5b58\u5757
CoTaskMemFree lpIDList
iNull = InStr(sBuffer, vbNullChar) \u2018\u53bb\u9664\u7a7a\u683c\u7b26
If iNull Then sBuffer = Left$(sBuffer, iNull \u2013 1)
End If
BrowseForNewFolder = sBuffer
End Function<\/p>\n\n\n\n
Private Function BrowseCallbackProc(ByVal lhWnd As Long, ByVal uMsg As Long, ByVal lp As Long, ByVal pData As Long) As Long
Dim lpIDList As Long
Dim sBuffer As String
If Not ExposeError Then On Error Resume Next
Select Case uMsg
Case BFFM_INITIALIZED
Call SendMessage(lhWnd, BFFM_SETSelectION, 1, m_CurrentDirectory)
Case BFFM_SELCHANGED
sBuffer = Space$(BUFFER)
lRet = SHGetPathFromIDList(lp, sBuffer)
If lRet = 1 Then
Call SendMessage(lhWnd, BFFM_SETSTATUSTEXT, 0, sBuffer)
End If
End Select
BrowseCallbackProc = 0
End Function<\/p>\n\n\n\n
Private Function GetAddressofFunction(lAdd As Long) As Long
GetAddressofFunction = lAdd
End Function<\/p>\n","protected":false},"excerpt":{"rendered":"