.csv files

  1. B

    Deleting unused cells in excel

    Hi everyone, I tried to delete the unused cells , But couldnt find a option & tried to hide all the cells & it worked but . i want this to be saved in .csv file. After saving the same on .cvs file , the hidden cells are visible . My query is there any option to hide or delete unused cells...
  2. S

    Facing "out of memory" issue while importing data from a .csv file to create Pivot Cache

    Hi All, I need a help on this issue which we are facing. We are trying to create pivot cache from an external .csv file. This works fine when the csv file is small (<500 mb). But it given "out of memory" error for bigger .csv files(>~500 mb). Attaching sample code for reference - Dim...
  3. F

    VBA - Open .csv file from open folder

    Hey guys, This is my first time posting in the forums, so I hope I'm in the right place. I'm writing this program using VBA in Excel 2007 and am somewhat experienced in VBA. I'm trying to give the user of the program an option to browse a folder, select the excel file that they want to open...
  4. R

    macro to select file for import.

    Hello Excel Experts. I have sheet4 of my workbook designated as the destination for imported .CSV files. The files data is pre-formated to fit into columns A & G. The rest of the sheets in the workbook read and pull the data from there. I have no trouble manually selecting the needed file and...

Watch MrExcel Video

This Week's Hot Topics

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
Top