Inventor General

Reply
*Keller, Kent
Message 1 of 1 (30 Views)

iPart ..... Network connection may have been lost

30 Views, 0 Replies
11-11-2002 07:10 AM
Tom McNeil at Autodesk has informed me of a issue that shows up on some of the iParts off
my Web site. I have not had a chance to check them all, but there are a few that have a
VBA macro in the iPart Excel table. The Macros were simple little snips of code that I
used when building the table. They should have had no affect on the part, but it appears
there is some sort of problem (if I understand correctly the problem is with OLE more-so
than anything with Inventor)

At this point I have only had time to go through a few of the parts on my site to check
them out. Consequently I have removed the iPart page until I can make sure all will be
OK.

As I understand it if you had downloaded one of the iParts with VBA in the Excel file and
been using it you would have seen the problem. It would be something along the lines of a
error message saying "Network connection may have been lost". "Not enough storage is
available to complete this operation. OK."

If you are getting any errors like that when placing iParts you can take these steps to
clean the file.

1. Open the file in question.

2. Select the iPart table, right mouse menu, select "Delete"

You will be prompted to verify that you want the iPart turned into a normal part, select
'yes'

The previously hidden embedded file is now visible under the 3rdParty folder.

By turning this table into a normal 3rdParty item, you will bypass table code that is used
to determine if the table is clean, healthy, and well structured.

This is extra layer of code was preventing us from editing Excel, since it would open and
then close Excel.

3. Select this new embedded item, right mouse menu, select 'Edit'

Excel should start and be visible in it's own window.

4. Scroll down to the bottom of the iPart table.

5. Several rows *AFTER* the last iPart row, add a value into an empty cell.

It is necessary for Excel to really think it is dirty and needs to save, and this simple
edit should accomplish that.

I am going to add to Toms notes to Press Alt F11 and double click on each of the Sheets
and "ThisWorkbook" in the Project browser window and if you see any text in any of the
pages then delete it. Close the window, and follow the rest of the steps.

6. Save and close Excel.

When Excel saves, it "migrates" it's data.

7. Back in Inventor, undo back over the Table 'Delete' so that the table reappears

Edits directly to the excel data as not part of Inventor's transacted data, so the edits
will not get undo

8. (optional) You can now removed the "bogus" cell data that was added in step #4 using
"Edit via Spreadsheet" on the iPart Table.

I will be fixing the parts from the site as time permits. I plan on also doing a little
bit of cleanup work on the tables so it may take some time. When I put them back up I will
post a list of the ones I found to have VBA in the Excel table so you won't have to
download any that didn't have problems.


I sincerely apologize for the inconvenience.

--
Kent
Member of the Autodesk Discussion Forum Moderator Program

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community


Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor

Twitter

Facebook

Blogs

Pinterest

Youtube