Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft.
-4
votes
0answers
16 views
MS Access VBA freeze/crash on Export [on hold]
The lines below are an extract from code used to generate a XML.
Access freezes than crashes when executing the Set dlgSaveAs line. This seems to only happen when data is imported using .xls files, ...
3
votes
2answers
120 views
Converting CSV files to Excel workbooks
My converter converts all CSV files in the subfolders of folders 1, 2 & 3 into Excel workbooks. As of now, I am converting using codes for each folders. I previously tried to combine those into ...
3
votes
1answer
43 views
VBA macro to move data across workbooks
I'm new to VBA and am trying to write a macro to move data from an exported file to an excel template. The code below works, however I have to add many more ranges of data and am worried it will be ...
6
votes
3answers
107 views
Extracting data from CSV file on the internet
This is my code I made that extracts data from a .csv file stored on the web. My sheet called 'New Data' stores this data for 2 days. I store 2 days worth of data so that when I run it next time, it ...
3
votes
3answers
166 views
Copying a range from one file to another
Since it has too many loop, loop inside loop, this works very slowly. How can we increase the speed of this program? I am trying to copy a range from one file to another file of same name in different ...
7
votes
3answers
173 views
Colorizing Excel cells with a date range filter
In a table there is a number of column (chambre) and a number of row (alveole). If these matches in a list in an other sheet then it checks if it the date is between two dates on that second sheets. ...
4
votes
2answers
213 views
Calculating how long sales reps are idle
I wrote a procedure to calculate the number of months elapsed since a sales agent' last sale. It works but runs in over 10 minutes... for 20 rows.
...
5
votes
2answers
80 views
Select and Paste Rows in a Different Location
I am working with the output from a chemistry instrument, in .xls format.
The output contains up to seven blocks of data corresponding to different types of samples e.g. controls, unknowns, ...
4
votes
3answers
19 views
Copying data from an Excel sheet to Word
This code copies a specific range and a chart from an Excel sheet to Word. This code works fine but it is very slow. I have used delays(Wait) to work properly while ...
5
votes
2answers
161 views
Intense worksheet manipulations: what price did I pay for performance optimization?
The code bellow was refactored for performance improvements for another user on this site.
Functionality, high level:
Sheet1 - CodeName aIndex: used as the main reference to the structure of the ...
5
votes
3answers
80 views
Copying columns and formats on condition
I have made significant changes in the code and now it takes about 20~40 seconds to process each worksheet. This will conditionally copy column based on the column headers in sheet2 that match to the ...
4
votes
3answers
165 views
Sorting and color-coding based on variables
I have the following three macros all running in the same module. Each one is attached to its own button (3 buttons total). All three buttons take an average of 6-12 mins to run. As I am working on ...
5
votes
2answers
84 views
Searching a huge number of strings from Excel to a large number of Text files
I have written this code to get the input string from the spreadsheet and search the string across the text files and state whether or not it is found in the Excel sheet.
Scenario:
Excel (sheet1):
...
3
votes
3answers
98 views
Translation function - one word set to another
I have this Excel VBA function that takes three parameters. It is essentially a translation mechanism with the following parameters:
A sentence which has to be translated.
A range of words to look ...
7
votes
4answers
154 views
Looks at order data and arranges it to focus on order locations
I have a sheet that order a bunch of information on individual orders. Order numbers are in column A, other information is in columns B-P, and then product numbers are the headers for columns Q-DL. ...
5
votes
1answer
64 views
Open files, copy area under header, print to mastersheet
This loops through folder to open files and get important info from the columns of names "HOLDER" and "CUTTING TOOL" and printing all the info to one excel document, masterfile.
It utilizes a ...
3
votes
3answers
170 views
Clearing Pictures Code
The following code removes all pictures that are placed into Column A. When running the code however I have noticed it runs fairly slow. This will be attached to a command button that will be located ...
5
votes
1answer
35 views
Import Excel, unpivot data, output tab-delimited for SQL Import
I have a client GL file (Excel) that needs to be regularly imported to SQL Server (as tab-delimited txt).
Sample (simplified):
...
6
votes
3answers
134 views
Conditionally copy columns
I have this Excel/VBA code and here is what it does:
I have 3 sheets, where first sheet has two columns that will be used (A,C).
2nd Sheet is just the raw data file that will be imported from ...
7
votes
1answer
81 views
Finding and pasting images into a specific cell
The below macro finds and pastes images into column A. While the macro works, it starts to slow down when running 500+ images. I am not too familiar with the VBA language, does anyone have any ...
3
votes
1answer
32 views
Data cleansing and formatting script
This is a script that creates a base dataframe from a sqlite database, adds data to it (also from SQLite), cleanse it and formats it all to an Excel file. I feel like it is incredibly verbose and my ...
5
votes
2answers
130 views
Copying from sheet to sheet if column headings match
Basically, I have three sheets in my workbook where only the second and third worksheets are being used. I want to copy columns from the second sheet to the third sheet only if the column headings ...
9
votes
3answers
122 views
Adding data from multiple Excel files to two lists
I have 5 nested for loops below, to add rows of data from multiple files to one of two lists. Is there a more pythonic way of doing this? I've come across an ...
1
vote
1answer
46 views
Inserting row into named range code
I am writing a macro for an inventory management document. The point of the User Form is to allow the user to add a new item to each of 5 sheets (Daily Sales, Total Inventory, Deliveries, Income ...
0
votes
1answer
83 views
Split excel file with multiple sheets, manipulate the data and create final out file
I have an excel file with 20+ separate sheets containing tables of data. My script iterates through each sheet, manipulates the data into the format I want it and then saves it to a final output file. ...
4
votes
1answer
54 views
SQL + VBA Populating Data in Cell Range
I currently have a code that is connecting to SQL database in VBA. The data is populating correctly. However, I was wondering if there is a way to condense the code below.
I have 4 different columns ...
3
votes
2answers
59 views
From New Worksheet, AutoFill Dates, Delete Extra Columns, Save As Month and Year
I have created an inventory management sheet for a Lodge in Africa. The general conditions of the document are that it has to be easy to use, because the people who are using it are not very computer ...
5
votes
1answer
196 views
VBA Text import and sort Excel
I have routine tasks which require pulling data from an obsolete SPC package and putting it into Excel. The SPC software will only export into a text file.
I have put pieced together a script to ...
7
votes
2answers
132 views
VBA Text Array - Scan two columns rather than one
I have some code which is designed to scan columns F and G for occurrences of words found in an array, the array containing text ...
1
vote
1answer
24 views
Excel Laboratory Data Entry from Python 2.7
I've written a script to automate the entry of laboratory instrument data into an Excel spreadsheet using pandas and win32com.
I've got the script functioning correctly, but it is painfully slow. In ...
5
votes
1answer
323 views
Working with group of checkboxes in MS Excel
I have the following checkbox as depicted by the image below:
The checkboxes are in 3 groups. Confidentiality, Integrity ad Availability. When the first in is clicked, the Confidentiality turns Red ...
2
votes
1answer
67 views
Select Case w/Public Functions
I am looking to enhance my VBA skills and efficiency with the code below. It currently executes at about 20 minutes. I just recently learned how to use public functions but this project is very ...
2
votes
1answer
52 views
Comparing cells of two Worksheets
With the following Code I try to compare the content of two Worksheets.
The first column contains a key that is unique and the following columns contain data that I want to compare (My data sets ...
5
votes
2answers
237 views
Look for keywords and copy to another sheet
I currently have a working code that does exactly what I want it to do, loops through a particular part of an excel document looking for certain keywords, then pasting those keywords into a separate ...
4
votes
1answer
89 views
Reading in a series of Excel files
I needed to create a program which reads in a series of Excel files in folders typically structured something like this.
...
2
votes
1answer
64 views
Loop through folder names on a server directory
I have the following code to loop through a directory of folders and print all folders names with their paths in a worksheet. This is a follow up question to this one: Excel VBA - Get Folder Names
...
2
votes
2answers
66 views
Excel .find Macro to write data to archive
I would like to speed up this piece of code. The macro gets a search variable from the worksheet "RAW_DATA_ARCHIVE" and then it should find it in the worksheet ...
3
votes
2answers
204 views
Excel VBA - Get Folder Names
I need to get folder names with the path for which I need to search the directory in a server with about 6000 folders. I have the following snippet of code to run through the folder and get the folder ...
4
votes
2answers
119 views
Extracting and analyzing data from SAP
I developed a script for the company I work for in order to extract data from SAP (CJ74) and analyze the data.
One particular issue I am finding is that for any data sets which have over 1000 lines, ...
2
votes
1answer
159 views
Download stock data from Yahoo Finance
This Python 3.4 script downloads stock data and puts it into an Excel file.
...
6
votes
3answers
242 views
Remove blank entries from row
I wrote a sub to remove the blank entries in a row without shifting the cells around but it seems unnecessarily clunky and I'd like to get some advice on how to improve it.
...
6
votes
2answers
130 views
Copy data to another worksheet
I have the following but it takes long time to run, it is a simple wherein the user select a file and data from Sheet1 is copied to another workbook.
...
5
votes
4answers
173 views
Find function for strings in cells
In column A, I have many strings ~ 32000 cells each containing unique string values. I then have columns C to as many as 30/40 columns which all contain approximately 400 rows of text.
Check column ...
5
votes
1answer
48 views
Update on Weave Merging n lists into single list
This is a follow up to my previous post from 7 months ago. I changed up the algorithm a little. Instead of inserting items into a new list, each item's final place is calculated up front. Sort of like ...
4
votes
1answer
77 views
Assigning values to a particular table column
I have a set of Excel data which I read and assign to corresponding columns of an Excel table. In our Excel we have provided the user the option to rearrange the Excel column fields at runtime.
...
4
votes
2answers
151 views
Counting and Deleting Duplicate Data
Can anyone help me optimize the current VBA code below? It is taking 20 seconds currently to collect,store, check and validate 1000 data's.
This program takes specific values from multiple sheets and ...
11
votes
2answers
99 views
Follow-up: Randomizing Civilization 5 team choice
This is a follow-up on my previous question about a VBA macro for randomizing a draw from a table. It can be found here:
Randomizing Civilization 5 team choice
The code has been improved with the ...
16
votes
2answers
291 views
Randomizing Civilization 5 team choice
This macro is made to randomly draw specific number of civilization choices for a specific number of Civ V players. It is based on a list of 43 possibilities and the ...
4
votes
1answer
44 views
Key on a Header and Offset
I have a section of code that I've been attempting to clean up and hopefully speed up. The section of code where I pass values in order to generate a key and update a table on a different sheet I ...
5
votes
2answers
113 views
Replacing a For Each loop with something faster
I'm a very inexperienced VBA user, I've just created my first "For Each" loop but it's very slow. I'm happy that it works but eager to know if there is a alternative method that is quicker. Any ...
