vba & csv

Hi everyone. First time posting and I'm a novice when it comes to VBA. I have two .csv files that are exports from another program. I am trying to copy some of the data from those .csv files into one excel file so that it can be imported back into the program. The two .csv files have different...

Hey All, I am still pretty early in learning VBA and am wanting to build a reporting tool for my teams that help them to better understand their salary-to-revenue percentages. The general outline of what I am trying to build is as follows: A table is exported to CSV from Workday. A teammate...

Hi, anyone can help me with a VBA code this: 1) Save CSV file in the same actual path 2) After "x" seconds press Start 3) Repeat the two actions every "x" minutes

Hi all, I have a csv file with 500 lines, each containing 3 items such as article 1, summary 1, reference 1. I am trying to merge/group the line items in batches of 15 and add the references as the end of each batch. So the structure of each new line will look something like the following...

Hello I am trying to edit this piece of code that compiles all workbooks in a folder to only compile workbooks in a certain week, I'm stuck and am unsure how to proceed. I have looked around and seem to be unable to find someone else with this exact problem, if I could get some help or a link to...

I have the below VBA that allows me to export a CSV file from a defined range. However, there are 2 issues here that I need your help to resolve: 1) When I export using this code, the exported CSV file includes empty/blank fields from the defined range. I believe the problem is that the .csv...

Hello, i would like to make a data input from two workbooks that is in the same path. The data input should be in the master workbook from those two files. The first sheet in the master workbook should just be empty as im going to make macro run buttons for later purpose. The data from the first...

Hello everyone I would love some help to develop some VBA code. But im very new to VBA. Hope someone can help me with it, and i know its a lot to implement. So its for private purpose and a "just for fun project". The project is that i want to two files in a path that i want to match with...

Hi, I have 0 experience in VBA but I managed to write one that allows me to do the ff: 1. Browse and select and open files 2. Delete a specific column if it exists and copy the remaining column starting Row 5 and paste the result in a specific sheet Now I need to revise it but I can't seem to...

Hello all, Trust you're good. I got this script from Kutools that allow me to split data into sheets. For example I need to split 1 sheet of 5000 rows into 5 sheets of 1000 rows. My issue is that when splitting the sheet, it decrease the rows by 1000 only (sheet 1 5000 rows, sheet 2 4000 rows...

Hi everyone, I've got some problems with the vba code, that I found online. I want to import multiple csv files without header into the worksheet "csv_data". The following code imports just one file, even though I select a few. Please tell me where I made a mistake. Sub CSV_Import() Dim...

Hi i am very new in that thing of programing specially in VBA, so i want to know if you have some books or pdfs that could help me to improve my skills, if this material is in spanish it would be better because its my language. Thank you to all

Hi All, I have a sheet that gets data via a query from the server. The aim is to filter for the info needed and having a 'Generate' button to create a separate .csv file for only the filtered data. The issues I have are the following: 1. I am new to VBA, I currently have some autofilter code...

guys i do need help for calculating range like no effect of terrain and anything. i need macro anything on my excel document to simultaneously calculate distance vs battery percentage .that is whenever it goes from 80% to 5% it will charge again means reset its counter and so on . my total range...

Using this: Private Sub Create_CSV() Dim content As String Dim Rng As Range Set Rng = Range("A12:AS30") Dim Path As String Dim FileName1 As String Dim FileName2 As String Dim FileName3 As String Dim sWB As Workbook, _ sWS As Worksheet Dim dWB As Workbook, _ dWS As...

Hello all, I am attempting to write a VBA to input data into a sheet I am working on. I am trying to input data into a spreadsheet that is currently set up so I need to paste data into the range D2:D195 in the current sheet. I would like to create a button that would allow me to pick a file...

Hi, Due to our present global situation, I am required to receive a document used in FoxitPhantom and move the info into excel. In order to avoid duplicate entry of information, I would like the information completed in the PDF form to copy into a specific template created in a worksheet...

Is there a way to use VBA to open the save as dialog box, set a default name from cell information, and pick the save as file type? Basically I want it to select sheet 3, Do file save as, default the name as (if I put quote marks I want the cell contents), "D3" "B3"-"C3" So it would be...

My code opens 7 new workbooks and saves them as CSV files without closing them. Later in the code I need to activate the relevant CSV file to post data into it. However, I can't seem to activate the appropraite CSV file. If the files are saved as FileFormat:= xlNormal the code runs perfectly...

I have a folder in C:\CSV\ where more then 6000 csv files are available and the more important thing is, every csv file has only one colum but many rows. Now i want to transpose all csv files and make it one file in excel where transposed data shown. there is no name of column and rows. Any one...