Jean-François Corbett

Jean-François Corbett has asked 36 questions and find answers to 135 problems.

Stats

About

I'm a physicist / software enthusiast working in wind power.

https://www.linkedin.com/in/jfcorbett/

I used to code on this, hooked up to our TV with a coaxial:

enter image description here

That's color, baby!

enter image description here

Jean-François Corbett questions

Handling errors in math functions
Algorithm for two-dimensional rebinning
Pass existing FileSystemObject or create multiple instances
Converting vector-contoured regions (borders) to a raster map (pixel grid)
Upcasting when making object
Restrict type in a Collection inside a class module
Loading settings from XML file into a Java class
Change chart font using VBA
Bounding ellipse constrained to horizontal/vertical axes
DoEvents doesn't do the events... Why?

Jean-François Corbett answers

how to treat empty parameters in function calls?
Change a String to Uppercase if it Exists - VBA
VBA event throws error when pressing a button?
Word find and replace using regex | alternation operator
How to convert string to number and vice versa in Excel
How to detect if the computer is 32-bit or 64-bit?
Replace part of hyperlink
How do I delete all characters after the first space in a cell?
Excel 2007/2010 color scale conditional formatting based on formula
How to normalize filenames listed in a range