Text to Columns - Saving User Settings

  • Thread starter Thread starter MSweetG222
  • Start date Start date
M

MSweetG222

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.)
 
Dave, thank you for the information.

MSweetG222

========================
 
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

Restore users Text to Columns settings -HELP! 2
Export data to Text file without leaving worksheet. 1
Fixed width parsing with trailing minus 4
Insert character in a cell using a keyboard shortcut 10
Text to columns 2
Save As xls to text (tab delimited) in encoding utf-8 0
Macro delimiting text if column has value 3
Text to Column with fixed width in VBA 1

Back
Top