csv

I'm having a bit of an issue with an Excel power query and VBA. In VBA: I create a new sheet in my workbook and name it. I get my data from a CSV file with the information I need into a power query in my workbook. I can see the query in the workbook and view the data, everything is there. It...

This might be very easy for one of you but I can't anymore, I am not that expert in Visual Basic. I'm trying to make a new file that asks with a button for two files. Both have vehicle information, one in column A and the other one has same information in column B (as the images show). The...

Hi All, I apologize if this has been asked previously but I can't seem to find the answer, but I may not be searching for the correct thing. I have to create packing slips for orders being sent out. Currently, I am manually entering information (copy and pasting) into an Excel file that has...

I have several CSV files that are exported from an air quality monitor. I am trying to extract only the useful values, which to me is any row with either column C, D, or E containing a non-zero number. All of the other rows can be deleted. Additionally, there are new header rows inserted...

I am trying to save a new opened workbook as a csv on a Mac but keep running into error 1004: application or object defined error here is the code: Dim directory As String directory = "/Users/johnsmith/Desktop" Dim mystring, clientname mystring = Range("B2").Text clientname = Mid(mystring...

**Please move if this is in the wrong thread group** I believe I have finally spliced a VBA code together in order to do what I'm trying to accomplish however I can't seem to get the specifics correct. Scenario - I receive 3 emails every night at 8pm that contain 1 excel/csv attachment each. I...

Hello there, Although this is predominatley a Power Query Question, the criteria are obtained from an Excel Sheet and the output placed on 1 Excel sheet. I have some PQ code (Windows Excel 2016) that will load a single pre-specified CVS file into Excel as follows: Excel Sheet1: Excel Name...

Hi all, Whenever I open a csv I get this warning message: Furthermore, my data shift's over to the right, there is an example below but the issue can be random - it may add lots of different empty rows and shift a few rows over to the right, or sometimes the data overlays the rows on top of...

Hello, i have created an excel file where there is a button and when the user presses it, it prompts a window for the user to select a CSV file to be edited. After the file is selected i make some changes and save it to a new csv file that works fine, but i struggle to add double quotes (") to...

I'm trying to build a simplemacro in VBA for Excel that would SUM [merge] all the rows that have the same name (value in the first columns) and save as each sheet to CSV file. So for example : sheet1 Apple 20 Banana 50 Banana 10 Apple 80 Sheet2 Orange 10 Melon 15 Orange 25...

How do I convert each row into a list without adding a new column? What I have so far: = Table.TransformColumns(TESTT, each Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv)([TESTT])) It gives error: Expression.Error: We cannot convert a value of type Function to type List. Details...

So I have a VBA Macro that formats a sheets that contain Column A, B and C. Is it possible to create a macro that adds a TAB separating the Columns so when I save it as a CSV, I get a Tab Delimited CSV file instead of a comma?

Hi everyone. I am trying to come up with solution to convert .csv file to .xlsx. Although there are many topics regarding that, I am unable to find anything suitable for me and I am not that experienced in VBA to write the script myself, yet ;( I would like to create an ActiveX Control button...

Hey all, I'm not entirely sure if this is a VBA question or a macro or formula I can use. But here's what I'm trying to do. I have two files, we'll call them File 1 and File 2. In File One, there are 3 Columns: ID, Name, Title IDs ID and Name have one entry in their respective cells...

Hi all, I currently have this graph: I don't really care about the light and dark orange columns, but I need them to stay nonetheless. However, the grey chart rises from a value of about 9300 to 10500 doing this period, which is not that noticeable in this chart to be honest. I would like...

Hi, Actually I'm using this code, to save a specific worksheet in CSV, on a predefined folder path, with this code the user can add the name for the file and it will be saved on the predefined path : here is on the desktop Public Sub Save_CSV() Application.ScreenUpdating = False...

Hi Excel Guru Wizards' brains' trust. Can you spare a moment to help me with a formula. or suggestion an alt soln. Please. Ok so here is the background. In a folder, a new CSV file with the date gets added each day at the start of the day. e.g. The folder has heaps of csv files...

I have 2 sheets in my workbook. I am trying to determine if the serial number value from any given row in sheet 1 exits in a column of comma separated values in row Sheet2. I have no control over how the data is exported from either system. I've tried to find and I dont get any data. I've...

Hello, I'm new to vba, i saw a post when i was researching to: how to copy all the details from one sheet, copy this and save it in csv format on a specific folder. Then luckily I saw the code @Georgiboy posted and tested it: Sub Print_Test() Dim FSO As Object Dim TextFile As Object Dim rCell...

Hello, I have a .csv file with data that contains spanish characters (á, é, ñ...). If opened in Notepad++ I can see the characters correctly, but when I open it in Excel I get the typical strange characters (Fern~ºndez, instead of Fernández). I need to open several of this files using VBA and...