Store Variable with Exported Worksheet

[Stratuser]

I'd like to store a value with an exported data worksheet, but I don't want
to put the value in a cell. I just want the number to ride along with the
data worksheet, because I'm going to use the number later when I reimport the
data worksheet back into the program. The number is a value that comes from
a named range in the program that will export the data worksheet. Once I
export the data worksheet, the value that goes with it will not change.

How should I do this?

[Tom Ogilvy]

assuming by exported data worksheet you mean an .xls file. Then created a
sheet level defined name and assign it the value (in you exported
worksheet). This is the same as you named range, but instead of refering to
a range, refer to a value.

If your exported worksheet will not be an xls file, then what will it be?

--
Regards,
Tom Ogilvy

"Stratuser" <[email protected]> wrote in message
news:[email protected]...
> I'd like to store a value with an exported data worksheet, but I don't
want
> to put the value in a cell. I just want the number to ride along with the
> data worksheet, because I'm going to use the number later when I reimport
the
> data worksheet back into the program. The number is a value that comes
from
> a named range in the program that will export the data worksheet. Once I
> export the data worksheet, the value that goes with it will not change.
>
> How should I do this?

[Stratuser]

Yes, the exported worksheet will be an xls file. Thanks for your help.

"Tom Ogilvy" wrote:

> assuming by exported data worksheet you mean an .xls file. Then created a
> sheet level defined name and assign it the value (in you exported
> worksheet). This is the same as you named range, but instead of refering to
> a range, refer to a value.
>
> If your exported worksheet will not be an xls file, then what will it be?
>
> --
> Regards,
> Tom Ogilvy
>
> "Stratuser" <[email protected]> wrote in message
> news:[email protected]...
> > I'd like to store a value with an exported data worksheet, but I don't
> want
> > to put the value in a cell. I just want the number to ride along with the
> > data worksheet, because I'm going to use the number later when I reimport
> the
> > data worksheet back into the program. The number is a value that comes
> from
> > a named range in the program that will export the data worksheet. Once I
> > export the data worksheet, the value that goes with it will not change.
> >
> > How should I do this?
>
>
>