All Questions
Tagged with export-to-csv vba
104
questions
0
votes
1
answer
55
views
Export sheet in a workbook to CSV file in the same location every week
I have a sheet in a workbook I would like to export to a csv file that gets updated every week.
So ideally, I want the VBA code to export whatever data is in the sheet and overwrite what was existing ...
0
votes
2
answers
100
views
Why is this VBA script corrupting files?
I've created a VBA script to save an xlsx file as a semi-colon-del CSV format, but unfortunately, it's corrupting the output/CSV file when it saves (in notebook I see only PK ). Can anyone give me ...
1
vote
1
answer
41
views
Generating a CSV from Excel VBA with cleardown function
I've got a VBA script in Excel to extract a list of values from Table1 Column 1 (Literally just a list of Laboratory numbers and can be any number of rows, usually no more than 30) and drop it into a ...
0
votes
1
answer
133
views
Export only Rows with Data from CSV
I created a macro to export a CSV. The issue I am running into is that it is exporting everything, even the blank cells.
Columns A/B are required fields. If there is no data in Columns A/B then that ...
1
vote
1
answer
566
views
Export Data from Excel Spreadsheet to CSV
Code from VBA Macro to Export Data from Excel Spreadsheet to CSV will save a copy of the current sheet as an archive file in .CSV format. I assigned it to a button. Whatever sheet the button is on, it ...
0
votes
1
answer
42
views
Deleting top row of every sheet on a copied workbook
I'm saving a closed workbook in individual sheets as .csv files for opening in minitab. The code to save each individual sheet as .csv works great. The issue is I also need to delete the top row of ...
1
vote
1
answer
45
views
Trying to get my VBA script to export specific sheets to csv from an array but continue to get Run Time 1004 on the thirdsheet
I have been working on my code to get the system to export specific sheet based only on what is visible in the system yet, for some reason I continue to struggle when it is trying to run the export ...
0
votes
1
answer
183
views
MS Access export query with DateTime extended field to csv results empty date column
I have a table migrated to SQL Server. The DateTime column data type on Access is DateTime extended while in SQL Server is DateTime not DateTime2.
I run VBA code to export a query containing that ...
0
votes
1
answer
340
views
Export to .csv - How to deal with non-visible quotation marks?
i'm trying to make some excel form using VBA Userform, to help our analitycs crete valid .csv files, which is currently use to add data to database. What's necessary - there should be only semicolons ...
1
vote
2
answers
738
views
VBA to export selected row values of excel to csv
I have a requirement for VBA, wherein, If I select a cell in excel, it will export that entire row values to csv.
I have tried
Sub WriteCSVFile()
Dim My_filenumber As Integer
Dim logSTR As String
...
-1
votes
1
answer
127
views
Insert 8 lines at the top with specified values into CSV file using VBA
I have csv file which contains numbers and symbols in columns. I am exporting it into Access DB using VBA. The problem is that Access automatically trying to detect data type based on first 8 rows and ...
1
vote
0
answers
59
views
Macro used to convert .xls to .csv - Problem with where the converted file saved
The following micro is being use to convert an excel spreadsheet to a .csv file. My issue is that the converted .csv file (named final.csv) was saved in the folder that the original source file came ...
0
votes
1
answer
65
views
Copy an Excel sheet into a new Semicolon seperated CSV
so I have one big Excel sheet (.xlsm) from which I want to get 3 new CSV files.
I already tried something like that below, but this seperates with normal commas:
Sub walrus()
Dim dir As String
dir = &...
0
votes
1
answer
2k
views
Exporting UTF-8 CSV with double quotes from Excel
According to Microsoft you can just use their Visual Basic macro to export columns from a table to a CSV with double quotes:
Sub QuoteCommaExport()
' Dimension all variables.
Dim DestFile As ...
0
votes
1
answer
119
views
Export Data from Column A into a text file based on Column B
I am looking to populate a number of SQL scripts using data from Excel.
In one column there is a list of usernames.
In an adjacent column, there is a list of locations.
I have a template of a SQL ...