Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sawilliams

  1. sawilliams

    Set End-of-Range for Autofill in Excel Macro

    Guys: Actually I do import the data into Excel and, yes, I specify the data type to be text for my problematic date-like ID fields. And I never save it as an XLS but keep it as a CSV. Still, even after taking that precaution, when I link the CSV in Access (as a linked table), some of the...
  2. sawilliams

    Set End-of-Range for Autofill in Excel Macro

    Thanks for the tips. So, the loop suggestion sounds much smarter than my lengthy code. The file that I'm presently opening in Excel is a CSV that I run my macros against and it remains a CSV when I'm done. One of my databases has customer numbers that appear to be dates like 02-06-2312 and...
  3. sawilliams

    Set End-of-Range for Autofill in Excel Macro

    Wow, thanks Skip. Excellent!
  4. sawilliams

    Set End-of-Range for Autofill in Excel Macro

    Hello. I'm back. I'm not sure why, but I'm not getting notifications that there are replies to this thread. I checked my settings and it appears that I should get emails but nothing is coming thru. So, I apologize for not commenting sooner on the last remarks. So, one of my Excel macro has...
  5. sawilliams

    Set End-of-Range for Autofill in Excel Macro

    Yep, it is a *.csv. And I get out whatever our customers enter in. There is no functionality to fix the output before it becomes a *.csv. I need to standardize addresses to compare to existing records in our CRM to de-dupe and update or add new customer records. Right now, it's all done via...
  6. sawilliams

    Set End-of-Range for Autofill in Excel Macro

    Great tips. Thanks, guys. What I'm doing is correcting the output from a messy online contribution site. When entering their name and address, the donors enter all manner of bad abbreviations and iMpRoper cASE and I need my users to be able to rapidly update 1) mixed case to Proper or Title...
  7. sawilliams

    Set End-of-Range for Autofill in Excel Macro

    Gavona! Great tip. Thanks for the help. I modified just the last line from: rDestination.Value = rDestination.Value 'convert all but first row to values to: rDestination.NumberFormat = "@" to change the format to "text" because what I am doing is fixing zip codes that are exported from an...
  8. sawilliams

    Set End-of-Range for Autofill in Excel Macro

    Hello. I'm back again. And I'm a "him" (Steve). I have a subsequent question (you may have created a monster). I have entered a formula in the first cell of a column and I want to autofill that formula to the last row of data. But again, I want this to be a macro because I will reapply it to...
  9. sawilliams

    Set End-of-Range for Autofill in Excel Macro

    Andrzejek! I AM having fun. Your InputBox is great. I'm learning a lot. And I see why the TRIM wasn't working -- closing parenthesis in the wrong spot. Thanks again!
  10. sawilliams

    Set End-of-Range for Autofill in Excel Macro

    Guys, I have a follow-up question. Can I modify the code you supplied to apply to ANY column I select? I will want to change many different columns to Proper Case.
  11. sawilliams

    Set End-of-Range for Autofill in Excel Macro

    Thanks, Andrzejek! Sorry I posted in the wrong place. I wasn't thinking of it in terms of VBA but more using some special keystoke(s) while recording the Macro to do what you cleverly did in the Do While . But your answer is great. I will be able to use this solution in a number of places...
  12. sawilliams

    Set End-of-Range for Autofill in Excel Macro

    I get data output from an online application. Basically it’s name and address. Since the data is being entered by the general public, there are no standards as far as using Proper Case or Title Case in any of the fields especially the Address Field. I get the data in Excel and I fix it using...
  13. sawilliams

    Funky formatting in phone numbers

    Skip & jsteph: Sorry, I dropped off this string -- dragged into another project. And not exactly joy in Mudville but I'm plowing my way thru the data all over again. But your words of advice were greatly appreciated. SAW
  14. sawilliams

    Funky formatting in phone numbers

    Skip: Yep, I'm back to square one. And, as I mentioned, if I save the spreadsheet as *.txt the formatting all goes away. I did not create the original spreadsheets and there are 5 altogether from different sources, so who knows how they were originally formatted. But thanks for your help. I...
  15. sawilliams

    Funky formatting in phone numbers

    Skip: Nifty, but when I did as you suggested, the resulting number was not the original phone number in the original spreadsheet. For example, in ny original worksheet, the phone number appears as "3479631029" turns into "3.47963e+009" in my Access db and when I do the paste special I get...

Part and Inventory Search

Back
Top