Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #32  
Old 06-23-2014, 11:49 AM
EC37 EC37 is offline NEWB to Macros - formatting exports Windows 7 64bit NEWB to Macros - formatting exports Office 2010 64bit
Advanced Beginner
NEWB to Macros - formatting exports
 
Join Date: May 2014
Location: Waltham, MA
Posts: 56
EC37 is on a distinguished road
Default

*Note: I wish I cold delete previous posts so you don't waste your time responding to them. I am here for 8hrs each day, so I tend to fiddle with things throughout the day. I managed to Group the Phases successfully. I'll try to figure out if I can delete, in which case, if you don't see any posts preceding this one, then I figured that out too!

Now, I'm sorry, but I can't give up on this whole 'TextToColumns' piece.. it actually kind of gives me something to do while awaiting responses

I did a lot of googling today, and at least managed to select the range of E2 End(xlDown)- so that much I have figured out! I even found out what Array 0, 9 and 3, 3 means. That it will skip the first column, and format the second to the date format of MDY (9= xlSkipColumn, 3 = xlMDYFormat ). But what i can't quite understand is why it won't actually do the task of splitting the data out. I feel like I will eventually figure it out for myself, but at the same time, whatever I return in my google searches, I'm never quite sure I'm looking at the right thing haha.

Now my code appears as:

Range("E2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.TextToColumns
Destination = Range("E2")
DataType = xlFixedWidth
FieldInfo = Array(Array(0, 9), Array(3, 3))

My last thought to this is: is "TextToColumns" a FUNCTION? and perhaps if I identify it as such, it will actually perform the task?
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting contents after Tab of continuous lines or formatting specific area of word pawii Word 1 05-12-2014 05:24 AM
macros stebrownsword Word VBA 0 08-28-2013 01:16 AM
NEWB to Macros - formatting exports How to do Formatting Using Macros anju16saini Word VBA 1 03-11-2013 04:15 AM
NEWB to Macros - formatting exports Formatting with macros WaltR Word VBA 8 05-15-2012 06:28 PM
Macros nore Outlook 0 06-01-2011 04:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft