We have this problem at the moment with an Microsoft excel file that appears to have become stuck in the External references list, Ref C1-01-06. We would like to remove it if possible as it is now superseded (we can't change the file name unfortunately. What do we do if we can't reload, detach or bind? Its not referenced into anything else that is attached to the file, it is a direct attachment of the file that we are in.
View 3 RepliesI cannot seem to open .dwg files from an email using AutoCAD LT 2010
I get an error saying c:users"username" empoutlookj0814-052.dwg is currently in use or is read only.
Would you like to open the file ready-only?
I can save the file then open it. But the user wants to open the attachment straight from the email.
I've tried changing the attributes on the folder from read only but this doesn't work, tried another profile, again this doesn't work.
It does seem to only effect .dwg files when opening with AutoCAD LT 2010. If someone sends an xls, .doc, .pdf attachment they all open OK, I'm sure this is an AutoCAD LT 2010 issue. I have downloaded and installed both hotfixes / patches from the autodesk website and reinstalled the software but this hasn't worked either.
I am making an excel spreadsheet that has a list of all the drawings we have on file, an inventory list per say. I have all of the drawings hyperlinked.
View 3 Replies View RelatedIf I place a link to a dwg as a hyperlink in an Excel file, AutoCAD freezes. It opens the drawing, then AutoCAD is completely locked. I have to close it through task manager.
This has been tested wih multiple drawings and excel file and it happens in all of them. I'm using Excel 2010 and AutoCAD 2010.
Win7 x64 - 16gb ram
i7 3610qm
FirePro M4000
Inventor 2013
ETO 6.1
when i try to link an excel file to the parameters dialog box i get a message telling me it is "NOT IMPLEMENTED". i just upgraded to windows 7 because it is now supported by autodesk.
View 9 Replies View RelatedI linked an excel (2010) file with an inventor (2011) .ipt and none of the parameters are showing inside inventor. I was leaving the file external but I embed it also as a trouble shooting step and nothing still. I have no spaces in excel sheet. Is there something special i need to be doing inside excel or inventor?
View 5 Replies View RelatedThis has happened on all versions of AutoCAD in our office.
I paste schedules from Excel into AutoCAD. I print out the sheets and ghost lines appear on the PDF and hard copy that were not intentionally place in the excel file. What is happening and what can be done about it.
I also paste a tif file on a sheet change the setting to imageframe <0> and a residual line willl appear in pdf and hard copy that seems to be the border of the tif image.
I've spent the last 4 hours searching for an answer to this question, but I simply can't find one.
As a start I think you have to know that I'm currently using AutoCAD 2012.
Here's the problem: I need to extract some info from an AutoCAD table to a reference file that can be opened in Microsoft Excel. Everything I find on the subject is actually an answer to the question "How does <DATAEXTRACTION> work?" or "How to do an extraction of DATA in AutoCAD?"....
In this particular case I have a set of production drawings (cut tickets) for manufacturing of stone. And in every single sheet I have this material schedule or a table, if you wish, that is made with an AutoCAD table. In this schedule I have the height, width and thickness of the stone plate and with a function it measures it's area and volume. What I want to do is to extract those values into a reference file that I can open with Microsoft Excel, as I already said.
How exactly?
Is there a way to attach any animated file in the drawing such that the attached image remains animated in the Drawing file also (for example animated GIF images)?
View 1 Replies View RelatedI 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.
When I attempt to load xref the dialogue for file attachment does not appear. This has only started happening the past day or so. The same applies to image files etc.
View 2 Replies View RelatedWhen i got an E-mail with a CDR File, i want to move this file directly form Outlook 2010 in CorelDraw X6 with Drag & Drop.
Just in the Moment, it dosen`t Work !! I can´t move the CDR File from Outlook in CorelDraw X6
Trying to create a dynamic block that will multiply the number of neutral and ground blocks as it's stretched.
My power terminal strips can contain 1 to unknown number of circuit breakers, and each circuit breaker requires a neutral and a ground block.
All the similar items in a stip are grouped together, all the circuit breakers, then the neutrals than the grounds.
So depending on how many circuit breakers I have I'll need the same number of neutrals and grounds, but grouped together.
In the attached block I added the stretch action to move the end cover and end stop of the strip down, but don't know how array/space/stretch the neutrals and grounds so they're grouped together.
The ciruict breakers aren't shown as they can be from different manufacturers and therefore different widths.
Tried attaching my block file but get this error message:
"The contents of the attachment doesn't match its file type."
I have a drawing which has hundreds of levels on and i'm trying to establish what the MEAN level is and the AVERAGE level. I thought the best way might be to extract the text to excel and perform it there but at the moment the only way i can do it is to copy and paste the text and its taking me forever. Is there a way to either a) extract text to excel or b) calculate a MEAN value based on texted selected?
View 2 Replies View RelatedNow is the pattern problem in hands! I try to attach patterns to wall: Materials, Cut pattern, New, Drafting pattern, Custom, Import:
And path: C/Program files/Autodesk/Revit Architecture 2011/Data
And there: Revit.pat (or any other *.pat file that I have).
And there it comes: An error! Syntax error in line 2 or 12 or 10 ? What has happened? Before I was managed to attach patterns ok. To an other project I mean.
Where on earth is the problem? In the project? The whole program? In the pattern file?
I am trying to export each sheet in an Excel file to an separateTXT files.
I currently have code to read each cell in a sheet, but unfortunately some of the Excel sheets have in excess of 5000 cells and it is taking too long to read. So I am switching to another method.
The program will check dates of TXT files and XLS file to make sure TXT files are current (if not, open and recreate TXT files).Then read the TXT files (much faster).
Where I am getting stuck is 2 places -
Get the names of each sheet in the excel file (not always a known name)
Save each sheet as separate TXT file.
Here is condensed code so far without error checking, etc -
(defun E2TXT (FileName /)
(if (and (setq XLfile (findfile FileName)) (vl-file-systime XLfile) (setq XLapp (vlax-get-or-create-object "Excel.Application")))
(progn
[Code]....
Ok, I'm sure there is a very simple way to fix this that I just haven't yet discovered. When I insert a stacked dimension in the top line of my leader text, the spacing gets automatically adjusted for the hight of the stacked dimension and it adjusts the leader line up so that it actually passes through my top line. Can this be avoided? I have attached a picture for reference.
View 4 Replies View RelatedI'm linking an excel file to an .ipt file with iLogic code determining if the Material type is a certian value it will find the correct material thickness. These file work great when working on them thru Vault but when I "Save As Template" and create this file where our other template files are located (not Vault) this fuction does not work. I have realized that I had to place the a copy of the excel file in the same file folder as the template ipt, but even this does not fix the issue.
I recieve this error:
Error in rule: Material, in document: Part6
'MWW Materials (Inventor).xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct.
If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted.
It seems completly countintutive that just saving the file as a template file would cause this not to work when all files that are required are located in the same file folder. Maybe I need a reference to the excel document within the iLogic code.
i have deleted the excel file from the ipt file but when i open the part file it is still looking for the excel file. i am using inv 10 sp1 and excel 2000
View 7 Replies View RelatedCan export the repair details from dwg drawing prepared by asd in to excel by the use of auto cad?
View 3 Replies View RelatedI have a table imported into autocad from excel, however despite the table (excel) being formatted, border lines appropriately placed and hidden througout the sheet, all off the border lines of the cells appear when imported into autocad.
is there anything i can do to hide back some border lines for selected cells?
I created an assembly, so far with one part in it. I created an Excel spreadsheet with several dimensions in it that would be used in the assembly parts. I went to Manage>Parameters and linked the spreadsheet. The Excel file appeared in the Parameter Dialog Box with the parameters included in it. However, when I create a part in the assembly and attempt to dimension a sketch in it, the parameters option in the dimension box is not present.
I have done this in the past in IV2009, has anything changed that I cannot do so in 2010?
I am trying to add an excel document to a cad drawing using ole. I wish to make it transparent so that only the cells themselves are visible and not the white background and empty cells. (I hope that makes sense).
View 3 Replies View RelatedWhat is the best way to Insert an Excel sheet into autocad?
View 4 Replies View RelatedI use an embedded excel file I a lot of my drawings. 90% of the time a double click opens excel for editing with no problem. But every so often I get a stubborn one that just will not open. It will select and the quick properties box will appear and then the properties box, but nor firing up of Excel. Usually if I am persistent I can get it to work, but I have one right now that is more stubborn than I am.
View 2 Replies View RelatedSeems like i export the data of thickness, diameter, lenght and mass to excel via dataextraction, but if i change something in the drawing, its not updated in the excel file..
I also wanted to export the data to an already existing part list template, but this seems impossible...
I'm trying to link excel to autocad for a time now.
and until now it didn't work for me.
Everytime it says "1 data link(s) do not allow their data to be written out."
thats when i try to write it to the excel file.
Using AutoCAD 2010, and I'm having problems printing with one dwg, that I've had to copy an Excel Spreadsheet into. The spreadsheet was created with Excel 2007, and has quite a bit of text in it, and I'm trying to print it on an E size sheet, to an HP Designjet 4000. AutoCAD hangs up each time I try to print this, and my computer gets a message indicating that I'm low on disk space, even tho I do have plenty of space. It's like Autocad is taking more resources than it normally should. How I can insert this spreadsheet into AutoCAD and be able to print it? I've inserted the spreadsheet in model space, and the titleblock/border is in paperspace. I've tried printing to pdf and exporting to other formats to see if that will work, but AutoCAD keeps hanging up. Any other AutoCAD dwg works fine to print to the printer. It's just this one file with a spreadsheet inserted into it.
View 5 Replies View RelatedI just installed Autocad 2011. I have Excel tables in one of my drawings that was in Autocad 2004.
However, with new 2011, I can not bring the OLE to Excel where I want to edit.
I got "OLE Failed to launch server app" error message.
I search around. It seems that I need to try the command "OLELINKS". But my OLELINKS under EDIT is DISABLED!
Everytime I open up a new drawing an error pops up that there is (2) Xref that cant load. It seems to be the same (2) Excel files I have to go to the Datalink Manager and delete them. Is there any way to get in the Datalink Manager without opening a drawing to unlink these?
View 3 Replies View RelatedI have been having an issue when printing to PDF from AutoCAD my Excel spreadsheets show up with gridlines that are not there in there Excel or CAD. I have tried a number of things to eliminate that lines (see list below) but nothing has worked so far. I am running AutoCAD 2012 and Excel 2003. I have inserted the spreadsheet using "Paste Special" so that I can continue to work on the spreadsheet in excel and it will update in CAD.
- I have changes the Plot Quality. In Monochrome the lines print. Low quality the spreadsheet does not show up. High quality again nothing shows up
- In Excel I have turned off the "Gridlines" and re-copied into AutoCAD. The lines still show up when printing to PDF
- If I paste as an AutoCAD Entity I can not update in Excel