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 ...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...