Restore users Text to Columns settings -HELP!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to Columns - Saving User Settings 2
Advice on multiple macros, same code just a different column 9
Change macro button text when macro is invoked. 2
Macro delimiting text if column has value 3
Save & Restore a column 4
Export data to Text file without leaving worksheet. 1
Text to Columns 3
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7

Back
Top