convert csv to excel

  1. J

    Bulk Convert CSV to XLSX Files While Retaining the Leading Zero

    Hello everyone, I was wondering if it is possible to bulk convert CSV to XLSX files while retaining the leading zero? I am currently using a similar code shared by user John_w, and I added an additional line where I convert all of the columns to "TEXT". However, I have noticed that the Macro...
  2. L

    Convert to CSV VBA code is skipping files in selected folder

    Hello, I have the following code, which runs correctly, however, it is skipping every other file in my directory. There are 66 files and it ends up converting 34 (1 file has 2 sheets that are converted as separate csv's). Does anyone know why it would be doing that? Sub SaveToCSVs() Dim...
    • leglenn
    • Thread
    • convert csv to excel dim full directory skips files vba
    • Replies: 6
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top