All Questions
Tagged with excel error-handling
24
questions
3
votes
3
answers
119
views
Follow Up: Refactored C# Tool to Generate MS Word Document Mailbox List From MS Excel
Background
Some very good observations were made about my original code in the 2 answers to this question. In this version I have attempted to reduce cyclic complexity and class coupling even more as ...
- 24k
3
votes
1
answer
133
views
Create Table After Deleting Rows Before Desired Range and Filter to Delete All Other Unnecessary Rows
The code below first searches for the first searchText and deletes all rows that precede it to establish a range for a table object. Once the table object is ...
2
votes
1
answer
1k
views
Part 2: Send HTTP request for each row in Excel table
This script was previously reviewed here: Send HTTP request for each row in Excel table (Part 1)
I've made the changes that were suggested in the Code Review answers as well as added a few of my own.
...
- 198
1
vote
1
answer
61
views
Clean up code that transfers data from DB2 Server to Excel
The code below is functional and works as expected, but I imagine there is a better way to test for the error that I am testing for .
The scenario is that data is transferred between two different ...
- 593
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 ...
- 161
10
votes
1
answer
723
views
A simple ascii progress bar
I've been wanting to experiment with a bit of error handling and robustness to make my code more user friendly. I was inspired by this answer on UX to try and add a progress bar to a button - but was ...
- 2,395
6
votes
1
answer
3k
views
Error-Handling Class and Logging for VBA
I've been reusing an error class in Excel VBA projects for a few years now and I'd like to see if there are ways to improve it. Any suggestions for style, code, etc. are all welcome.
The 2 ...
- 490
3
votes
1
answer
147
views
Running SQL Queries On A Worksheet (With Set Of Random Numbers Between 1-20 Filling Column A) Handled As An ADO
INTRO
I am using an Excel worksheet as my "database." No headers so [F1] is assigned to column one by default. I filled the entire column, all 1,048,576 ...
- 525
2
votes
1
answer
552
views
Executing arbitrary SQL statements using VBA in Excel
I built a workbook to help me extract data from a MSSQL database into Excel. I realize that this is fairly easy to do with Microsoft SQL Server Management Studio, but I can't easily get that installed ...
- 173
5
votes
1
answer
282
views
Error handling to restart Word from Excel inside a loop
I'm often opening, from Excel, all Word documents inside a folder.
And sometimes during the treatments, Word crash without throwing an error.
So I've added a bit of error handling to restart Word ...
- 359
6
votes
3
answers
590
views
Parsing excel cells containing line feed characters
This is a direct follow up to Parsing cells containing Line Feed Characters.
Link to sanitized xls on dropbox if test data is needed
Essentially the reports I work with aren't bad -
The issue is ...
- 7,159
10
votes
3
answers
252
views
Userform for getting data from data sheet into a table
I am making a userform that grabs data from a data sheet and puts it into a table:
Grabs the data based on what the user wants (Brand -> Items for brand)
Allows multiple items to be added
Displays ...
- 103
7
votes
1
answer
237
views
Class: 2D Variant Array
Note: Yes. It's big. I'm not expecting commensurately
long/detailed answers (though if anyone wants to write one, you'll definitely be receiving a substantial bounty). This class is going to be used ...
- 8,800
6
votes
2
answers
81
views
End of day receipt emailing process
The following functions/routines are an automation of an end of day receipt emailing process that formerly would take up to an hour, but now takes less than a minute.
Things to note: I changed the ...
- 589
4
votes
2
answers
4k
views
Count rows of a table
I am trying to count the rows of two tables generated by SQL connections in Excel VBA. My plan was to use ListObject.DataBodyRange.Rows.Count however, this errors ...
- 585
1
vote
1
answer
154
views
Code to analyse text get stuck if too much data
I've made the following VBA script to analyse text recurrence in a huge batch of descriptions.
For a small part of the batch the code run smoothly, but when I include everything it tends to loose ...
- 359
11
votes
4
answers
680
views
Get Workbook Method(s)
I'm re-writing my Module of standard methods. These 3 are used to retrieve Workbooks as Workbook Objects. The standard I'm aiming for here is "Third-party Library/Add-in". So:
Do these functions ...
- 8,800
3
votes
2
answers
673
views
Read sales transactions from Excel
This is a program to read and store the data from a Excel file (.xlsx) which is uploaded by users.
Any better approach to reduce the usage of if-else to return the error message?
How to design or ...
- 133
10
votes
2
answers
387
views
Creating a pseudo Pivot Table / Database using a 4-D array
Why am I not just using a Pivot Table / Database?
a) I've never ever used either before. And I don't have time to learn how before this project needs to actually be finished.
b) The final output ...
- 8,800
2
votes
1
answer
8k
views
9
votes
1
answer
939
views
Test if Excel is open without relying on catching an error
Getting a hook on an open instance of Excel is something I do all the time. I'm now questioning if I'm doing this the best way. I'm particularly concerned with the fact that I rely on the ...
- 30.8k
15
votes
1
answer
124k
views
Reading data from Excel sheet with ExcelDataReader
Objective:
I want to import an Excel file, and read the rows of certain columns. For this, I use ExcelDataReader. I've implemented a low-level class called ...
- 153
4
votes
1
answer
726
views
Is brute force the accepted best practice for handling Excel COM 'busy' exceptions?
Following on from a question about handling-com-exceptions-busy-codes I would like to know if the following model is the accepted best practice of handling Excel COM busy messages when accessing the ...
- 215
1
vote
2
answers
9k
views
Excel instances: release and kill
Please check my code below. I don't have any problems but I'm not aware how far the code will work, release and kill excel instances..
...
- 13