Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #34  
Old 06-24-2014, 05:34 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

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
 



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 06:08 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