All Questions
Tagged with error-handling vba
614
questions
-1
votes
1
answer
58
views
VBA Outlook act when email arrive - error handling
I have a VBA code in outlook waiting for mail arrive to Groupmailbox to do something. It works well, until something bad happen on external resources. It process thousands of emails without any ...
0
votes
0
answers
41
views
VBA ADO transaction detailed error instead of generic
I have a problem with ADO transaction. I would like to catch error that is thrown within db, not generic one.
If I remove transaction and execute command then I am able to get it in VBA using err....
0
votes
2
answers
61
views
Sent each SAP command to another sub and execute it for error handling
When a command is sent to SAP GUI like SAPsession.FindById("wnd[0]").resizeWorkingPane(170, 25, False) and an error occurs I'd like to log the error and let the script continue after user ...
1
vote
2
answers
68
views
VBA - Check for valid file path not working as expected
I'm working on a macro for work and at the end, trying to save. It's going to be accessible to a group so the place to save the file will not be static. As a workaround, I'm asking the user to specify ...
2
votes
3
answers
128
views
What exactly is the scope of the On Error Resume Next statement?
I tested Microsoft's statement about the scope regarding the On Error Resume Next statement:
An On Error Resume Next statement becomes inactive when another procedure is called, so you should execute ...
0
votes
0
answers
33
views
Excel Autofilter not showing data if a criteria element does not exist in filter [duplicate]
Ive spent days working on this issue and searched many forums for an answer.
I have a table of data which contains 5 columns (Source, Area, message, Incidents, Downtime_Hours):
Data Table
I am trying ...
0
votes
2
answers
51
views
How to get error message text which are sent by Runtime Engine
Run the following macro.
Sub Macro1()
MsgBox "Hello"
End Sub
When the MsgBox pops up, press Ctrl+C keys on your keyboard.
Open a NotePad file and press Ctrl+V keys on your keyboard.
...
1
vote
0
answers
30
views
VBA handling weird error related to copying chart
I am working on a macro that copies a chart from each worksheet to a temporary sheet. For some reason, the macro fails when trying to copy the 6th chart, and says
The specified dimension is not valid ...
0
votes
0
answers
32
views
How to keep shell open when running VBA code? [duplicate]
I am trying to debug some code a coworker wrote using VBA. I can't find anything wrong with the VBA, but he does call Shell to run a python script. I want to be able to see what's going on while the ...
1
vote
1
answer
41
views
How to create a "sub-error handler" in procedure?
I have a vba procedure including an error handler.
Now I have found that this part of the procedure might cause an error en therefore trigger the error handler:
'zoekt de juiste brigade bij de ...
0
votes
0
answers
79
views
Run-time error '6': overflow for VBA scripting
I tried to implement this code in VBA but it keeps bumping the error of "Overflow"
Could someone help to check what's wrong with my code?
Thanks.
I tried to debug a few times for the ...
0
votes
2
answers
45
views
Error Handling in Workbook Index For Loop
I am trying to sum indexed values from across several worksheets, and I have a method that works. The issue is error handling. It is common that the Match function returns an error when it cannot find ...
0
votes
1
answer
34
views
VBA Excel : Error showing alert (and stopping code) despite Error handling
i'm writing a code that filters out a table and selects the shown data to copy it elsewhere. If the filter I apply shows nothing in the table and my code tries to select "nothing", the error ...
0
votes
1
answer
46
views
Find and Select cells with specific text in one workbook and copy to another workbook gives Runtime Error 91
I use the "Find" option in VBA to search cells (in workbook wbMain) containing a certain text, after which I copy the value in the next column (via the Offset function) and paste it in the ...
0
votes
0
answers
70
views
VBA Macro runs fine in my PC but gives me overflow error in Excel with work laptop
Overflow error on the debugger is highlighting this line:
concatenatedValue = IIf(isDateColumn, Format(currentData, "mm/dd/yyyy"), currentData)
Code:
Option Explicit
Sub ...