Search results for query: *

Hello all, I am having an issue with some vb code and importing data from a .csv file. I have a software program that we export a series of data out of every morning. When the first series of data is exported it is saved in the format of "query_export_results.csv". However, the next series of...

Hello all, I did some searches for this issue and there are some variations, but I can't seem to find my same issue. I am using Excel 2010 and have written/tweaked VBA code for a while now. I have a userform I created with 2 multi-select listboxes and 3 textboxes. The goal of my userform is to...

Hello all, I have an excel file that gets populated every month and resaved based on the current month/year. I need to routinely copy a range of data from the previous month's file into the current month's file. Within the copy range there are some formulas that use vlookups into another...

Hello all, I tried searching through the forums and didn't see the exact issue I have so here goes. I have some data that on a monthly basis gets copied to another workbook and saved. I am trying to automate the process of doing the data copy, file saving and page formatting. So far I have...

Hello all, I have data in an existing excel workbook that I am trying to copy into a new workbook and then rename the new file based on given variable names. I had previously recorded macros to autofilter the data, select the range of cells I wanted to copy, create a new workbook and past the...

I have a worksheet and user form that is used to import summary data from several data files (.CSV) and copy it to a tab in the main worksheet. The user inputs where the files are stored, what type of file they want to open, the incremental number of the file, and the name of the tab where...

Hello all, Does anyone know how to open an internationally formatted CSV file using VBA? The CSV file uses the semicolon as the column separator and the comma as the decimal point. I created a userform that enables a user to point to a data directory and open a series of files that are...

Hello all, I am new to the forums and am trying to resolve a VBA error I keep getting using the SLOPE function. (Note: I looked at the other topics and could not get the solutions to work for my issue) I am trying to analyze a set of data in Excel that varies week to week. Yield 1 Yield 2...