« first day (2692 days earlier)      last day (40 days later) » 

12:02 AM
REFRESH!
[Minesweeper] 68 Games Played. 63 Bombs Used. 9758 Moves Performed. 2 New Users
[rubberduck-vba/Rubberduck] 1 issues closed. 2 issue comments
[Zomis/Games] 1 issues opened. 8 commits. 2 issue comments
 
 
13 hours later…
12:54 PM
I'm having @this bizarre Git/OASIS issue. Well, bizarre to me, at least... Is this setting:
what created this directory in my git source structure?
and if so, why in the world would I have these directories in the Specifications directory?
git really doesn't seem to like me. :(
I think the last one is my fault. I think I may have dragged/dropped files there accidentally. :/
yeah, I know I'm not supposed to do that. git's been fighting me.
 
 
2 hours later…
2:52 PM
I'm losing faith in OASIS... :(
I just exported code & did a git diff. It showed a Private Sub NewMethod() (which, apparently there's a hot-key for in RD, that I've never used before, but accidentally triggered).
I went back to my Access project, deleted the method definition, then did an OASIS export, and it shows zero changed modules.
 
3:13 PM
@FreeMan stupid question: did you save the changes before exporting?
 
erm, no, actually. I didn't realize that until I went to close Access and it prompted me to save. I'm usually pretty fastidious about save early save often. But I've had a lot of distraction this morning and musta missed it.
 
kind of hard to export when nothing's changed. ;-)
reminder: ctrl + S in VBIDE is your friend
(with OASIS enabled, I mean - so that saving also exports automatically)
 
@this Yeah, I usually do that. As noted, was rather distracted today. (Mom's been here visiting. Just left a bit ago, but all the chaos of her packing, son getting up to run her to the airport, wife coming home to say goodbye, etc - chaos...)
 
Remember Mr. Mom?
 
OK, fine. Maybe it wasn't OASIS' fault, but, while it works well (possibly better than anything else? don't know haven't tried much beyond default export & RD export), it's still immensely frustrating. Coupled with my lack of git skillz is... just...
"It was him! Drive by fruiting!" Oh, wait, that was Mrs. Doubtfire my bad...
not sure I saw Mr. Mom
Wait, OASIS only exports code that was actually saved, not the code currently in the code pane?
That might just explain some of the confusion I've had...
 
3:25 PM
Lol. Michael Keaton and Sally Fields, I think. There was an episode where kids made a mess, there's plumber here, there's bug man here, and a fireman (?) and the dad just snaps due to the chaos.
@FreeMan hence the need to ctrl + S....
 
hrm... now I'm wondering how many times I've clicked the export button w/o saving first...
I am generally in the habit of ctrl-s now, but not initially.
 
Working with non-text files objects with a text-based SCC is painful.
 
yurp
 
@FreeMan do you keep the .accdb. .xlsm, etc files in your repository as well as the exported text files?
 
3:44 PM
no, just human readable text
 
4:05 PM
Yeah...just kinda taking a poll. I do...but it comes with some downsides. I elected to store them because I just end up managing copies of those files somewhere else..but that comes with some downsides as well.
 
I do keep a stripped down copy of accdb
makes it easier to build from source esp. when the accdb file contains stuff that are not easily exported as text
mind you, the actual file with all the objects & whatever is outside the repo; it's practically write-once-for-the-repo-lifetime thing
 
4:32 PM
Oh man... if it weren't for that one really crap answer...
 
Just did an experiment where I imported everything from my repo into an empty workbook. It succeeded except that some References are not restored - just couldn't compile immediately. Thought I had tried that before with no success(?)... I may have to rethink my git workflow - my biggest concern was recovering from a corrupted xlsm.
 
Yeah, that's the exact reason why you need a base file
this makes sense for Access, but I have no idea how that will work for Excel. :\
unless you can somehow recreate the sheets that represents "code" and not "data"
 
'sheets that represents "code" and not "data"'...could you elaborate?
I'm guessing Controls on a worksheet
 
well yeah, that'd be one of them. Another example would be hidden sheet that enumerates lookup values for use somewhere as a formula, and of course the formula defintions themselves
don't forget the pivottable, pivotchart, and tables, of course.
In an ideal world, those would be controlled because they don't actually contain the data but shapes the data in one way or other.
thinking about it some more, this kind of argues for having a VBA module that is responsible for building those objects.
then you can source-control that code and you'd then get the worksheets in the same shape (but not necessarily with data, of course)
In theory, someone could write an extension that could then generate the source code for those objects and thus build the VBA module to be then SCC'd. That way, you don't have to write the code which will be some bajillion lines of code
But the thing is that the extension will never be "complete" since you'd have to know how to enumerate every types of objects and its properties
 
4:55 PM
I was about to say - that vba module is way beyond my skill set.
 
Excel objects doesn't have a Properties collection, right?
 
shrugs shoulders
Note to self: work on chat markup skillz
 
if @this hasn't just gone in circles, it's not because my head isn't spinning
@BZngr bold, italics, whatever...
 
In Access it's easier because almost all objects implements the properties collection so you can easily generalize For Each Property In Whatever.Properties and write it out which makes generating text representation much easier.
You can't exactly For Each over actual members of a object.
To do that, I guess you need the typeinfo access.
which is not as simple, either but much more generalizable.
 
5:17 PM
Yay!
but seriously, how does that happen?
 
you one-upped someone else?
 
Oh, +10 for the last up vote, but rep was at 199 for the day, so rep cap limited it to +1, bringing me to 200
 
5:31 PM
an alternative way to gain 1 rep is by having something you downvoted be deleted
or at least it used to be back when you paid for downvotes with rep...
don't recall whether that's still how it works...
 
DVs still cost rep
 
6:04 PM
 
6:57 PM
 
Side note: you could explore Rubberduck, including related functionality. — BigBen 5 mins ago
@Duga - that was a quick star.
 
 
4 hours later…
11:47 PM
[rubberduck-vba/Rubberduck] 1435 stars vs. [decalage2/oletools] 1763 stars
 

« first day (2692 days earlier)      last day (40 days later) »