GETTING USER PARAMETERS TO UPDATE

[blazeoctane03]

I HAD MY EXCEL SPREADSHEET LINKED TO ALL MY PARTS AND ASSEMBLY AND CONSTRAINTS. I THEN HAD TO CHANGE THE ORDER OF MY EXCEL SHEET AND DID NOT NEED SOME OF MY DIMENSIONS. SO WHEN I WOULD UPDATE SOME OF MY VARIABLE NAMES WOULD BE COLORED IN YELLOW. (PRESENTLY NO USER PARAMETERS)SO I DELETED MY FOLDER THAT WAS LINKED TO SPREADSHEET. WHAT HAPPENED IS THE VARIABLES I USED AS CONSTRAINTS IN MY ASSEMBLY WERE ADDED TO THE USER PARAMETER LIST. I THEN LINKED MY SPREADSHEET IN THAT I MODIFIED. IT PROMPTED THAT I HAD VARIABLE NAMES THAT WERE ALREADY USED (THE ONES THAT WERE ADDED IN THE USER PARAMETER SECTION). THE ONLY WAY I CAN GET MY OTHER VARIABLES IN IS TO ACCEPT THAT I ALREADY HAVE THOSE VARIABLES IN. SO NOW I HAVE NO YELLOW WARNING AND EVERYTHING IN MY PARAMETERS UPDATES WITH MY SPREADSHEET EXCEPT FOR THE VARIABLES IN THE USER PARAMETERS. HOW DO I GET THE USER PARAMETERS TO UPDATE WITH MY SPREADSHEET? OR HOW DO I CHANGE THE VARIABLES IN MY SPREADSHEET AND THEN UPDATE MY PARAMETERS SO THAT I GET NO YELLOW MESSAGES?? YOU INPUT WILL BE GREATLY APPRECIATED. HOPE THIS WAS NOT TOO CONFUSING.

[Anonymous]

If you can recover a previous version I'd do that
first... it might make it slightly easier.

Ok... now whether you can or can't recover an older
version follow these steps:

Delete the linked spreadsheet again.

Rename each user parameter by adding an X (or some
character to the beginning or end).

Relink the spreadsheet (be sure to tell it the
correct starting cell - a common mistake I make when in a hurry or
frustrated).

Go into each of the NORMAL parameters (NOT the USER
parameters) and edit the formulas to point to the Spreadsheet
parameters. For example, when a formula reads "LengthX / 2 ul" (where
LengthX is the USER parameter variable), change it to "Length / 2
ul" (where Length is the relinked SPREADSHEET parameter).

After you've done that, you should be able to
highlight each USER parameter that is unnecessary and delete it.

Hope that helps, Tim W.

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

"blazeoctane03" <
href="mailto:kirkr@woodmode.com">kirkr@woodmode.com> wrote in message

href="news:f169574.-1@WebX.maYIadrTaRb">news:f169574.-1@WebX.maYIadrTaRb...

I
HAD MY EXCEL SPREADSHEET LINKED TO ALL MY PARTS AND ASSEMBLY AND CONSTRAINTS.
I THEN HAD TO CHANGE THE ORDER OF MY EXCEL SHEET AND DID NOT NEED SOME OF MY
DIMENSIONS. SO WHEN I WOULD UPDATE SOME OF MY VARIABLE NAMES WOULD BE COLORED
IN YELLOW. (PRESENTLY NO USER PARAMETERS)SO I DELETED MY FOLDER THAT WAS
LINKED TO SPREADSHEET. WHAT HAPPENED IS THE VARIABLES I USED AS CONSTRAINTS IN
MY ASSEMBLY WERE ADDED TO THE USER PARAMETER LIST. I THEN LINKED MY
SPREADSHEET IN THAT I MODIFIED. IT PROMPTED THAT I HAD VARIABLE NAMES THAT
WERE ALREADY USED (THE ONES THAT WERE ADDED IN THE USER PARAMETER SECTION).
THE ONLY WAY I CAN GET MY OTHER VARIABLES IN IS TO ACCEPT THAT I ALREADY HAVE
THOSE VARIABLES IN. SO NOW I HAVE NO YELLOW WARNING AND EVERYTHING IN MY
PARAMETERS UPDATES WITH MY SPREADSHEET EXCEPT FOR THE VARIABLES IN THE USER
PARAMETERS. HOW DO I GET THE USER PARAMETERS TO UPDATE WITH MY SPREADSHEET? OR
HOW DO I CHANGE THE VARIABLES IN MY SPREADSHEET AND THEN UPDATE MY PARAMETERS
SO THAT I GET NO YELLOW MESSAGES?? YOU INPUT WILL BE GREATLY APPRECIATED. HOPE
THIS WAS NOT TOO CONFUSING.

[blazeoctane03]

THAT WORKED THANKS ALOT. I TRIED THAT BUT NEVER NOTICED THAT IF YOU CHANGE THE USER PARAMETER IT AUTOMATICALLY UPDATES THE NAME YOU CHOOSE FOR THE CONSTRAINT.

[Anonymous]

Lower case is cool ... really.
~Larry

"blazeoctane03" wrote in message
news:f169574.1@WebX.maYIadrTaRb...
> THAT WORKED THANKS ALOT. I TRIED THAT BUT NEVER NOTICED THAT IF YOU CHANGE
THE USER PARAMETER IT AUTOMATICALLY UPDATES THE NAME YOU CHOOSE FOR THE
CONSTRAINT.

[blazeoctane03]

WELL IN MY LINE OF WORK EVERY THING IS CASE SENSITIVE AND TODAY EVERYTHING IS UPPER CASE. MAYBE TOMORROW WILL BE DIFFERENT.

[Anonymous]

> WELL IN MY LINE OF WORK EVERY THING IS CASE SENSITIVE AND TODAY EVERYTHING IS UPPER CASE. MAYBE TOMORROW WILL BE DIFFERENT.

Posting in uppercase makes a post hard to read and typically, a lot of
people will pass over your message which might mean your question might
go unanswered.




--

Darren J. Young
dyoung@mcwi.com

Autodesk Developer Network

Minnesota CADWorks, Inc.
PO Box 1172
Monticello, Minnesota 55362-1172
(763) 295-4433
http://www.mcwi.com
ftp://ftp.mcwi.com

[Anonymous]

Yep.
~Larry

"Darren J. Young" wrote in message
news:MPG.19464fa9a1d51de09898d2@discussion.autodesk.com...
> > WELL IN MY LINE OF WORK EVERY THING IS CASE SENSITIVE AND TODAY
EVERYTHING IS UPPER CASE. MAYBE TOMORROW WILL BE DIFFERENT.
>
> Posting in uppercase makes a post hard to read and typically, a lot of
> people will pass over your message which might mean your question might
> go unanswered.
>
>
>
>
> --
>
> Darren J. Young
> dyoung@mcwi.com
>
> Autodesk Developer Network
>
> Minnesota CADWorks, Inc.
> PO Box 1172
> Monticello, Minnesota 55362-1172
> (763) 295-4433
> http://www.mcwi.com
> ftp://ftp.mcwi.com