Questions tagged [excel]
Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft.
111
questions with no upvoted or accepted answers
3
votes
0
answers
30
views
Speeding up a complex array function in excel
I have a complex array function that takes way too much time to calculate, which is why I'm looking for ways to make it more efficient. Basically, I have a transaction sheet in which I list all goods ...
3
votes
0
answers
149
views
Rich data types - boolean object
Context
You can probably skim most of this, it's unlikely to be useful for a review and is just for background info. Also download the files
I've tried to create a ...
3
votes
0
answers
2k
views
Alternative for VLOOKUP/Index-Match in VBA
I am sharing this function I wrote with the community to provide an alternative to slow VLOOKUP and/or Index-...
3
votes
0
answers
1k
views
Copying content from Excel into PowerPoint as a picture, with error handling
The code below works, but I want to ask if my solution is adequate or if there's something I should structure differently. If it's alright, I'll apply the same code in other subs.
My code copies ...
3
votes
0
answers
415
views
Converting VBA Add-In to C# VSTO. Code following button click event
This is my first program with C# and VS and was originally a VBA Add-In I wrote. I have embarked on this as a learning exercise. The code does work and provides the desired output in a new workbook.
...
3
votes
0
answers
67
views
Code runs slower when executed from ribbon compared to directly in module
We use third party addin that downloads market data from the internet into a workbook. The addin works with custom functions that begin with CompanyAddin. For instance, a formula in a cell could look ...
3
votes
0
answers
543
views
Retrieving data in multiple formats from Excel with Python
Scenario: I have an excel file that contains some data in the first sheet. That data can be simple strings on a cell or CheckBoxes (marked or not).
Data example:
...
3
votes
0
answers
493
views
Document "Search Engine" in Excel
I've created a somewhat "Brute-force search engine" based on a document's filename, as well as an additional keyword that describes the said document. I had to make one as my company's resources are a ...
3
votes
0
answers
180
views
CheckedRange Class
This class is used to make Excel Cells behave like Checkboxes. Clicking the cell raises a CheckedRange_Clicked(Target as Range) event and toggles it's value ...
3
votes
0
answers
222
views
Excel VBA to download from IE Database Stops Responding
first time using Code Review, although I have been active on StackOverflow, hope I'm in the right place.
I am putting together Excel VBA code that using information from various columns on a ...
3
votes
0
answers
1k
views
MS Office Suite VBA: ShellWait() and PowerShell()
I stumbled across this post on SO, and it had a link to some good code; however the code itself was a bit dated. Since the code has a "do not modify" clause I went back to the basics as noted by the ...
3
votes
0
answers
47
views
Getters, constructors and eval
I'm trying to parse an object generated from an Excel file. The output lists each cell with its contents. If the cell is just a number then it remains a number but if the cell contains a formula (has ...
2
votes
0
answers
441
views
SheetJS method to create an Excel file with subheaders
The method is fully functional and creates an excel as expected.
What I would like to know, is if can be made more functional and better written for maintainability.
For example, how can I put the ...
2
votes
0
answers
373
views
Command line framework for VBA compiler app, written in twinBASIC :o
Ok compiler is a bit of a stretch...
I'm working on a package manager for VBA code, written primarily in python. One fiddly step of the pipeline involves "compiling" packages; this is the ...
2
votes
0
answers
50
views
Python data entry into excel based on equality check with dataframe
My objective is to enter/type in values into Excel cells if the column names and indices match between Excel and dataframe.
So, my code does the below
Gets the ID values from the dataframe
for each ...