export as csv

  1. F

    Outlook calendar export VBA with range period

    Hello guys, I am trying to modify a code that I found in order to export my calendar appointments in Excel. I need to export "Subject", "StartDate", "EndDate" and "Category". The main issue is that I want on a specific period of time by an Input Box, first to enter the start date and then the...
  2. B

    Export to csv using Named Range

    Hello! I am trying to export 5 columns of data. The rows change each time the data is refreshed. I have a named range of "EquipCosts" for the data. Using the below code, exports, but it give me quotes and commas for the blank rows. Is it possible to export to a csv using a named range? If not...
  3. J

    Export Email Data to specific fields in CSV file (or XLS file)

    Hello All! I am working on a problem where I need to... 1. Receive an email 2. Have that email automatically moved to a specific folder 3. Have any email in said folder exported into a .csv file 4. The data in that file must be placed under specific columns. I can achieve all of the above...
  4. J

    How can I export the text of one column of a workbook as text file and perform the saving with a macro

    I have a sheet with several workbooks. The aim of the sheet is to generate a text of a letter automatically depending on a lot of parameters. In one of the workbooks I have the result in column A. lets call this workbook corrections The content of the cells in letter_text might be in English...
  5. M

    Export table from power pivot or power BI

    I am making a database to run some regressions on Eviews. So once I'm done with the table, I have to export that table to Eviews or any other statistical software. But I'm not sure how to export a table or tables from data model. If I cannot do that, then no point in spending time in the power...
  6. E

    Divide and export the data according to these instructions

    Hi MrExcel Community, my name is Dominika and I'm looking for a VBA code help. I need to automate some of my Excel work for the sake of completing my dissertation on time, but I'm new to VBA. I have data that have following columns: year quarter code number1 number2 The data are properly sorted...
  7. S

    How to import/export multicell namedranges and their values ?

    I have an excel file which has around 373 NamedRanges and their values. Some ranges are singlecell others are around multicelled value. Now I am trying to first export the Names of the NamedRanges all of them which are present in the workbook and their values in csv format. Then I am using...
  8. B

    how to export multiple individual sheets to .CSV files?

    I'm working in xl2010, and have a workbook with ~70 sheets. I'd like to save the sheets as individual .csvs, each with the name of the sheet. I tried using the following code: Option Explicit Sub SaveShtsAsBook() Dim Sheet As Worksheet, SheetName$, MyFilePath$, N& MyFilePath$ =...
  9. A

    Code to save new user excel file as CSV where the headers are in a column not row

    good afternoon. I am trying to create a macro that will take the contents of an excel file that had new user details and save it as a csv. The Headers are in column B - B11:B44 with the data in D11:D44. Being the information is running vertically rather than horizontally I am having issues in...
  10. Q

    CSV Export

    I have an excel sheets which contain information which will be exported via CSV in Excel and later be imported via CSV into a mysql database. The problem is that some columns in the excel can contain quite a few common delimiters such as commas, apostrophes for text fields, along with single...
  11. E

    Export Specific Columns To Txt File

    Hi guys, I have developed a piece of code that exports my entire worksheet to a .txt file. Rather than exporting the entire sheet, all i am looking to achieve is export Column A, B and J. Here's my current code: Sub csvfile() Dim fs As Object, a As Object, i As Integer, s As String...
  12. D

    Exporting to CSV based on column/cell location.

    I have a bit of a tricky problem. Hopefully someone can help me because this one has me a little stumped. I'm pretty new to Access and VBA for Access is not the same animal I know from other Office apps. After exporting to Excel and running a module to remove the unnecessary data (which I...
  13. J

    Export to CSV with a Variable Amount of Columns

    I have been searching for quite a while now for an answer to this problem with no success. This forum seems like the best place to find an answer. I'm looking for a macro to take the following input and export it to a csv file to look like what I have listed. INPUT----- 5 5 5 5 5 5 5 5 5 5 5...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top