First of all, I want to thanks the comments and suggestions you made in this topic.
What I did to protect my spreadsheet is not to include formulas on it. It that case, you will not see the #NAME? or #VALUE! ceels results. Every result will be computed by a macro, which is going to be included...
Hello
I think that this tip may be helpfull. If you want to authorize certain computers that can run an excel spreadsheet, you should do the following.
In a module,
Public Declare Function GetVolumeSerialNumber Lib "kernel32" Alias "GetVolumeInformationA" (ByVal lpRootPathName As String...
Hello all!!
All I need is to rotate a rectangle like this
h=rectangle('Position',[1 1 lx ly],'FaceColor','b')
The rotation can be at any point of the rectangle, but the most freccuently case will be at the center of it.
Any ideas?? I tried with the commands view or rotate, but I don´t want...
Hello
Here is my problems.
I want to change some properties of some lines in Autocad 2004, but I can`t relate the event of change the lines with the code... I doesn`t work!.
I put in a module
Public WithEvents ObjFe As AcadPolyline
an then, for example
Private Sub ObjFe_Modified(ByVal pObject...
Hello All
My question is the next: If I do a shear wall design, defining the "Pier section type" as "Simplified T and C" I can get the Pier longitudinal reinforcing concentrated in both ends of the wall, and in the top and the bottom of it.
My problem is that if I have 2 perpendicular walls...
Hello!
I have de folowing question. How can I execute a macro, wich is in a module, from autocad prompt without using the two line command
-vbarub
macroname
Instead of this, I just want to write
macroname
and the macro starts.
Thanks a lot
The use of Ado sounds good, but the name of the database change on each execution of the program, because its name is the date and the time when the programs starts.
So, the use of ADO its a little bit difficult in thids case.
Help?
In my form, I have a Data control called "Data1" with this properties:
Connect: Access
Default type: 2 Use jet
----------------------------
' An extract of the code is
Data1.DatabaseName = "Here is the name"
Data1.RecordsetType = 0
Data1.RecordSource =...
Hello!
Certain program generates a database in Access 2002 format, but Visual Basic 6 only can recognice Access 97 format. (as I know)
Can anyone tell me if there is a code to transform the database without using sendkeys?
Thanks a lot.
When i said that this is all what I need to know, is because with a line I have a start point to continue with my project. My problem is to start it. I don`t want to do this with sendkeys, because i know that autocad as vba, and with that my programm will have a better performance.
Thanks anyway.
After a long wait, I solved this problem on my own.
In a module, you have to declare
Public Declare Function GetTickCount Lib "kernel32" () As Long
Public Sub wait(ByVal dblMilliseconds As Double)
Dim dblStart As Double
Dim dblEnd As Double
Dim dblTickCount As Double...
Again, i solved the problem before someone replys me.
In a module, declare:
Public Declare Sub mouse_event Lib "user32" (ByVal dwFlags As Long, ByVal dx As Long, ByVal dy As Long, ByVal cButtons As Long, ByVal dwExtraInfo As Long)
Public Declare Function SetCursorPos Lib...