Last active
March 10, 2019 12:14
-
-
Save ezhov-da/91ec089a77e0e750d6c64334e4ae3195 to your computer and use it in GitHub Desktop.
vba загрузка настроек из xml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'*********************************************************************************************** | |
'инициализация класса и загрузка xml с запросами | |
'*********************************************************************************************** | |
Private loaderXml As MSXML2.DOMDocument | |
Private Const NAME_XML_FILE As String = "querys.xml" | |
Private Sub Class_Initialize() | |
'загружаем документ для работы с запросами | |
Dim path As String | |
path = ThisWorkbook.path & "\" & NAME_XML_FILE | |
Set loaderXml = New MSXML2.DOMDocument | |
loaderXml.validateOnParse = False | |
loaderXml.Load (path) | |
End Sub | |
'************************************************************************************************ | |
'ЗАПРОСЫ ДЛЯ ФИЛЬТРОВ | |
'************************************************************************************************ | |
Property Get getSelectTreeEmploee() As String | |
getSelectTreeEmploee = loaderXml.getElementsByTagName("1111111").Item(0).text | |
End Property |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment