Posted to microsoft.public.excel.programming

J@Y

external usenet poster

Posts: 127

TextToColumns Method: How to use xlFixedWidth?

I am trying to simulate what I do manually with the Text to Column function
in Datas menu. Basically I have a range select, I go to T to C function, I
chose FixedWidth, then but 2 separators at 30 and 60. How would I do that
using the TextToColumns in VB?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What does TrailingMinusNumbers do in the TextToColumns Method	Lennard van Putten	Charts and Charting in Excel	3	August 5th 05 11:59 PM
TextToColumns Method - Delimited by Double Spaces	Alan	Excel Programming	4	August 3rd 05 04:28 AM
Q TextToColumns	Simon Woods[_3_]	Excel Programming	1	May 21st 04 12:29 PM
texttocolumns	Doug Broad[_4_]	Excel Programming	4	April 21st 04 02:50 AM
How to use Opentext method with xlFixedWidth?	Together[_8_]	Excel Programming	2	March 3rd 04 03:27 PM

All times are GMT +1. The time now is 01:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us