Custom List in Excel is a Great Time Saver which cuts down the chances of Manual Errors. This video discusses Built-in & Custom list in Excel and its Cool Features. Topics discussed are : 1. Builtin Lists in Excel 2. How to Create Custom List by Manual Entry 3. How to Create Custom List by Data in Worksheet 4. Data sorting using Custom List 5. Some cool features of Custom List
The information contained in AutoCAD Points (X, Y, Z Coordinates) are the Building Blocks of Digital Terrain Model. i.e Details stored in AutoCAD points can be used to build DTMs.
Following video is about, How to create a Macro for Extracting details from AutoCAD Points
Topics Discussed are
1. Extracting X, Y & Z Coordinates of Point
2. Extracting layer name of each AutoCAD Point
5. AcadObject & AcadPoint
Code for Extracting Details of AutoCAD Points
Sub ExtractDetailsOfAutoCADPoints()
Open "E:\Tutorials on AutoCAD\ExtractDetailsOfAutoCADPoints\ExtractedDetails.txt" For Output As 1
Dim x, y, z As Double
Dim XLnCADObject As AcadObject
Dim XLnCADPoint As AcadPoint
For Each XLnCADObject In ThisDrawing.ModelSpace
If XLnCADObject.ObjectName = "AcDbPoint" Then
Set XLnCADPoint = XLnCADObject
x = XLnCADPoint.Coordinates(0)
y = XLnCADPoint.Coordinates(1)
z = XLnCADPoint.Coordinates(2)
Print #1, x; y; z; " " & XLnCADPoint.Layer
End If
Next
Close (1)
Dim retval As Variant
retval = Shell("Notepad.exe " & "E:\Tutorials on AutoCAD\ExtractDetailsOfAutoCADPoints\ExtractedDetails.txt", vbNormalFocus)
The latest version of MS Excel has more than 450 inbuilt functions in it. But still, there are times when we feel these functions are not enough to carry out our work. A Simple example is A function that can convert numbers into words. Thousands of accountants will love to have this function in Excel.
The good news is MS Excel allows us to create functions of our own which can make our life easier.
Topics discussed are :
1. Creating User Defined Function (UDFs)
2. Example 1 - Function for finding out Area of Rectangle
3. Example 2 - Function for finding out Area of Triangle
XL Xplorer is something similar to File Explorer in windows. The Treeview option in XL explorer displays the list of every open workbook and associated worksheets in a PC. This list includes the hidden worksheets too.
The most important feature of XL Xplorer is that it helps you to navigate through all those open workbooks and worksheets.
Use of Named Ranges in Excel will make the formulas easy to read, understand and maintain. This is just another Great Time Saver in Excel something similar to Custom Views.
Topics discussed are :
1. Creating a Named Range using Name Box
2. Creating a Names using Name Manager
3. Creating Names from Selection
4. Use in Formula option of Defined Names
5. Uses of Names & Named Ranges
6. Some Cool features of Names & Named Ranges
For receiving notification about video releases, Subscribe to the channel and press the Bell Icon. https://bit.ly/2qvP29e
