when control are pasted in a sheet, for example
(EMBED("Forms.HTML:Text.1",""), excel numbers them, control x.

once these are deleted, is there any way to reset that numbering system so
subsequent pastes do not start at 1 + the last pasted control number?

i know exiting excel resets it, just wondering if there is a way to do it
programmatically.

--

Gary Keramidas
Excel 2003

One work around is to name them with consecutive numbers. But it seems like
there is a way to reset the index numbers also. I am sure there is on a
form, and I would think you could do it on a sheet also.


"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
when control are pasted in a sheet, for example
(EMBED("Forms.HTML:Text.1",""), excel numbers them, control x.

once these are deleted, is there any way to reset that numbering system so
subsequent pastes do not start at 1 + the last pasted control number?

i know exiting excel resets it, just wondering if there is a way to do it
programmatically.

--

Gary Keramidas
Excel 2003

thanks, but i don't get to name them, they get pasted from a browser window.
control 8 is always an embedded filed i need, but the next time the user
pastes from the browser, there is no control 8, as it starts number from the
last control that was pasted.

i have absolutely no control over this, it's some old unix system that works
through a browser window and i'm just trying to help the person out with
capturing some data. they know it needs to get replaced, but who knows when
they'll do it.

--

Gary Keramidas
Excel 2003


"JLGWhiz" wrote in message
...
One work around is to name them with consecutive numbers. But it seems
like there is a way to reset the index numbers also. I am sure there is
on a form, and I would think you could do it on a sheet also.


"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
when control are pasted in a sheet, for example
(EMBED("Forms.HTML:Text.1",""), excel numbers them, control x.

once these are deleted, is there any way to reset that numbering system
so subsequent pastes do not start at 1 + the last pasted control number?

i know exiting excel resets it, just wondering if there is a way to do it
programmatically.

--

Gary Keramidas
Excel 2003

Is there a way to capture the last control number and use a variable that
represents the next number instead of the control #8? Or is it closed code
that you can't modify?


"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
thanks, but i don't get to name them, they get pasted from a browser
window. control 8 is always an embedded filed i need, but the next time
the user pastes from the browser, there is no control 8, as it starts
number from the last control that was pasted.

i have absolutely no control over this, it's some old unix system that
works through a browser window and i'm just trying to help the person out
with capturing some data. they know it needs to get replaced, but who
knows when they'll do it.

--

Gary Keramidas
Excel 2003


"JLGWhiz" wrote in message
...
One work around is to name them with consecutive numbers. But it seems
like there is a way to reset the index numbers also. I am sure there is
on a form, and I would think you could do it on a sheet also.


"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
when control are pasted in a sheet, for example
(EMBED("Forms.HTML:Text.1",""), excel numbers them, control x.

once these are deleted, is there any way to reset that numbering system
so subsequent pastes do not start at 1 + the last pasted control number?

i know exiting excel resets it, just wondering if there is a way to do
it programmatically.

--

Gary Keramidas
Excel 2003

not sure, they'll just have to exit excel and restart it.

thanks for the response.

--

Gary Keramidas
Excel 2003


"JLGWhiz" wrote in message
...
Is there a way to capture the last control number and use a variable that
represents the next number instead of the control #8? Or is it closed
code that you can't modify?


"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
thanks, but i don't get to name them, they get pasted from a browser
window. control 8 is always an embedded filed i need, but the next time
the user pastes from the browser, there is no control 8, as it starts
number from the last control that was pasted.

i have absolutely no control over this, it's some old unix system that
works through a browser window and i'm just trying to help the person out
with capturing some data. they know it needs to get replaced, but who
knows when they'll do it.

--

Gary Keramidas
Excel 2003


"JLGWhiz" wrote in message
...
One work around is to name them with consecutive numbers. But it seems
like there is a way to reset the index numbers also. I am sure there is
on a form, and I would think you could do it on a sheet also.


"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
when control are pasted in a sheet, for example
(EMBED("Forms.HTML:Text.1",""), excel numbers them, control x.

once these are deleted, is there any way to reset that numbering system
so subsequent pastes do not start at 1 + the last pasted control
number?

i know exiting excel resets it, just wondering if there is a way to do
it programmatically.

--

Gary Keramidas
Excel 2003

There is no way to reset the object identifier that automatically gets
incremented and appended to newly added objects, at least not while any
objects exist on the sheet.

Rename controls perhaps.

Regards,
Peter T


"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
when control are pasted in a sheet, for example
(EMBED("Forms.HTML:Text.1",""), excel numbers them, control x.

once these are deleted, is there any way to reset that numbering system so
subsequent pastes do not start at 1 + the last pasted control number?

i know exiting excel resets it, just wondering if there is a way to do it
programmatically.

--

Gary Keramidas
Excel 2003

thanks peter, that's what i did last night. i'm about to go try it out.

--

Gary Keramidas
Excel 2003


"Peter T" <peter_t@discussions wrote in message
...
There is no way to reset the object identifier that automatically gets
incremented and appended to newly added objects, at least not while any
objects exist on the sheet.

Rename controls perhaps.

Regards,
Peter T


"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
when control are pasted in a sheet, for example
(EMBED("Forms.HTML:Text.1",""), excel numbers them, control x.

once these are deleted, is there any way to reset that numbering system
so subsequent pastes do not start at 1 + the last pasted control number?

i know exiting excel resets it, just wondering if there is a way to do it
programmatically.

--

Gary Keramidas
Excel 2003