I want to set a different header and footer with VBA for the first page of an Excel sheet that should be printed. The right header should contain a picture and the left header another picture. Those should only be displayed on the first page.
I have tried the below code but somehow the .Firstpage...
@QHarr try getting an ADODB.Connection out of the WorkbookConnection, and then you can set it to a WithEvents variable and handle WillConnect and/or WillExecute events, ...although I'm not sure the handlers get a Cancel parameter to kill it, but then you have the connection object so closing it should effectively cancel the refresh (and possibly blow up)
Hi @all!
@Freeflow Int.MinValue being named doesn't make it any less of a magic number: "to indicate its not yet been used" sounds a lot like an int? (Nullable<int>) would be less error-prone. And then you get compile-time validation that the code using an int is not working with the "not yet" values!
@MathieuGuindon Thanks for the suggestion. The situation is awkward in C#. The variable in question is dynamic and holds the AutoKey for my KitchenSink with knobs on Dictionary object for VBA. The Dictionary object is a response to doing Advent of Code puzzles where you seem to spend a lot of time iterating over collections, which is tiresome in VBA.
As a pet project its been quite interesting. It allows me to compile answer to Advent of Code puzzles such as that for Day 02 2020
```
`code` Public Sub Part1()
Fmt.Dbg "The answer to Day 02 part 1 is 414. Found is {0}", _ Lib _ .GetAsKvpOfStrings(AoC2020Path & InputData) _ .Map(mpParamMethod(TobogganPassword, "Make")) _ .Map(mpItemMethod("IsValid", PasswordCheckSled)) _ .Filter(cpTrue) _ .Count
in this case when as operator was introduced. It did turn out to be the culprit. Apparently SSIS script task is too dumb to tell you when you're using unsupported features and will successfully compile a script using newer language features but in this case, the breakpoints no longer work.
VBA Rubberducking
VBA Rubberducking