This pull does break Rubberduck due to a change in the XML Serialization of the Config file. Deleting any existing Rubberduck.config file fixes the issue. Rubberduck will use a built in default configuration until the user modifies the configuration via the Options dialog. At that time the file is created and used.
Also made a change to implementations of `IInspection`. They now use `InspectionNames.resx` to get the string representing thei...
i'm having serious trouble with those nested Ifs, Here's what the code is for:
it looks at the number of the transaction and verifies if it belongs to that "j"
after that, searches the date of the transaction and verifies if it was yesterday or not, if it was, the cost (which is in the column E...
Sub HelloWorldMessage()
Dim msg As Outlook.MailItem
Set msg = Application.CreateItem(olMailItem)
msg.Subject = "Hello VBA!"
msg.Display
Set msg = Nothing
End Sub
@RubberDuck should Rubberduck just create the default config file if it blows up reading the existing one? What happens if the config file gets tweaked and borked by the user?
Your life will be easier when you use meaningful names for your variables. Code that uses single-letter variables everywhere is more error-prone... by design. — retailcoder7 secs ago
DATA
I have 4 Collection objects of the following kind:
dates1=(12/01/02, 15/01/03, 17/01/03, 25/04/04...)
dates2=(15/02/02, 17/06/07, 10/05/10, ...)
numbers1 = (3,5,2,7,...)
numbers2 = (1,-3,-1,...)
The rules of the game are:
a) "dates1" will always have the same length of "numbers1", "dates...
> If the *.config file is missing, Rubberduck uses a default configuration that is more or less hardcoded into the system and then later creates a new *.config file.
If *.config is simply corrupted, then Rubberduck blows up and the add-in doesn't load. Catch the exception and give the user the option to repair the *.config file with a warning that any customization will be lost.
It takes around 5-8 seconds to a stock previous closed price & dividend rate from US yahoo finance. If I wanted to retrieve 10+ stock price, it would take me more than a minute with below VBA code.
Is there any other way to speed up or improve the code?
My VBA code:
I input multiple stock code...
It takes around 5-8 seconds for me to retrieve a previously-closed stock price and a dividend rate from US Yahoo! Finance. If I wanted to retrieve 10+ stock prices, it would take me more than a minute with the below VBA code.
Is there any other way to speed up or improve the code?
I input multi...
@Mat'sMug I have a schema with a number of INT columns. They will be used for calculations, but some of them will not always have a value. Would it be best to use '' (empty), NULL or 0 in your opinion?
CREATE TABLE card
(
id SERIAL PRIMARY KEY,
version INT NOT NULL,
name TEXT NULL,
description TEXT NULL,
effect_description TEXT NULL,
type TEXT NULL,
attack INT NULL,
health INT NULL,
mana_cost INT NULL,
scrap_cost INT NULL,
scrap_value INT NULL,
sickness INT NULL,
attack_available INT NULL,
create_date TIMESTAMP WITHOUT TIME ZONE DEFAULT NOW(),
delete_date TIMESTAMP WITHOUT TIME ZONE DEFAULT NULL
);
^^ This is the table in question. All the INT columns from attack down can potentially not have a value
I had some time to kill today, and I found the Karate Chop Kata.
Specification:
Write a binary chop method that takes an integer search target and a sorted array of integers. It should return the
integer index of the target in the array, or -1 if the target is not
in the array.
I...
i'm having serious trouble with those nested Ifs, Here's what the code is for:
it looks at the number of the transaction and verifies if it belongs to that "j"
after that, searches the date of the transaction and verifies if it was yesterday or not, if it was, the cost (which is in the column E...
DATA
I have 4 Collection objects of the following kind:
dates1=(12/01/02, 15/01/03, 17/01/03, 25/04/04...)
dates2=(15/02/02, 17/06/07, 10/05/10, ...)
numbers1 = (3,5,2,7,...)
numbers2 = (1,-3,-1,...)
The rules of the game are:
a) "dates1" will always have the same length of "numbers1", "dates...
It takes around 5-8 seconds to a stock previous closed price & dividend rate from US yahoo finance. If I wanted to retrieve 10+ stock price, it would take me more than a minute with below VBA code.
Is there any other way to speed up or improve the code?
My VBA code:
I input multiple stock code...
I had some time to kill today, and I found the Karate Chop Kata.
Specification:
Write a binary chop method that takes an integer search target and a sorted array of integers. It should return the
integer index of the target in the array, or -1 if the target is not
in the array.
I...
VBA Rubberducking
VBA Rubberducking