Excel to CSV specific columns only using VBA

  • I have an Excel spreadsheet that has multiple columns (A-G) with information in rows 1-26. I am trying to use a VBA script to convert only columns A and D to the CSV file to columns A and B. I have been able to convert columns A and D and A is in the correct position (column A, rows 1-26), but column D ends up in column D and rows 27-52. What am I missing to move column D in excel to column B in the CSV? Any help would be greatly appreciated!!! See my current code below:


  • Re: Excel to CSV specific columns only using VBA


    Hi acbernier,
    Try..

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!