Spread sheet linking

[Anonymous]

I am trying to link a spread sheet to my parameter list. It is for a
involute approximation of a spline.
It is only the first sheet of a workbook that gets linked to inventor?
How do you copy data from the 2nd sheet in excell to the first sheet. I am
hoping that will work.
Ole

[Anonymous]

Thanks for the help. I got everything on one page. It would have helped if
I could have two pages.
Does Inventor ignore the second pages?
Ole
"Ole Germer" wrote in message
news:50FD153451E5D7CBB0E378B218D63788@in.WebX.maYIadrTaRb...
> I am trying to link a spread sheet to my parameter list. It is for a
> involute approximation of a spline.
> It is only the first sheet of a workbook that gets linked to inventor?
> How do you copy data from the 2nd sheet in excell to the first sheet. I
am
> hoping that will work.
> Ole
>
>

[Anonymous]

Ole,

If you try to do the same thing manually in Inventor, you will see that
there is no way to specify which page (sheet) you want to use from the excel
file. Personnaly, I would no expect the API to do more than the app
itself...

However, you could probably use a trick in VB (e.g.: read the excel file
once, delete or move the first sheet and read the file again).

If you need help, I can try to give you a hand.

Marina

"Ole Germer" a écrit dans le message news:
97BB3D51F8FA0CE1E92F0FF7959CCD52@in.WebX.maYIadrTaRb...
> Thanks for the help. I got everything on one page. It would have helped
if
> I could have two pages.
> Does Inventor ignore the second pages?
> Ole
> "Ole Germer" wrote in message
> news:50FD153451E5D7CBB0E378B218D63788@in.WebX.maYIadrTaRb...
> > I am trying to link a spread sheet to my parameter list. It is for a
> > involute approximation of a spline.
> > It is only the first sheet of a workbook that gets linked to inventor?
> > How do you copy data from the 2nd sheet in excell to the first sheet. I
> am
> > hoping that will work.
> > Ole
> >
> >
>
>

[Anonymous]

Mr. M&X,
I did the whole thing in one excell sheet. I did post it to Streamline. I
am now working on 3 sheets version I am afraid my model fails when the base
line diameter( where the involute starts) goes below the root diameter.
Hopefully I will be finished soon. I would very much like to do it in vba
but will need help.
Ole

"M&X" wrote in message
news:63EC40DE60AD3E43391552B5F376F4B2@in.WebX.maYIadrTaRb...
> Ole,
>
> If you try to do the same thing manually in Inventor, you will see that
> there is no way to specify which page (sheet) you want to use from the
excel
> file. Personnaly, I would no expect the API to do more than the app
> itself...
>
> However, you could probably use a trick in VB (e.g.: read the excel file
> once, delete or move the first sheet and read the file again).
>
> If you need help, I can try to give you a hand.
>
> Marina
>
> "Ole Germer" a écrit dans le message news:
> 97BB3D51F8FA0CE1E92F0FF7959CCD52@in.WebX.maYIadrTaRb...
> > Thanks for the help. I got everything on one page. It would have
helped
> if
> > I could have two pages.
> > Does Inventor ignore the second pages?
> > Ole
> > "Ole Germer" wrote in message
> > news:50FD153451E5D7CBB0E378B218D63788@in.WebX.maYIadrTaRb...
> > > I am trying to link a spread sheet to my parameter list. It is for a
> > > involute approximation of a spline.
> > > It is only the first sheet of a workbook that gets linked to inventor?
> > > How do you copy data from the 2nd sheet in excell to the first sheet.
I
> > am
> > > hoping that will work.
> > > Ole
> > >
> > >
> >
> >
>
>