csv export vba

  1. G

    How to Copy and paste visible cells (FILTERED TABLE CELLS) to a CSV

    I want to copy and paste from one excel to another using copy and paste visible cells only as I have a filtered table between a set range. I'd like to do this through save CSV but this does not possible thus far. The code below works but it doesn't seem to copy paste visible cells/filtered...
  2. G

    Save as CSV (modifying SAVE.AS)

    I have the following formula. It works for saving as a new workbook. How can I get it to work for saving as CSV? I have tried adding ".csv", FileFormat:=xlCSV to it but no such luck thus far. Cheers :) ActiveWorkbook.SaveAs Filename:="C:\User\Test.CSV" & Test1Str & " " & TestStr & " "...
  3. K

    Copy data from different csv files into one sheet

    Found the below code to be working, but have two constrains. Each rows from the source file is copied in the last empty column. The string is gets pasted with double quotes. Sub ImportCSV() <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida...
  4. M

    Problem creating CSV File

    Hi all, I am new to VBA and I am stuck in this issue for the last 2 days :( Please suggest me some solution. I am trying to create csv file from excel file. The file gets created but all the columns merge into just one column. :( i.e its not comma separated. The piece of code I am using for...
  5. V

    Intersection of rows in excel through vba or direct kind help and duplicate permuted rows from csv

    I have a csv with n columns in it and it has say 500k rows. Now kind help with a way in excel for possible ways to pick n+1 rows such that intersection between any two rows is exactly one record in the entire row and all elements in n+1 rows together have each record in the row exactly only...
  6. M

    Export CSV into UTF-8 Format

    Hello, I'm using code to generate individual CSV files for each worksheet of a single workbook. However, these individual CSV files that are generated need to be within UTF-8 format. Could someone assist me with modifying this code for those purposes? I greatly appreciate it! Thanks! Sub...
  7. concreteinterface

    Adding data to a CSV file troubleshoot

    I have been over this a few times and can't figure it out. I have used this code a few times in the same project and it does work with similar setups. For some reason this sub is not working. Any suggestions? Sub AddCompany() Call Definitions.Definitions Dim My_filenumber As Integer Dim...

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