JKinzenbaw
It may take me one week to develop such a routine with friendly user interface (I am using AutoCAD VBA)
What this routine can achieve
1. Take your file and automatically populate your 500 monuments in predefined block with insertion X, Y, Z value extracting from Excel, plus...
Hi, JKinzenbaw
>> I have over 500 objects (GPS surveying monuments)
Let me know what kind of ACAD object these monuments are. It's Text, Line or Block?
I may give you some help when I know this
Code taken from http://www.fontstuff.com/vba/vbatut06.htm
Public Function RandomNumbers(Lowest As Long, Highest As Long, _
Optional Decimals As Integer)
Application.Volatile 'Remove this line to "freeze" the numbers
If IsMissing(Decimals) Or Decimals = 0 Then
Randomize...
' API function for getting user name
Public Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
'----------------------------------------------------------------------------------------------------
' Get...
I have moved chunk of my VBA code to ActiveX DLL before and did a comparison of the speed. Surprisingly the executing speed of the two are almost the same. To my own understanding, VBA code cannot be compiled. The way to speed it up is code optimization in the Loop, With block etc.
dongxiao PE...
