@IvenBach that's pretty harsh, requiring them to drive a manual. Never mind that they have to also press the clutch and shift and press enter all at the same time.
and c'mon, what if you're just cruising on a highway? what reason could you have to shift then?
I am trying to do the following in one module:
Replace a Public Constant in another module using a code.
Call a code which uses the updated public constant
However, it throws an error:
"Can't Enter Break Mode at this time"
Although, it still updates the public constant.
I tried pressing...
@MathieuGuindon that is not a small number of tests!
I’ve read about CDec and CDbl and know the ranges for them differ. What I still can’t grok is how the numbers vary so much. IE how a Dec is 1E31 in terms of magnitude while Dbl is 1E308.
I’ve read about mantissa and that but exactly how it works still eludes me. Anyone know a good explanation of how the internals works?
@MathieuGuindon Random thought - is it better to add a space between VB and IDE? I know that VBIDE is technically correct, but I suspect that many (most?) users wouldn't know\care...
@IvenBach Play with this: h-schmidt.net/FloatConverter/IEEE754.html to see how single & double are represented in binary. This uses a single but the principle is similar for double. With decimal, it's just a scaled integer with a fixed amount of bits used as a decimal.
Thanks @all for the feedback! So, looks like we have a viable ducky concept for 2.3.x (and beyond, I think - thanks @ThunderFrame and @Vogel612 for the ducky work!). I'm not 100% sure about Tahoma, but it's definitely the death of Showcard Gothic. Maybe I could/should overlay the small-version "rubberduck" I use in my mail signatures (and SE profile), in the bottom-left corner, just to tie back with the old "trademark" lettering.
@MathieuGuindon damn, sorry, I was going to get you some SVG artwork. Have been laying low the last few weeks with illness, and I'm supposed to be moving house tomorrow.
I have an Excel VBA macro that interacts with an intranet site through Internet Explorer to loop through a list of customers, open the customers profile, update a field and save the changes.
The problem I am running into is that when I save the changes to the customers profile there is a pop-up...
IMO everything should be done in a vector-based editor. The rasrterized editors like Photoshop and Gimp will always lose quality on each edit. I use a licensed copy of Illustrator, but the freeware vector-based Inkscape is very good. All of the image then remains vector-based, so you can apply changes later, even if you don't have the fonts installed, and you don't lose quality.
@this Illustrator has a few more features than Inkscape, but Inkscape has very strong core capabilities. I had to use Inkscape once, while waiting for an Illustrator license on a job. By the time the license was approved, I was getting better results in Inkscape than Illustrator. I stick with Illustrator because I'm paying the license fee anyway, it's works better with Photoshop and other tools, it has a COM API and it has a broad library of scripts/add-ons available.
@this yes, depending on the supported SVG features of the editor, IIUC.
If we were to use a font that only one user had installed, that user would need to convert any usages of that font to outlines, and then anybody opening the file can see the words in the right way, but any edits of the words would require new outlines be created by the user that has the font installed.
I used to use a graphic designer that always provided 2 copies of the artwork:
One with the font/text embedded, and one with those words converted to outlines.
We still had to use him for edits, but we were free to move to a new designer that had the fonts installed, and he/she wouldn't need to re-type all of the words.
I'd suggest we go with an Open Source Font.- Not because we have to (we don't), but because there are hundreds of open source fonts that are very good. For example, a bold/heavy version of Montserrat or Raleway are both open source licensed and have clean, modern appearance.
@this I can take a photo of your poem in foo font. IIUC, I can't reproduce the poem without violating copyright, but I can reproduce renderings of certain words in that font without violating copyright. With fonts, it's the "computer program" that generates the kernings and spacings, and not the kernings/spacings themselves that are copyrighted.
I.e. you can copyright how a font appears, but you can copyright how a font is generated. Like all things IP, it's an ugly, uncertain world.
Digging around in my bookmarks, I found this online design guide which is better and more up to date than the PDF/Wordpress link that I posted a few weeks ago.
@MathieuGuindon I used to be intimidated by the vector editing packages, until I had to correct the artwork on a box design one day. Took me hours, but I got there eventually, and taught myself loads in the process - necessity makes great learners of anybody game enough. Although, it is easier to learn, I think, in Illustrator, because there are so many online guides/tutorials for it.
The thing that threw me in Inkscape, is that you create shapes, and then, if you want, convert them to paths. In illustrator, everything starts as a path.
@MathieuGuindon same with me - I had to google that for Photoshop too.
I have code that currently uses tab names instead of the code names. The problem is the tab names update making the code not work properly. I am looking to change the following to code names instead of tab names:
Summary 1 -> Sheet6
Summary (2) -> Sheet 7
Summary (3) -> Sheet 8
Sub HideRows...
I have code that currently uses tab names instead of the code names. The problem is the tab names update making the code not work properly. I am looking to change the following to code names instead of tab names:
Summary 1 -> Sheet6
Summary (2) -> Sheet 7
Summary (3) -> Sheet 8
Sub HideRows...
Well, I guess they are sent from the future, so to them this has already happened so of course they know about each other. Except of course that the future changes so Cyberdyne doesn't exist so it doesn't happen. But then, if it doesn't happen there is no-one to stop Cyberdyne from existing so... oh no my brain is leaking out my ears... — RyanfaeScotlandyesterday
@Comintern no, no, no... You need the entire objective reference from MS Open Specification Promise: [OCRINGE] - Office Cringeworthy Code Specification, because it's just as easy (if not easier) to write cringeworthy code against Office, in .NET.
> Some tried to make worksheets Implements interfaces, and ran into issues (here too, and oh another). I completely agree with this post, which basically boils down to don’t. Whatever you do, don’t make worksheets implement an interface.
@Comintern VBA just can't work out interfaces on document-modules
@Comintern I know about dicts, and I've used them to that end a couple of times. I just miss some very nice functionality (maybe just because I know what could be done with a more powerful function). It can return a vector of unique values, a vector the same length as the input array with indices pointing to the vector of unique values, and more.
@MathieuGuindon is there a reason that rubberduckvba.com doesn't incorporate Rubberduck News? Wouldn't it be better, from a branding perspective, to host the WordPress news on the Rubberduckvba site? Presumably it would be better for statistics too.
Public Function Unique(inputArray As Variant) As Variant
With New Scripting.Dictionary
Dim idx As Long
For idx = LBound(inputArray) To UBound(inputArray)
If Not .Exists(inputArray(idx)) Then
.Add inputArray(idx)
End If
Next
Unique = .Keys
End With
End Function
If you need the vector to be the same length, I'd roll a class for that.
@Comintern Yeah, thanks. :) I guess it'll come down to that sooner or later. It sometimes irks me that I'm spending so much time recreating functionality that is available in other languages. So I start searching for some library to do what I need, only to come up with nothing. Presumably just not the right approach for VBA.
Of course, having one's own implementation does have its benefits as well...
@Comintern That's confirming my suspicions. I just consider myself (in most cases) not experienced enough to reliably tell awesome piece of code from funky looking trash. ;)
Although, in between Mat's blog, the RD inspections, this' advice (and now yours too, @Comintern), I feel it's (slowly) getting better.
Apps Hungarian was useful at the time. In a modern language they'd have ScreenCoordinate and PixelCoordinate structs (or whatever), to take the article's examples
Speaking of which... there is an update to VSCE which I tried applying at home, but something went wrong (I may have aborted it - it was a couple of nights ago, I don't remember) but it didn't crash.
Now it's still got the update notification, but it won't actually update. I left it running last night when I left for > 2 hours and it was still twiddling its thumbs doing nothing when I got back.
@Comintern FWIW, the bit about setting to Nothing is not without precedents, though - there was a known bug in one version of DAO library (3.5? ) where if you didn't Set rs = Nothing, you leaked memory.
@FreeMan I don't dispute that. I'm only saying I can understand why they do it since they were either bitten by that bug or was told by others who got bitten themselves. Coding defensively isn't that big of a sin, IMO.
the bad thing about that is that even after they fixed the bug, programmers had to put it in just in case it got run by a older computer using that buggy version.
Enter the noobs, and they see it sprinkled all over.... "must be The Way To Do Things.@" and set up the straw tower.
@this @FreeMan Agreed on coding defensively. For another example, just think of all the ways that VBA works 90% of the time for assumptions but gets you the other 10%, so you must code explicitly all the time to avoid that. Powershell has similar issues.
I'm a big fan of coding defensively.
@MathieuGuindon Looking forward to reading this as well.
@puzzlepiece87 come to think of that. I think my posh script for build has lot of that. TBH, I really do not like posh that much; too many surprises for my liking.
Crucial! Use Excel tables to your advantage, especially when doing data analysis! Understanding Excel's misunderstood 'Format as Table' icon: https://buff.ly/2MgbFI3 #excel #MicrosoftExcel #ExcelTips #Productivity
So, today I had to try to explain that a website isn't a PDF viewer/editor.
I have two features to build on top of our most horrible systems in two weeks.
I'd guess that to get the bugs out of them it'll take at least an additional 5 after they get in.
And I'm not certain I'll be able to get them both completely in.
And it's always awesome when you get to check in changes in untested and untestable code.
Like, where you literally can't even F5 debug it.
Because it relies on data being there over several days.
Oh, and I've got some other frustrating things to go over. If you are interested, I can discuss them after hours (while my colleagues are busy deploying this crap code to prod).
So, you know that codeless code about the guy who built the tower hanging off the edge of the cliff that kept falling apart.
I swear our codebase is a spitting image.
Also, TFW you realize you have a test that has about 200 lines of mock code.
Bottle up any disgruntelment and unhappy feelings. Use them as fuel and a catalyst to learn and grow your skillset. #I'mDoingJustThat and look at what it's done for me. :+1:
@Comintern If you develop and test against a not-buggy version of the API, then deploy against the buggy version, won't your code break when it hits bugs it wasn't expecting? Or are you mocking the bugs, too?
Sorry, i misunderstood. I haven't done the code for the button, but yeah it'd probably just be .Show Do you mean FormName.New instead? or does "New it up" refer to the code i pasted above? — Frederik 1 min ago
@IvenBach Everything's going great, thanks! Even though I don't hang out in this room explicitly, I keep an eye on it from the "other rooms you're in" feed. I'm always in one of the other rooms.
Had a nice date night with Mrs. Puzzle last weekend - cutesy art project, lunch at a new place, movie. How are you doing?
@Hosch250 My job frustrations are significantly less than yours, but if it makes you feel any better, I'm having to go through multiple approval layers, multiple times, as I change a single date parameter on multiple queries (the lower bound date).
Because they have been locking down the enterprise database scheduler super duper tight.
I've been promoted and moved to different tracks by being Process Improvement Man-Man-Man-Man but as of the moment my job has no formal inclusion of "Do lots of IT improvement because they're completely outgunned" :D
(Also, it probably will never include such a thing because I am not at all eager to formally include myself in agile development here (read: 70% of tags recur every week because you're doing the same thing over and over again because it hasn't been automated, 30% of tags from the business partners who tell you what to do))
I'd much rather be the business partner doing the telling until the business jobs disappear in 10-15 years (imo, I know others here disagree)
@Hosch250 Yup, I remember the rumblings about that :) Hopefully some happy middle ground comes up for you. A dog-friendly location with a company ready to let you help them take the next step.
@IvenBach I'd do that in a heartbeat if I find a position at a comparable salary.
When I first taught myself to code I had a job kind of like that - I got it down from taking me 8 hours a day to like 15 minutes. Lots of "free time" at work.
I am trying to do the following in one module:
Replace a Public Constant in another module using a code.
Call a code which uses the updated public constant
However, it throws an error:
"Can't Enter Break Mode at this time"
Although, it still updates the public constant.
I tried pressing...
I have an Excel VBA macro that interacts with an intranet site through Internet Explorer to loop through a list of customers, open the customers profile, update a field and save the changes.
The problem I am running into is that when I save the changes to the customers profile there is a pop-up...
I have code that currently uses tab names instead of the code names. The problem is the tab names update making the code not work properly. I am looking to change the following to code names instead of tab names:
Summary 1 -> Sheet6
Summary (2) -> Sheet 7
Summary (3) -> Sheet 8
Sub HideRows...
VBA Rubberducking
VBA Rubberducking