AutoCad :: Concatenate Function In Excel

Jul 30, 2013

i am trying to recall how to use the above mentioned function to plot suveyed points into CAD and it is wrecking my head

i can get one point on but to add multiple points is beyond me at the moment.

View 8 Replies


ADVERTISEMENT

AutoCad 2D :: Insert Multiple Block (like Points) Using Excel Concatenate Function?

Nov 27, 2013

So i have a simple block of basically a point. i also have alot of points to input. I know i can attribute the block with promts such as levels or dates etc.. but is there a way to make the block do this by itself when level is already entered? also is there a way to insert multiple block (like the points) using excel concatenate function? or can i input the points and have date and level shown in a text form?

View 2 Replies View Related

AutoCAD .NET :: Property In Class - Function To Get 4 Attributes And Concatenate

Oct 25, 2011

I'm trying to create a property in a class "extractTitleBlock" which searches through the "ExtractBlockRef (AttRef List)".

How would I search through a list of the class object above it? 
 
Public Class extractTitleBlockInherits extractBlockRefPublic ReadOnly Property Description_Concantenated() As StringGet'Function to Get 4 Attributes and Return Concantenated StringEnd GetEnd Propertyend ClassPublic Class extractBlockRefInherits extractEntityPublic Name As StringPublic Space As String

[Code] .........

View 2 Replies View Related

AutoCAD LT :: Import Excel Table Via Data Link Function

Apr 26, 2011

we recently were trying to import an excel table via data link function. Initially this works fine and the table appears in the drawing however when we want to break the link by deleting it in the data link table autocad tells me that the link is in use. We routinely do this in autocad mechanical 2010. The reason we do this is to be able to bring in the table and preserve formatting. How can we easily delete the data link in 2010 LT?

View 9 Replies View Related

AutoCAD VB :: Copying Text After Search Function Into Table Then Transfer To Excel

Oct 19, 2009

I am new to VBA for Autocad and have basic knowledge of Autocad, but have experience with VBA with EXCEL. I am trying to search for text written on to a drawing that has been written as plain text. There is no table. I am writing code to open each drawing in the file as a for each next loop and then find text, then copy text to a table cell, in a table set up within the loop statement. Then I intend to transfer the data to Excel. When I copy the text into the cells of the table and transfer to Excel, the text does not transfer. Is there something I need to do to re-format the text copied straight from the drawing into the table cell. The drawngs have been produced by some external drafting service provider, most likely in India. The functionality of Autocad has not been used and therefore, there are no tables. The text titles, sub-titles etc... are just basically text with lines drawn around them, to simulate a table that looks like a table but are infact not.

My main problem is copying the plain text (titles, sub-titles, references etc...) into a table cell for export to Excel. Any knowledge of copying Autocad plain text to Autocad table cells

View 2 Replies View Related

AutoCAD Inventor :: Concatenate IProperties - Separated With Dash

Apr 14, 2012

I would like to have two fields in the iproperties and then concatenate them together. Lets say one is the the w.o. or project number and the other is the drawing number. I would like to have a third iproperty that concatenates them together seperated with a dash (EX. 200970-301).

View 2 Replies View Related

Revit :: Concatenate 2 Parameters Into One

Mar 8, 2013

Is it possible to concatenate 2 parameters into one in Revit.  So I want the door parameters (i.e. Width, height)  to be automatically generated by the family.  I want those two parameters to be joined in one field width x height.  This is what the department wants. 

If I can't then I can't.  I know earlier versions of Revit could not concatenate.  This is one example but there re several instances where I want (2) separate fields/ parameters to report into one field that can then be used fro a schedule. 

View 2 Replies View Related

AutoCAD Visual LISP / AutoLISP :: No Function Definition With Distance Function

Oct 25, 2013

This seems absolutly silly.

(setq p1 (getpoint))
(setq p2 (getpoint))

(setq Dist (distance p1 p2))

Why does this not work?

I'm trying to build a command to replace AutoCAD's "DI" command, to give distance and delta x, y, and z values in decimal and imperial, and keep the angles in XY plane and out of XY plane.

View 9 Replies View Related

AutoCAD Inventor :: Passing A Function Name To Another Function

Nov 13, 2012

I'm trying to be able to have a function run another function with the secondary function being passed as an argument to the first. I'm trying to create a recursive function and the recursive part works great. I just need to be able to have the recursive function run other functions to actually do stuff.

Here is something I found that should do what I need, mainly run a function from a function name in a variable.
 
Sub test() Dim ftnName As String Dim argument As String Dim result As String ftnName = "myFunction" argument = "cat" result = Application.Run(ftnName, argument) MsgBox resultEnd SubFunction myFunction(inString As String) As String myFunction = inString & " has " & Len(inString) & " letters."End Function

 However I get the error "object required" on the "result = Application.Run(ftnName, argument)" line. So I'm guessing the Inventor VBA doesn't like this method of doing this. I'm just hoping there is a way to do this or this function will be useless or reduced to hardcoding functions which still defeats the purpose.

View 2 Replies View Related

AutoCAD Inventor :: When Link Excel Document To Model All Parameters In Excel Gets Unit (mm)

Oct 30, 2008

When I link in an excel document to my model all parameters in that excel gets the unit (mm).

How can I change this? For instance I want some of the parameters to be an angle.

View 8 Replies View Related

AutoCAD Inventor :: Excel Installation Is Required / Failed To Launch Excel

Sep 4, 2013

Recently I have been trying to build table driven products and ipart tables, but when I copy a member to create a new part number, upon exiting the iassembly author I get the following message "excel installation is required for this operation. failed to launch excel". I have a fully functional version of 2010 Excel installed which has been used so it should be recognized in the windows registry. I am running Windows 8 and Autodesk Inventor 2014.

View 6 Replies View Related

AutoCAD 2013 :: Paste Special Excel Files That Automatically Update / When Excel File Changes

May 29, 2013

I have AutoCAD 2013 and often "paste special" excel files that automatically update when the excel file changes.The problem I'm running into is I work with a person who has uses an older version of CAD 2004, so I always save to the older format for him. 

When I etransmit, I be sure to add the excel file, but when he opens the dwg, only the outline of the excel appears in his dwg, no content. 

View 8 Replies View Related

AutoCad :: Remove Excel Link But Keep Table (Embed Excel Table)

Feb 13, 2012

We have a whole bunch of spreadsheets that we use for calculations and parts of those spreadsheets are linked to a ton of CAD Drawings via data links.

We would like to be able to deliver the CAD drawings to the client without having to send our calculation books (just the output tables). In other words, is it possible to embed the table data and remove the excel link for the final delivery?

View 3 Replies View Related

AutoCAD .NET :: Run Function As Soon As DLL Loads?

Mar 29, 2012

Is there a way to run some code as soon as a .dll file is loaded without having to using lisp (command "Function_Name")?

View 5 Replies View Related

AutoCAD .NET :: How To Use Acedssget () Function Using C#

Jan 6, 2013

How to use acedssget() function(use this function to select by crossing polygon) in autocad development using C# .

View 6 Replies View Related

AutoCAD Map 3D :: Dtext Function Not Working?

Mar 3, 2013

have just loaded 2013 along with service pack.

dtext function not working. when doing dtext but using the insertion point of some previous text. will not move to next line unless some text placed on first line. is there a setting, no issue in 2011

View 1 Replies View Related

AutoCAD LT :: Group Function Not Working

Jun 9, 2005

ACLT2000 on a Windows XP machine.

In the last day, one of our users has lost his ability to Group. Whether he selects objects and then pulls down "Group" from the tools menu or vice versa, the objects do not group. The command line text doesn't give any errors or other indication of what is happening.

View 3 Replies View Related

AutoCAD Civil 3D :: Export To PDF Function

Feb 8, 2013

I am trying to use the "Export to pdf" function as opposed to plotting as a pdf because the "Export" function seems to make a much smaller file size. However, when I "Export to pdf" some of my layers are not showing up in the created pdf.

The pdf created when I plot to pdf looks fine. I am using the "current layout" and "current" page setup options in the "Export to pdf", so it is using the same plotting options as plot to pdf, but the "Export" function is not displaying some layers.

View 5 Replies View Related

AutoCAD Inventor :: Function To Set Colors

Sep 14, 2013

I have a big assembly consisting of a large number of sub assemblies and parts.I would like to be able to quickly show color alternatives. All painted parts will be painted in one of two colors.I would like to have a function that takes two color arguments that will set the color of a number of parts to the first color and some other parts to the second color. Not all parts need to be painted.

set the color of all parts in a assembly to one color.But I have two sets of parts for different colors and not all parts need to be colored.How can I do this best? iLogic? How do I have to input the colors?

How to deal with repeating patterns (should still work when changing the repeat count)?Also, there should be some text on some parts. Can I also change this text color automatically?

View 3 Replies View Related

AutoCad :: Function Keys As Osnaps?

Aug 25, 2006

have finished loading 2007 onto them.Now, back with 2006 we could set osnaps to the function keys (e.g. F2 to snap to END). I have been told that you can't do this with 2007.

View 9 Replies View Related

AutoCAD LT :: Function Keys Not Toggling?

Dec 4, 2010

I am running CAD 2007 LT. Old laptop runs windows XP. On black Friday I purchased a new laptop with windows 7. All is well except the F3 & F8 I am so used to aren't allowing me to toggle on off. I have discovered that the fn button (lower left) by the ctrl button will let me toggle 1 time but have to hit the fn each time then F3 or F8.

View 9 Replies View Related

AutoCAD Inventor :: How To Use Or Find PCD Function

Nov 24, 2011

i dont know how to use or find the PCD  function. All i have is a base however i need to make holes with 90 degrees on a 100 PCD

View 2 Replies View Related

AutoCad :: Setting Up Function Keys?

Nov 29, 2011

changing the F12 key. I want to use it set the UCS to object. I assume it done be amending the CUI. I found the shortcut for the current use of the F12 which reads

'^P'_.dynmode $M=$(if,$(>,$(getvar,dynmode),0),$(*,$(getvar,dynm ode),-1),$(getvar,dynmode))'

what I need to type to set the UCS to object.

View 4 Replies View Related

AutoCAD Inventor :: Rib Function Cannot Create Rib

Dec 26, 2011

I'm trying to create a rib from the sketch shown.  Before I go to support with this, how to make it work or why it won't?  I think Inventor just isn't up to it.  If I add perpendicular lines to the endpoints of the line shown, it'll make rib, but the rib isn't right - i.e. it doesn't maintain tangency the way it should.  I'd rather not have to go through and surface it.

Infrastructure DSP '14 / Product DSP '14 / Vault Professional 2014
Dell Precision T1650
Windows 7 Professional SP1 64-bit
Intel E3-1270 V2 3.5GHz / 32G RAM
Nvidia Quadro 2000, Driver 331.82
Space Navigator, Driver Version 6.17.7

View 1 Replies View Related

AutoCAD Inventor :: How To Get The Thread Function

Jun 13, 2012

I have recently installed Inventor 2013 Professional Ultimate and am having some issues.  I can not seem to get the Thread function to work.  When I go to apply a thread I get the follow error....

When I go to search the directory, I find that the Thread xls document is infact there, but it is not located where the program thinks it should be (XLS Folder --> en-US Folder)

I also made sure that the Design Data location was correct within the Application Options...

A reboot of the computer did not work.

View 1 Replies View Related

AutoCAD Inventor :: Custom VBA Function In Parameter

Jan 31, 2013

I've got a custom VBA function that works perfectly when called from a parameter in my part.

However, when in the context of my assembly, there is no error, but the function no longer runs, and the parameter text is red.

Apparently, the function is no longer in context?

I've heard of external rules, but have never implemented one.

Is there a way to declare my function and keep it in context regardless?
 
Public Function BumpHeight(dblHeight As Double, dblMember As Double) As Double Dim X As Integer X = 2 If dblHeight > dblMember * 2 Then BumpHeight = dblHeight Else BumpHeight = dblMember * X End If BumpHeight = BumpHeight / 2.54 End Function
Here is the Parameter:

 VBA:BumpHeight(ValanceBackBumpoutHeight;ValanceMemberSize) * 1 in

Update: (problem better defined)

What seems to be happening is that once I insert the part into an assembly, it creates a new blank copy of the parts' modules in VBA and the functions no longer work.

If I go to the VBA editor, 

There are now two copies of my part listed in the browser tree, but the new one is blank.

If I paste in my function to the new one, it will work until I return to the parent assembly.

Next time I come back to the part, it will have a new blank set of modules.

This appears to continue indefinitely...

see the attached screenshot.

At this point there are only 2 copies of the DocumentProject. The original still contains my functions, but the new one is blank.

I need these functions to work in order to build my model.

View 1 Replies View Related

AutoCAD Inventor :: Fame Analysis Function

Dec 22, 2011

I have purchased the Autodesk Product Design Suite Premium. It comes with the Frame Generator but does not seem to have the Frame Analysis with it. Is that provided in other Suites or should I have it??

View 1 Replies View Related

AutoCAD .NET :: Return Function With Multiple Objects

Apr 28, 2011

I would like to return multiple objects from a function. can it be done? and how?

function DrawLines()as object
objline1 as new line
objline2 as new line
[..]
return 'objects'

[code]....

View 2 Replies View Related

AutoCAD 2013 :: Turning Off Dynmode Function

Jan 31, 2013

I am having on going issues with the DYNMODE function in AutoCAD 2013. I know to turn off completely set to 0, but it keeps frequently turning itself back on and setting itself to -1?!

Not a huge issue I know, but I do not like this command at all. How I can turn it off completely?

View 6 Replies View Related

AutoCAD .NET :: Keep Variable After Quit Main Function Of DLL?

Feb 12, 2013

I want to load my DLL, launch the function with a command. After i quit and lauch the same command. (The DLL is already in memory).

(using sessionflags.)

It is possible to keep the variable i have used in the the first launch for use in the second launch ?

The main function is for adding block in a collection (the user select block). The programm quit, so the user can open a another dwg and run the main function for adding another  block. (i memorize name, handle, name of file etc..)

Another question : it is possible to create a form in autocad but if the only active document is closed, the form is not closed and visible. ?

All there question is for create a best solution for manage my collection of block.

View 5 Replies View Related

AutoCAD Inventor :: Changing Zoom Function In 2D?

Aug 29, 2012

When I use AutoCAD Inventor:

* Rolling the mouse wheel toward me, the object zooms larger, and

* Rolling the mouse wheel away from my body, the object zooms smaller.

Just the opposite, when I use good ole' 2D AutoCAD and AutoCAD Electrical:

* Rolling the mouse wheel toward me, the object zooms smaller, and

* Rolling the mouse wheel away from my body, the object zooms larger.

Is it possible to change the zoom function in 2D AutoCAD and AutoCAD Electrical to operate in the same fashion as in Inventor . . .

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved