Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save ezhov-da/91ec089a77e0e750d6c64334e4ae3195 to your computer and use it in GitHub Desktop.
Save ezhov-da/91ec089a77e0e750d6c64334e4ae3195 to your computer and use it in GitHub Desktop.
vba загрузка настроек из xml
'***********************************************************************************************
'инициализация класса и загрузка 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