View Single Post
 
Old 06-24-2014, 05:34 AM
EC37 EC37 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: May 2014
Location: Waltham, MA
Posts: 56
EC37 is on a distinguished road
Default

OK- so, I have the article you pointed me to and I will read through it. First, of course, I read what you responded with. So here is my questions about the long statement and the continuation character...

When I originally started to see how to perform TextToColumns, I first recorded my actions with record macro. It appeared exactly as you have it above (with the ":="'s and the "_", etc. However, when I copied what the recorded macro provided, and pasted into the code I am building for this export- VBA would get mad at the ":=" and error. If I remember correctly it said something along the lines of 'End statement expected' or something- I don't quite recall.
I've just attempted to recreate that error, and re-ran the macro... and, well, now I feel like an idiot. Because it did exactly what I wanted it to do- and that was perform the TextToColumns as I have wanted it to do all along...... *scratching my head*.

I can only imagine it was mad at me before because I wasn't selecting the data correctly. Damn, had I just plugged that in after I figured out the selection piece (because, the record macro was selecting E2:E264, and I wanted it to select E2 and then End(xlDown). So, that's what was wrong with my statement all along..)
Now, I just need to do that to 2 more columns, and then format all 3 to ddd, mmm dd- which I just did, and that is now all set.

I think the only thing that is left at this point in time is now including Conditional Formatting. Then, my export is officially complete!

Last edited by EC37; 06-24-2014 at 06:01 AM. Reason: thought I was done, but not quite!
Reply With Quote