I've googled w/out any luck... does anyone know if there is a way to detect
what a user's default Text to Column delimiters are and restore them at the
end of the macro?

If I cannot restore the user's previous setting, is there a way to at least
restore whatever the default was out of the box?

As is, my user will be frustrated because he uses Text to Columns daily & my
macro, which uses this also, messes up his settings.

Thanks in advance!

I don't think you can know what the existing settings were.

But you could do a dummy data|text to columns and set it to anything you like
(comma delimited?).

I'd record a macro when I put some junk in an empty cell,
did that dummy data|text to columns
and then cleared the cell

And you could add that code to your procedure.

GettingThere wrote:

I've googled w/out any luck... does anyone know if there is a way to detect
what a user's default Text to Column delimiters are and restore them at the
end of the macro?

If I cannot restore the user's previous setting, is there a way to at least
restore whatever the default was out of the box?

As is, my user will be frustrated because he uses Text to Columns daily & my
macro, which uses this also, messes up his settings.

Thanks in advance!

--

Dave Peterson

I'll take your advice. Thanks for replying & have a great day!

"Dave Peterson" wrote:

I don't think you can know what the existing settings were.

But you could do a dummy data|text to columns and set it to anything you like
(comma delimited?).

I'd record a macro when I put some junk in an empty cell,
did that dummy data|text to columns
and then cleared the cell

And you could add that code to your procedure.

GettingThere wrote:

I've googled w/out any luck... does anyone know if there is a way to detect
what a user's default Text to Column delimiters are and restore them at the
end of the macro?

If I cannot restore the user's previous setting, is there a way to at least
restore whatever the default was out of the box?

As is, my user will be frustrated because he uses Text to Columns daily & my
macro, which uses this also, messes up his settings.

Thanks in advance!

--

Dave Peterson