I am inserting a user selected block into a drawing, and exploding it to expose the nested blocks for editing. Interface Controls for DoEvent in Excel. For example, a file attribute of 0x120 indicates the Temporary + Archive attributes are set (0x100 + 0x20 = 0x120. I have created the form, I just have no idea how to use VBA to search for that block and update the 3 attributes via the click of a button. Candy Harbin, M. These groups are called "basic" permissions. Selecting and working with XML in Excel and VBA is always a bit challenging. Change Font size. Gecko notes. You can also read a preview on O'Reilly. excell userforms attributes do not allow the same flexibility that I can get with the System. The file is written to the c:\temp directory and is named ExpSample. Change file attributes in Windows 10. Obsolete, attribute, VB. Modify the default expression if desired. Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly, Amazon and all good bookshops. The columns attribute also gives you a tuple of tuples, with each of the inner tuples containing the Cell objects in a particular column. Font, Range. What I'm trying to say here is that metadata (data about data) should be stored as attributes, and the data itself should be stored as elements. When a standard attribute changes, the corresponding property is auto-updated, and (with some exceptions) vice versa. '----- ' Preconditions: ' 1. Introduction. There are a handful of ARIA1. Getting Consistent FOLDER Attributes With VBA I have been using the code below for years to grab file attributes using VBA. I am wanting to use a User Form to drive a specific block's attributes. MS Excel: How to use the DIR Function (VBA) Advertisement. Print item Next The easiest way to implement this method is by calling the hidden [_NewEnum] property getter on an internal/encapsulated. The Attribute directives are not visible in the VBA Editor and they cannot be added by the VBA Editor. If the ‘pathname’ is not found, DIR returns a string of zero length. Excel VBA Tips: Get Shape Properties Lately, I have been working with shapes in excel - moving, creating, making them invisible and resizing them. Attributes(x). Listing 7-8. Set NewEnum = Me. A few months ago I wrote about how I envisioned dealing with module and member attributes in the 2. Hopefully this guide will serve as a good resource as you try to automate those extremely powerful Pivot Tables in your Excel spreadsheets. Do you want to set it?", vbYesNo, "Set/Clear Archive Bit") If r = vbYes Then f. Getting Consistent FOLDER Attributes With VBA I have been using the code below for years to grab file attributes using VBA. Was able to get it to loop through the files and capture the basic attributes (that come from the file system): File Path. VB_Description = "some string" ' Adds the text to the Object Browser information for the procedure. Thank you in advance! Ash. Excel VBA DIR Function DIR Function returns the first file name that matches the criteria in Function argument (pathname and attributes). I have created the form, I just have no idea how to use VBA to search for that block and update the 3 attributes via the click of a button. DOMDocument object in VBA. PrintTitleRows = "". Open the Visual Basic Editor by hitting Alt-F11 or Tools>Macro>Visual Basic Editor from the toolbar. Using the Add Attribute Method. Rather than saving files to a pre-existing folder you can create a folder on the fly so to speak which more suits the nature of the Excel file you are creating. It provides integration of declarative information to assemblies, classes, interfaces, members, etc. Read/write or read-only, depending on the attribute. The most commonly used object based model by Excel VBA developers to access the computer's file system is the FileSystemObject (FSO), which is available inside the Microsoft Scripting Runtime library. To start viewing messages, select the forum that you want to visit from the selection below. For example, a file attribute of 0x120 indicates the Temporary + Archive attributes are set (0x100 + 0x20 = 0x120.  Not available in the Access query interface or DAO. Many utilities, like adfind and dsquery *, accept LDAP filters. ) An alternative way to display extended attributes is using FOR parameter attributes. Use the Connection object's OpenSchema method to get a list of tables. File Attributes. The installer you get from here is checked against viruses and malware. It works fine on all the standard attributes, but I want to update a user's "Clock" which is a custom attribute we have at my company. Many PowerShell Active Directory module cmdlets, like Get-ADUser, Get-ADGroup, Get-ADComputer, and Get-ADObject, accept LDAP filters with the LDAPFilter parameter. VBA Construct: New value of the Range. VBA SetAttr function is categorized as File and Direcetory function. Rewrite End Sub Sub Attribute_append() Dim Ee As ElementEnumerator Dim Db As DataBlock Set Ee = ActiveModelReference. You can follow the question or vote as helpful, but you cannot reply to this thread. can u explain me more. The Dir function syntax has these arguments:. Applies to: Access 2013, Office 2013. Files with the O attribute may be skipped entirely because the software may. An attribute is a new code level language construct in all major. Hi I eould like to know if anyone has come across a similar problem. Description. There is a bit more to VBA code and class modules that meets the eye. Attribute values are multiplications of the number 2 hence binary attribute values can be identified. Welcome to the p2p. Is it possible to hard code the Attributes to "Read only" in other words the the file would always have to be saved as another name and the original would stay intact. Note: The ability to import XML data from a Web service by using a Data Retrieval Service Connection (. Previous articles on TechBookReport have shown how to use the FileSystemObject API from within VBA to access files, directories, text streams and so on. The actual purpose of the width attribute, according to the specification, is to inform the browser of the actual, intrinsic width (in CSS pixels) of the image file. The GETATTR function is a built-in function in Excel that is categorized as a File/Directory Function. xlsx open sample1. The Attributes property has these parts:. I have been trying to get href value on a web page using excel vba from almost 2 days now. He's using custom properties to fill the block. When we use VBA we use the properties and attributes defined in VBA but what happens when we want to create our own properties and methods and attributes, that is when we use a class module in VBA so that we can have it user-defined, a class module has its own set of codes defined for functions, properties, and objects by the user. If this attribute is absent, the content of the option takes its place. Syntax for specifying an attribute is as follows −. const x = document. How about AutoNumber type ? what is the type should we used ? Kindly advise. If the 'pathname' is not found, DIR returns a string of zero length. Two basic types are (1) Independent variable: that can take different values and can cause corresponding changes in other variables, and (2) Dependent variable: that can take different values only in. Excel VBA, Get Current File Path and Name Jul 29, 2015 by azurous in Excel In this article I will explain how you can get the current path and name of the file you are working with. Read/write until the TableDef object that the Index object is appended to is appended to a Database object;. Format bubble chart using VBA Change the style and color of bubbles using VBA. SAX provides a mechanism for reading data from an XML document that is an alternative to that provided by the Document Object Model (DOM). There is basicly two ways to find the correct attribute to change either use its tag name or use its position order, the second method is the example here with the 1st attribute starting at 0 see attrib(0). Welcome to VBA Tips & Tricks. SELECT's NAME attribute provides the key sent to the server with the value of the selected option. There are several ways to create a list of files in a folder and its sub-directories. Rewrite End Sub Sub Attribute_append() Dim Ee As ElementEnumerator Dim Db As DataBlock Set Ee = ActiveModelReference. Posted on June 5, 2017 December 28, 2018 by Excel Off The Grid. I have two parameters in a Excel worskheet which I want to update in PI AF. Explore the various Properties and examples on Excel VBA ListBox control properties using side navigation. Build and deploy powerful apps with APIs, SDKs, REST services and mapping tools. Sub Macro1() With ActiveSheet. VB6 also allows you to set up the special procedure shown in Listing 7-8. value instead of Element. LDAP syntax filters can be used in many situations to query Active Directory. Sure you can use this snippet to find the last filled cell in a column and use that row number to set your range. VBA Dir Syntax. So now you need to save your changes and that is. To use the program, the starting number (or text value) is entered by the user in the textbox on the form. Each of these inner tuples represents a row, and contains the Cell objects in that row. 10 White Space Handling. GetElementsByTagName("a")(0). Nodes in a NamedNodeMap can be accessed by name or by index (number). For instance, if I. Change layer of attributes using VBA Hello, We often receive drawings where the block is on layer A and the attributes of the block are on layer B. An object’s properties determine how it looks, how it behaves, and even whether it is visible. Tip Because file names are retrieved in no particular order, you may want to store returned file names in an array, and then sort the array. For example, you can make a file Read-Only to prevent software programs from saving changes to a file. In VBA we have two ways of referencing a cell object one is through Range and another one is through Cells. Table size 2 GB minus the space needed for the system objects. Description. Attribute procName. The Attributes property has these parts:. What I'm trying to say here is that metadata (data about data) should be stored as attributes, and the data itself should be stored as elements. Index object. Other Notes. You simply have to create an instance of FileSystemObject in VBA and then you can generate files, read files, delete files, iterate though folders and do many other operations on your computer's file system. attribute is a string containing the value of attributeName. The VBA Project – Project Properties window opens. What I want to do is loop through all the blocks, find all the block references, and delete them permanently one by one. Using the aria-controls attribute. For Access 2000 or 2002, make sure you have a DAO reference. Using VBA, you can do two things with an object’s properties: Examine the current setting for a property. Attribute Changer is a power user tool to change all kind of file and folder attributes, date, time and even NTFS compression. Hidden = True[/vba]but it only hides one column even though i selected say 2 columns. The result can be a single attribute or a combination of multiple attributes (sum). The command buttons are usually placed at the bottom of the form and serve to complete the transaction for which the form has been created. I am using AutoCAD Electrical 2017 and inserting a block that contains 4 AutoCAD Electrical B. name is a string representing the name of the attribute. Current Special! Complete Excel Excel Training Course for Excel 97 - Excel 2003, only $145. List of VBA Functions: Please click on below link to go back to see all List of VBA Functions. Delete The Application. Use the LongPtr variable type instead of the Long or LongLong variable types for function arguments representing pointers if your VBA macro or application must work with both 32-bit and 64-bit SOLIDWORKS. Firstly, we must select the attribute we would like to edit. For example, we can sets the backcolor or back ground or align etc properties of the ListBox. This information can then be used by the browser in optimizing the. It · Hi, This is the forum to discuss questions and. Is there a VBA program I can run to accomplish this task, I have failry limited VBA skills and haven't written in VBA for years. Get a selected value from the Listbox in VBA. This column should contain either Attribute or one of the EA Element types as defined in the documentation of EA. Copy Method in Excel VBA, and demonstrate how to copy worksheet to another workbook. The temporary attribute can be removed by using PowerShell to subtract 0x100:. Obsolete, attribute, VB. CreateElement("messageDetail") To create a new XML element in my document. For example, use Element. Change file attributes in Windows 10. Nodes in a NamedNodeMap can be accessed by name or by index (number). Vba Attribute Inventor Freeware VBA Code Compare v. This property allows us to get or change the various attributes of a file. There are few Attributes that you cannot see in the VBA IDE. The code works fine when I run it · Any idea on why the code is getting stuck in an infinate. Go To Developer Tab and then click Visual Basic from the Code or Press Alt+F11. If you want to change the System attribute, you need to do it from the command prompt. So I’ll probably call the SQL from VBA…just need to work out how when I get time to consult GOOGLE. SelectNodes to get list of nodes selected by the XPath expression. VBA code to copy, move, delete and manage files Posted on August 9, 2017 December 28, 2018 by Excel Off The Grid Automating processes with VBA can involve copying, moving, deleting and managing a lot of files. List all Worksheets in a Workbook To use the macro just replace the word…. Hold down the ALT + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window. Accounting Number Format through VBA Formatting Let’s take an example to understand how and where we can format the cell for accounting. Is there a VBA program I can run to accomplish this task, I have failry limited VBA skills and haven't written in VBA for years. DOMDocument object in VBA. The users are required to fill out a form (in Excel) this is currently pulling their name using VBA (ENVIRON("username")) which gives the logon nameex: JDoe.  To create a fixed width field with DAO, set the field’s Attributes to: Attributes Or dbFixedField. If the ‘pathname’ is not found, DIR returns a string of zero length. Create Folder with VBA. Basically, there are 3 ways to duplicate a table in Access by using VBA code and there are pros and cons for each. ; o SelectNodes - Selects a list of nodes matches the Xpath pattern. The attributes property returns a collection of the specified node's attributes, as a NamedNodeMap object. I am using VBA to change the attributes of Command Buttons on a number of pages and due to the numbers involved wanted to automate the process. /S Processes matching files in the current folder and all subfolders. Attributes(x). As a side effect, It’ll be shown how to use a flexible infosource for simultaneous upload of texts and attributes (master data). Hi guys I have the following function which attempts to add a value to a user's AD account. Scripting the title attribute. Each file and folder stored on a Windows filesystem has system attributes that can be modified with Attribute Changer. Objects (Visual Basic for Applications). This would not allow anyone to change the attributes in the properties before opening the file from "Read only" to "Archive" Thanks, Jim. Return Value (RetVal) Type: Variant (array of AttributeReference objects) The array of AttributeReference objects. Rewrite End Sub Sub Attribute_append() Dim Ee As ElementEnumerator Dim Db As DataBlock Set Ee = ActiveModelReference. In previous example, you had learned VBA code to display subfolders in a folder by using subfolders property. If the result is not zero, that attribute is set for the named file.  The initial seed value and increment value are optional, and can be used only with ADO. Introduction. Table size 2 GB minus the space needed for the system objects. getAttribute(). Reading and Altering File Attributes One of the most useful (and coolest) Microsoft-provided components for use with ASP pages is the FileSystemObject. The VBA project contains two modules and one class module: attribute value as it is listed within the file workbook. However, that tool may not provide some particular feature, or you just like writing VBA code. Introduction. Using AutoAttribute, you can quickly make changes to the AutoCAD attributes of the block references in the multiple drawings. VBA object is something like a thing that has certain functions, properties, and can contain data or child objects. Viewed 157k times 24. The descriptive text included with each button control is returned via VBA callback and the dynamic getDescription attribute. Create a new query in the query builder and hit apply. Please find more details about VBA ActiveX ListBox_Control and how we are adding it on the UserForm. VB_Description = "some string" ' Adds the text to the Object Browser information for the procedure. Redraw What would I put for the fill. I modified the code as shown below, ===== Function GetFileProperties(strFilewFullPath, iDoHeaders As Integer) Const arrSize = 39 Dim strFile As String, strFileName Dim strPath As · I'm trying to retrieve the Extended File Properties for. Column width isn't measured in points, centimeters or inches. The intent of this Article is to:. VBA – Attributes. Previous articles on TechBookReport have shown how to use the FileSystemObject API from within VBA to access files, directories, text streams and so on. Hi All, I have extended the AD schema to add some extra attributes to users. It's a read-write property, so your VBA code can either read or change the value. How to export attributes to a table This sample exports the active layer or standalone table in the table of contents to a new dBASE file. Syntax of VBA DIR Function: The syntax of DIR is as follows: DIR ( pathname [, attributes ] ) Here, ‘pathname’ specifies the location of a file, folder or a directory. This article DOES NOT cover Selenium. VBA display files of a folder. This is the snippet Get or Set the ID3 Tag of an mp3 File on FreeVBCode. !Objects: ! In a pure O-O language, every thing in the program is an object. Do you want to set it?", vbYesNo, "Set/Clear Archive Bit") If r = vbYes Then f. If you have two or more projects open within the VBA editor, it is possible to have an active code pane open from Project1 and have a component of Project2 selected in the Project Explorer window. External Files MS Access VBA Programming MS Excel VBA MS Word VBA VBA 23 responses on “ VBA – Open a PDF to a Specific Page ” Brian August 19, 2014 at 12:34 pm. Quit 'close the application window End With End Sub Microsoft HTML Object Library or IE Best friend. For example, use Element. Even though you cannot modify these in the VBA editor, they allow you to add some spice to your VBA code. It can retrieve all types of files including media files such as audio and movie files. The XmlElement. Free VBA Tutorial If you are new to VBA or you want to sharpen your existing VBA skills then why not try out the The Ultimate VBA Tutorial. Left MsgBox "Please select a picture not the range. Below is the code. Cells property returns the Range object represents ALL ranges on the active sheet. V8i VBA view attributes fill on/off or V8I Key-in RJB Thu, Jan 16 2014 5:07 PM I know about Ctrl B and click them on or off, but since the following work in VBA ' new ActiveDesignFile. A1) with a specific number that I enter into a text box when I click Update. name is a string representing the name of the attribute. This post covers everything you need to know about the VBA Find function. MS Access, VBA and XML DOM: Get attribute and pass to variable? In Access 2010, I have a function that queries a Department of Revenue API and returns an XML response. But, I can't figure out a way to extract the author of each file. Firstly, we must select the attribute we would like to edit. Sets or returns the attributes of files or folders. To combine values use the And operator or simply add the values. Attribute Changer installer includes the 32- and 64-bit binaries. ' Preconditions: Model document is open and an attribute is selected. When you want to edit attributes in AutoCAD most of us use the "Attedit" command. 4 VBA Code Compare allows you to compare and merge any Visual Basic code embedded into a VBA project (macros, sheet code, module code etc. name is a string representing the name of the attribute. The ProjectProtectionState and ProjectVisibilityState attributes are encrypted data structures but it turns out that if you set them to something arbitrary, it will protect the document and make. Macro Example Sub RemoveDataValidations_ActiveSheet() Cells. If you have two or more projects open within the VBA editor, it is possible to have an active code pane open from Project1 and have a component of Project2 selected in the Project Explorer window. Excel shortcut keys allow you to perform certain tasks using only the keyboard. In VBA we have two ways of referencing a cell object one is through Range and another one is through Cells. I think the question its self is pretty much descriptive. Subform2 is the name of the subform CONTROL on the 1st subform. XMLHTTP from the expert community at Experts Exchange. /S Processes matching files in the current folder and all subfolders. This seems easy, but because excel codes the location of an object from the top left of cell A1, it makes it very difficult to work out exactly where the object…. However, you can't call the Dir function recursively. If the 'pathname' is not found, DIR returns a string of zero length. from the expert community at Experts Exchange This Article provides Excel VBA that will retrieve the properties for all MP3 files that reside anywhere under the User's My Music folder. The nodes can be accessed by index numbers, and the index starts at 0. In the sample code below, we're changing the user's telephoneNumber · So right off hand you need to throw in a objUser. If you're only beginning to read about these topics, you'll probably see this term in the near future. You'll then get back a collection of all elements of that tag name, and. If the result is not zero, that attribute is set for the named file. RFC 1867 also introduced the accept attribute for the input element. I have created the form, I just have no idea how to use VBA to search for that block and update the 3 attributes via the click of a button. This built-in VBA GetAttr statement returns the attributes of a file, folder, or directory in Excel VBA. Modify the default expression if desired. Hi, How to get "class" attribute of an HTML element. PrintArea = "" With. Attribute : Maximum: Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a table 255 Number of open tables 2048. The VBA Dir function returns the first file or directory name that matches a specified pattern and attributes. One option is to use PI SDK in VBA in order to communicate with the PI Data Archive. To learn more scroll down. The goal is to end up with a separate files for each of your VBA modules so that you can benefit from the Git functionalities. Syntax for specifying an attribute is as follows −. Explore the various Properties and examples on Excel VBA CheckBox control properties using side navigation. You may have to register before you can post: click the register link above to proceed. The command button is a very active control and there is always VBA code behind it. For Command buttons CB1 and CB2. A basic Module is for your normal code, while a UserForm is for creating simple Graphic User Interfaces (GUIs). The xml:space attribute can be placed on any elements in the XML document and given a value of preserve to signal that the white space is significant. The Employee class has two properties with the creative names Property1 and Property2. Hi, Is there a method (might be using PI OLEDB Enterprise) that I can extract AF attribute values to a Processbook using VBA. SAX provides a mechanism for reading data from an XML document that is an alternative to that provided by the Document Object Model (DOM). If you need any more information or I've not been very clear please let me know. Hopefully this guide will serve as a good resource as you try to automate those extremely powerful Pivot Tables in your Excel spreadsheets. Is there a VBA program I can run to accomplish this task, I have failry limited VBA skills and haven't written in VBA for years. jindon, it seems to work except for when the macro reaches a few rows where the item is also blank but has attributes, it stops. The VBA Dir function syntax The Dir function by default DOES NOT TRAVERSE the entire directory structure provided by the given path. Contribute to VBA-tools/VBA-XML development by creating an account on GitHub. In the next dialog, under Attributes, you can set or remove the Read-only and Hidden attributes. Subform1 is the name of the subform CONTROL on mainform. For Command buttons CB1 and CB2. Net Framework provides two types of attributes: the pre-defined attributes and custom built attributes. It’s described in the XML specification in section 2. Strongly typed dictionary collection in VBA In this post, I will show you how to build a strongly type dictionary and how to loop through its elements with a For Each Loop. The programmer thinks that he. The high-end in VBA. To view or change the attributes of a file, right-click the file, and then click Properties. Answer: use the VBA "open" statement to exclusively open the file and trap any errors that may occur. I've extracted product information from my online store into Excel. Friendly Name: This is the name shown in Active Directory Users and Computers. Free VBA Tutorial If you are new to VBA or you want to sharpen your existing VBA skills then why not try out the The Ultimate VBA Tutorial. To overcome this we make some attribute changes and trap any errors that may occur in relation to them as well. You can also define constant attributes. > OK, I've copied the code into a module and had a play with it. Excel VBA Formatting Cells and Values. Index object. Use selectNodes to get a node list in an XML document or XPathNavigator looking for specific. getElementsByTagName(tag_name). Both the WinNT and LDAP providers can be used to work with Active Directory. Reference page: Active Directory - Sample Scripts (Excel/VBA) […] Trackback fromActive Directory Scripting - modify Attributes - Automation Beyond Monday, 1 March, 2010 […] Reference page: Active Directory - Sample Scripts (Excel/VBA) […] Trackback fromActive Directory Scripting - find User Account - Automation Beyond Tuesday, 9. Welcome to the p2p. It works fine on all the standard attributes, but I want to update a user's "Clock" which is a custom attribute we have at my company. VB_VarUserMemId (for module-scope variables) and VB_UserMemId (for procedures) attributes are used in VBA mostly for two things. In the context of the XmlDocument object, an XPath expression can be used to select a set of XmlNode objects to operate on later. setAttribute(). >> CreateProperty (). from the expert community at Experts Exchange This Article provides Excel VBA that will retrieve the properties for all MP3 files that reside anywhere under the User's My Music folder. There are a ton of things you can do with VBA and Excel charts. Attributes overview (Visual Basic) Attributes provide a powerful method of associating metadata, or declarative information, with code (assemblies, types, methods, properties, and so forth). In this tutorial will teach you about how to update an XML file using Microsoft Excel. NET application Connect From Labview nxg to Google Cloud SQL SSIS Package Encrypt password in IBM DB2 Conncetion string Connect PostgreSQL with Visual Studio 2015 Blank vba sql update to Excel 2013 field. It has three. An attribute in HTML is any valid name-value pair for that element. In the Windows Explorer it is possible to view a document's properties. Excel Chart VBA Examples and Tutorials - Setting Chart Types using Excel VBA: We have verity of chart in Excel, we can use VBA to change and set the suitable chart type based on the data which we want to present. This property allows us to get or change the various attributes of a file. This is the snippet Get or Set the ID3 Tag of an mp3 File on FreeVBCode. Attributes overview (Visual Basic) Attributes provide a powerful method of associating metadata, or declarative information, with code (assemblies, types, methods, properties, and so forth). TextString) this works fine for most attributes, but there is a least 1 attribute in a title block that the. x databases. " End If End If End Sub See also. The result is an element with an xmlns attribute. Member 'X' has got all 5 attributes attached. Fortunately, we can use the MSXML2. Last Updated on Mon, 23 Dec 2019 | AutoCAD 2006 VBA. Works just fine. It then adds attributes to that ' block. Attr LDAP Name: Attr Display Name: ADUC Tab: ADUC Field: Property Set: Static Property Method: Hidden Perms: M/O: Syntax: MultiValue: MinRan: MaxRan: OID: GC. The most commonly used object based model by Excel VBA developers to access the computer's file system is the FileSystemObject (FSO), which is available inside the Microsoft Scripting Runtime library. Value ' do stuff. In the example above, each date column becomes a row with an Attribute column containing the date value and a Value column containing the date column value. CopyString str, True ele. the ownship through VBA since VBA can call any application. You can use the SCRIPT element to add VBScript code to an HTML page. A List class that would encapsulate a Collection would want to have an Item property, so the client code can do this:. Objects (Visual Basic for Applications). Code modules and class modules contain "Attribute" statements that provide information about the module and the procedures within the module. A very common problem people encounter when working with IE in VBA is VBA attempting to run code before Internet Explorer has fully loaded. You may have to register before you can post: click the register link above to proceed. Conversion class. By using this code, you tell VBA to repeat a loop until IE is ready (IE. Count End Sub. You may want to read my XML and DTD tutorials. You'll then get back a collection of all elements of that tag name, and in that collection you can find the one you're looking for and set the attribute you're trying to set. Many PowerShell Active Directory module cmdlets, like Get-ADUser, Get-ADGroup, Get-ADComputer, and Get-ADObject, accept LDAP filters with the LDAPFilter parameter. VB_Description = "some string" ' Adds the text to the Object Browser information for the procedure.