AutoCAD Inventor :: Open Embedded XL Sheet With ILogic?
Nov 8, 2012Is it possible to open an embedded XL sheet with iLogic ?
I tried "GoExcel.Open("3rd Party:Embedding 2", "ENTREE DES DONNEES"), but nothing happen...
ADVERTISEMENT
AutoCAD Inventor :: Embedded Excel Spreadsheet (Open / Save And Close) (iLogic)
Apr 30, 2013I have some code (below) that will open my embedded excel spread sheet and it works great. Now I need the code to save and close the excel file after it’s been open.The embedded excel spreadsheet pushes some stuff the model and does a couple other thing. So all I really need is for the excel file to open, save, and close when the rule is run.Imports Inventor.
OLEDocumentTypeEnumExcelApp = CreateObject("Excel.Application")Dim ExcelFile As ReferencedOLEFileDescriptorExcelFile
=hisDoc.Document.ReferencedOLEFileDescriptors.Item(1)ExcelFile.Activate(kEditOpenOLEVerb, ExcelApp)
AutoCAD Inventor :: Embedded Spreadsheets And ILogic
Jan 14, 2011I have an Embedded spreadsheet in a .ipt file. I want to access the data in it using iLogic, but i keep getting this error...
GoExcel: 3rd Party worksheet not found: "3rd Party:Embedding 1", Sheet: "Sheet1"
Do I need to declare the spreadsheet somehow, or is there something else I missing? This is the only code I have in the rule...
i = GoExcel.FindRow("3rd Party:Embedding 1", "Sheet1", "ID", "=", 1
AutoCAD Inventor :: ILogic - Replace Or Refresh Embedded Excel Spreadsheet
Sep 20, 2013For Creating my own templates i want to use iLogic and embedded Excel-Spreadsheets. The embedded Sheet has its own data, but i want to create a rule to refresh the data from an external Excelsheet.
For now i use the following rule:
For I = 65 To 90 '65=A 90=ZBuchstabe = Chr(I) GoExcel.CellValues("3rd Party:Embedding 1", "Platte", Buchstabe & "1", Buchstabe & "999") = GoExcel.CellValues("G:KonstruktionVorlagenMaterialgrunddaten.xlsx", "Platte", Buchstabe & "1", Buchstabe & "A999")Next I
it works well, but wont insert a new single-sheet or refresh formats, i have to add the same code for each sheet. And its REALLY slow.
Is there a possibility to refresh or replace the whole embedded file via a simple iLogic-rule?
AutoCAD Inventor :: ILogic - MultiValue Parameter - Get Named Range From Embedded Excel
Jan 9, 2013I have a MultiValue Parameter that I want to populate using a named range from an embedded excel spreadsheet. I would like an iLogic solution if possible because I need other people to be able to understand the code without too much difficulty.
One of the sample snippets given allows access but not if the excel file is embedded.
'GoExcel.NamedRangeValue("Part_Width")
The code below works but not when using a named range.
' Load bearing housing typesMultiValue.List("parameter1") = GoExcel.CellValues("A1","A20")
Is there something I'm missing? I was hoping to use something like below
' Populate MultiValue Parameter from excelMultiValue.List("parameter1") = GoExcel.CellValues("3rd Party:Embedding 4", "Sheet", "myNamedRange")
AutoCAD Inventor :: Create A Sheet With ILogic?
Nov 23, 2012What is the code to create (or add) a new sheet in a drawing with iLogic?
View 1 Replies View RelatedAutoCAD Inventor :: Drawing Sheet ILogic
Apr 19, 2013 have 2 questions
1.) If you look at the attached screenshot in the Edit Sheet form there is a sheet "Revision" input field is it possible to fill this out via iLogic?
2.) We have some custom E size sheets (height always 34in width varies 5ft, 6ft, and 8ft) when we select on of these sheet sizes that we created it will display "Custom Size (inch)" when using the sheet property <sheet size> in the title block not the name of that we gave these sheets (Which creatively enough is "E-5ft", "E-6ft", and "E-8ft"). I thought I had this solved by doing this:
Dim oSheetSize As String
oSheetSize = ActiveSheet.Size
If oSheetSize = "Custom" Then
iProperties.Value("Custom", "SheetSize") = "E"
Else iProperties.Value("Custom", "SheetSize") = oSheetSize
End If
then change the titleblock sheet size field from sheet property <sheet size> to custom drawing properties <SheetSize> this all works great if there is only 1 sheet in the IDW where it fails is if there is more then one sheet.
AutoCAD Inventor :: ILogic To Change Sheet Name
Oct 31, 2013I've seen snipppets of code to get the Sheet name but is there a way to set it via code? I'm thinking it might be useful to set the sheet names to the chosen sheet format (as opposed to just 'Sheet').
I'm sprucing up my drawing template...
Rule #1 is for selecting sheet format (which title block/sheet size / orientation)
Rule #2 is for setting iproperty values to populate the titleblock with info. (if required)
Rule #1 was based on code from S.Bixler & inventortrenches
Rule#2 was based on more code taken from here.
AutoCAD Inventor :: Create Sheet In Excel With ILogic
Jan 9, 2014I am trying to create a new sheet in an existing excel file and can not figure out how to do it.
I am trying to export parts lists from multiple drawings to an exisitng excel spreadsheet and I'd like have each on their own sheet. I can do everything but create a sheet. How to do this in iLogic?
Inventor Pro 2013 (PDS Ultimate)
Vault Pro 2013
Windows 7 64
Xeon 2.4 Ghz 12GB
AutoCAD Inventor :: Sheet Metal Controlled Through ILogic
Mar 4, 2013Any way or a code to physically change the sheet metal defaults using iLogic code, I want to change parts in my assembly without opening each individual part and changing it there. Inventor 2014, Windows 7, 64 bit.
View 8 Replies View RelatedAutoCAD Inventor :: Custom Sheet Size Using ILogic
Jan 15, 2013I made a form that allows the user to enter in a custom sheet size. Using the API I am changing the Drawing Sheet Size Enumerator to the Custom Sheet size which allows the user to enter in custom values. That part is all working fine. My problem is that when a custom size is used in my title block it says that the size is "Custom Size (mm)". I know that the API uses cm for the sheet size units so I have the code convert the values into cm.
In the sheet settings window built into inventor it has the option for Custom Size (inches) and Custom Size (mm). How do I change whether it is inches or mm?
AutoCAD Inventor :: ILogic Access To Drawing Sheet Revision
Sep 27, 2012how to access the drawing sheet revisions using Ilogic.My company is wanting to start making the default initial rev on a drawing a "-" and inventor does not like to keep this when brought in as a template.
So like normal I am trying to trick it into having the dash until a rev is actually added.
AutoCAD Inventor :: Reference Drawing Sheet Number With ILogic?
Dec 11, 2012How to reference the drawign sheet number using iLogic? I see on the snippets on the side a way to reference the sheet name, but I only want the number. To get the name it is ActiveSheet.Name, but ActiveSheet.Number does not work. Getting the name give something like ASSM:1, so if there was a way to take that and subtract the colon and everything before it that would work also. I am not a programmer, I've just taked some programs I found online and modified them a little to do what I want to do, but this is holding me back a bit.
Overall, I'm trying to modify the drawing view label to have a project number, referenced from the drawign iProperties, a view label, and sheet number, and then save that info in an iproperty of the part, and then reference that in the BOM so it automatically labels all of the views and fills out a column of the BOM to reference which page and view to find the parts of the assembly. I have everything working except for the sheet number.
AutoCAD Inventor :: Imports Sheet Metal Rule From ILogic?
Oct 3, 2013Is this possible in ilogits? Imports sheet metall rule from ilogic
View 1 Replies View RelatedAutoCAD Inventor :: ILogic - Automatic Print With Right Sheet Size
Nov 6, 2012Dont have a before print Event Triggers . I want to make a rule with automatic print with a right sheet size, but in all my try don't work
that is my last one
'Dim oDraw As Document
oDraw = ThisApplication.ActiveDocument
oDrawDoc = ThisApplication.ActiveDocument
oDrgPrintMgr = oDrawDoc.PrintManager
[code]........
AutoCAD Inventor :: Import Sheet Metal Style In ILogic
Sep 11, 2013importing a sheet metal style (STYLENAME.styxml) into a sheet metal part.
I would like to automatically import the style using an iLogic script.
AutoCAD Inventor :: ILogic Rule For Modeling / Sheet Metal State?
Oct 6, 2011What is the iLogic rule for identifying if a part is in a "modeling" state or "sheet metal" state?
View 5 Replies View RelatedAutoCAD Inventor :: Sheet Metal Defaults (Use Thickness From Rule) - ILogic
Sep 9, 2013know a rule to check if this dialog box sheet metal defaults "Use Thickness from Rule" is checked, and checked a rule to automatically clear since using a rule amending the plate thickness but if the box is checked catastrophic error occurs, and unchecking the rule works as expected.
View 2 Replies View RelatedAutoCAD Inventor :: Ilogic - Sheet Metal Part Auto Update
Oct 18, 2013i made a sheet metal part.ipt but that file is not updating immediately, i have added
iLogicVb.UpdateWhenDone = True
InventorVb.DocumentUpdate()
also tick marked in parameters for IMMEDIATe update
AutoCAD Inventor :: ILogic Rule To Insert Sheet Metal Thickness
May 1, 2013In my title block I have a material section that pulls to iProperties from the model
One is material, which displays the material used in the model
and the other is manually input by me in the comments section of the model, I typically only use this field for sheet metal description, example, .125 Sheet Metal, this saves me from a drawing view to show thickness only.
In my sheet metal template I have checked the little box for the thickness model parameter so it will show up as a custom property - model.
So i can display the thickness parameter anytime the sheet metal base view is placed.
My issue is I want the thickness property to have the following with it "Sheet Metal"
But I only want this to appear if the base view is in fact sheet metal, all other parts and assemblies, this field would be blank,
So this is what I want when a sheet metal part is placed:
This is what I want to display when a part is placed:
This is what I get when anything is placed:
Sheet Metal shows up because:
I am looking for a Rule that will only apply <Thickness> Sheet Metal to my title block only if the base view is in fact a sheet metal part. Is this possible??
Inventor Professional 2014-Update 2 - AutoCAD Electrical 2014
Win7-x64 | ASUS P8Z77-V | i7 3770 -3.4 GHz | 32GB RAM |
240GB SSD | nVidia GTX 670 4GB - 320.49
AutoCAD .NET :: Read Embedded Excel Sheet?
Feb 8, 2013I have a drawing with an embedded Excel sheet. I want to read the contents of the excel sheet. Maybe in combination with Microsoft.Office.Interop.Excel?
View 9 Replies View RelatedAutoCAD Inventor :: ILogic Error (changing Sheet Border And Title Blocks)
Jun 18, 2012I'm having an error with Ilogic parameters.I just wanna change the border and the title blocks with Ilogic. This should be simple. Isn't this?
View 2 Replies View RelatedAutoCAD Inventor :: ILogic - Reposition Revision Table On Sheet Size Change
Sep 24, 2012a customer has a title block with a revision table ( standard vault revision table) add on top of it.
If you change the sheet size the revision table remains his position.
If found the way to reposition the table with a ilogic rule.:
'point afstand in cm
PointX=(ActiveSheet.Width/10)-13
PointY=5.5
'punt vanaf rechtonder gemeten in cm
[Code]....
This is working perfectly. But now the challange how to trigger this rule to run if you change the sheet size?
if tried:
trigger=Activesheet.size
or
to create a userparameter and added this line in my rule : Size=ActiveSheet.size, normaly is you change parameters it triggers the rule to rule. but both way didn't work.
Can event triggers from the API be used? Do i need the "Onchange" event? Any example for a ilogic rule?
AutoCAD Inventor :: Sheet Metal ILogic Rule Not Executing On Non-rectangular Base Sketch?
Aug 5, 2013I have a template that I have created, in it I have a rule that changes the stock number and description based on which sheet metal rule is selected. The weird thing is it works correctly if the first sketch is a rectangle. If you sketch a circular shape and make that the face it will not work. It blanks out the values for the stock number and description.
I'm running Inventor 2014 update 2.
Format:HTML Format Version:1.0 StartHTML: 165 EndHTML: 33212 StartFragment: 314 EndFragment: 33180 StartSelection: 314 EndSelection: 314
SyntaxEditor Code Snippet
DimiPropValAsString=""
DimiPropDesAsString=""
SelectCaseSheetMetal.GetActiveStyle()
[code]...
AutoCAD Inventor :: Open IDW File Using ILogic
Jul 19, 2013Is there a way I can open an idw file using ilogic? I would like to put the rule into a form, so that I can click a button in the form to open the idw for my assembly.
Inventor 2014
HP Pavilion dv6t-6b00
Intel Core i7 2670QM
AMD Radeon HD 6490M
8gb RAM
Windows 7 64 bit
3Dconnexion SpaceExplorer
AutoCAD Inventor :: ILogic Message Box At File Open?
Oct 2, 2013My goal is to have a message box open as soon as an assembly file is opened so that other users will be warned/ notified of linked parameters. My assumption is that an iLogic rule would be the best way to handle this.
I can create the message box, but when I looked through the iLogic snippets I didn't find any way to trigger the box at opening the file.
Inventor 2013 (SP2 Update 2), Windows 7 Professional (64-bit), SP1, Intel Xeon 3.07GHz CPU, 12GB RAM, NVIDIA Quadro 2000, Vault Basic 2013
AutoCAD Inventor :: Open Word File And Save As From ILogic / VBA?
Nov 14, 2013We have a word file that we use a lot for our drawings. There is an empty file that we open and then save the file into the same directory as the drawing.
I am trying to setup some code that will open the empty Word File, and then bring up the Word Save As dialog box with the correct directory and file name already completed. The correct directory and File name will be determined by the Drawing Code.
I have been able to open the Empty Word Document from iLogic with the following
'CRS Template Path & File NameoCRSTemplate = "\WWSERVERDisplaysA-Z Stand PartsCRS-Template.doc" 'Publish document. ThisDoc.Launch(oCRSTemplate)
I have been able to Open the Empty Word File from VBA and then bring up the Word Save As Dialog Box but I cannot work out how to define the initial directory or the initial file name from Inventor.
This is the VBA Code I have been using top open the Empty Word File and Show the Word Save As Dialog Box:
Public Sub OpenCRSDoc1()
'Don't Forget to Add the Word Object Library in the Tools - References
' Call SetCRSDetails
[Code].....
If you try to use the With Command for the FilePicker it will just open the Word Document and NOT the Save As Dialog Box!!!
Example of the With Tried
With FilePicker
.InitialDirectory = "Z:"
.DialogTitle = "Hello"
.Show
End With
How to open a Word Document from either iLogic or VBA (VBA Preferred) and then open the Word Save As Dilog Box and define the Initial Directory and Filename?
AutoCAD Inventor :: Open And Update Drawing From Assembly Via ILogic
Nov 12, 2012The right click context menu on the top level assembly (on the model tree in Inventor) has the option of 'Open Drawing'.
Is there a way to do that via iLogic? Unfortunately I can't figure it out if there is. I would like to open and update the relevant drawing.
Also have tried it the other way around, that is to run my rues in the assembly from the drawing since the drawing is the parent. But I am not sure how to reference the assembly.
AutoCAD Inventor :: ILogic To Close / Hide Open Form
May 23, 2013I'm wondering if there is a way to either close or hide an open form with iLogic? Something like the opposite of iLogicForm.Show.
View 2 Replies View RelatedAutoCAD Inventor :: ILOGIC Form Stays Open After Document Closes?
Jul 11, 2012I have an assembly with a dozen or so rules and a form in it.
After selections have been made on the form, one of the rules saves the assembly as a new assembly (save as).
This closes the first assembly and opens the "saved as" assembly, BUT the form from the first assembly stays open.
It appears the first assembly gets closed so quickly the form does not close also.
I can just hit "done" button on the form to close it in new assembly, but would rather the form close automatically.
Is there code that I can add to close the form ??
AutoCAD Inventor :: Unable To Open Or Communicate With Excel And ILogic (2013)
Nov 20, 2012I'm unable to open or otherwise query an Excel spreadsheet.
I get the following error message. see attached.
What steps must I take to open and query Excel spreadsheets?
I'm using Inventor 2013, Excel 2007 and Vista 64.
Inventor 2012
AutoCAD 2012
Product Design Suite Ultimate 2012, 2013 & 2014
