Hi All,

I'm a new user of Inventor - and an even newer user of iLogic / VB

Just wondered if anybody had any snippets to help me export a hole table in a drawing please? (to a text file)

I've managed to find the bits and pieces of VB code through the advanced programming help in Inventor, but I am failing in putting it all together!!

Any help would be really appreciated!

Many Thanks,

Tom

Tom,

You can begin with this code :

_________________
Christophe S....t
Dev. App. Eng.

Thanks nomutt! Works perfectly!

I wasn't far off with my code! I didn't include the oSheet.HoleTables and i missed the Item(1) in the Export!

Thanks for you help!

Tom

I descided that the hole table needs to be created from the assembly and outputed to excel. There it will be sorted and re-read by inventor. My Vb code so far for sorting the excel sheet is:

Public Sub excelopensorttest()

'Code for running excel macro in vbs


Dim xlApp
Set xlApp = CreateObject("excel.application")

Dim xlWkb
Set xlWkb = xlApp.Workbooks

Dim xlWkbs
Set xlWkbs = xlWkb.Open("z:\test1.xlsm")

Dim xlWkbsa As Workbook
Set xlWkbsa = xlWkbs


xlApp.Visible = False


Range("A1:B500").Select
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

xlWkbsa.Save
xlWkbsa.Close
xlApp.Quit

Set xlWkbsa = Nothing
Set xlWkbs = Nothing
Set xlWkb = Nothing
Set xlApp = Nothing


End Sub


It leaves an instance of excel open and I cant workout why? Does anyone have any ideas?