I have a working Text to Columns macro. Everything is okay except my macro
is permanently changing the users text to column delimiter settings. How can
I determine what the delimiter settings are and store them before I change
them?

Thank you for any help you can give me.

MSweetG222

You can't.

You could run your text to columns macro, then do a dummy text to columns, use
delimited and don't specify any delimiter.

This won't reset it back to what the user had, but your original settings won't
be remembered, either.

(It seems safer to me.)

MSweetG222 wrote:

I have a working Text to Columns macro. Everything is okay except my macro
is permanently changing the users text to column delimiter settings. How can
I determine what the delimiter settings are and store them before I change
them?

Thank you for any help you can give me.

MSweetG222

--

Dave Peterson

Dave, thank you for the information.

MSweetG222

========================

"Dave Peterson" wrote:

You can't.

You could run your text to columns macro, then do a dummy text to columns, use
delimited and don't specify any delimiter.

This won't reset it back to what the user had, but your original settings won't
be remembered, either.

(It seems safer to me.)

MSweetG222 wrote:

I have a working Text to Columns macro. Everything is okay except my macro
is permanently changing the users text to column delimiter settings. How can
I determine what the delimiter settings are and store them before I change
them?

Thank you for any help you can give me.

MSweetG222

--

Dave Peterson