« first day (2223 days earlier)      last day (36 days later) » 

12:01 AM
RELOAD!
[Zomis/Games] 6 commits. 1 opened issue. 1 closed issue. 5 issue comments. 285 additions. 430 deletions.
[Minesweeper] New Users: 24, Games Played: 92, Bombs Used: 57, Moves Performed: 11471
 
 
14 hours later…
2:23 PM
Hey there, Mr. Two-Time Excel MVP (@MathieuGuindon) - Question for ya...
I've got an XLTM file that I'm going to move to our Teams site. I know that the "M" part has to go because Excel online doesn't support VBA.
I saved it as an XLTM file, but I'm not getting standard "template" behavior, either. i.e., It simply opens MyFile.xlTm instead of opening MyFile1.xlSm
Any idea how to get it to implement standard template behavior and give me a copy of the template instead of just opening the template?
So far, searches for "Excel template teams" yields things about excel templates and teams templates, but not opening excel templates from Teams.
 
2:43 PM
Seems I have to "Open in SharePoint", then from the SharePoint web site, I have to "Open in App", but even then I'm not getting the proper "template" behavior. I can do the same with my XLTM, but it won't execute the On_Open code.
#Annoyed
 
 
1 hour later…
3:57 PM
@FreeMan haven't used templates much - most people don't know what to do with them... I'd send HR a .xltx template and they'd merrily edit the template instead of using it as, you know, a template... IIUC templates need to go in a special folder, and then they show up in file/new. Not sure how that translates in a SharePoint or O365 environment.
 
:(
I've really liked them. So long as I could get someone to open it by double-clicking in Windows Explorer. I've noticed that my On_open code won't fire if they launch Excel, then File | Open the template.
 
Maybe templates are always local?
 
Dunno. The code was primarily to ensure that each one was named correctly, so I'll handle that for now while I find out if there's a way to make Teams/SP do it for me.
le sigh...
 
If you open the .xlt, then you're editing the template; you want Excel to recognize the template as such (have it listed in "my templates")
not 100% sure, but I'd think Excel gets "my templates" from some local folder
 
If you double-click myTemplate.xlTx in Windows Explorer, you'll get myTemplate1.xlSx opened up, no matter where it's stored. If you do right-click | Open from WinExp, you'll be editing myTemplate.xlTx
 
4:01 PM
interesting
it all hinges on command-line args then
 
If you open Excel, then File | Open myTemplate.xlTx, you're editing the xlTx. I think you have to do File | New | from template or something similar at which point it takes you the default template directory. For my users, they'd then have to navigate to where the template lives to open it from there.
^ Just had a brain wave to figure out the file|new|from template thing...
It seems we have some MS tech support people at our beck and call. I'll submit a help desk ticket and see if they can tell me or kick it straight to MS for an answer.
 
Sounds like a plan!
Most users don't make the difference between "I'm editing the template itself" and "I'm editing a new workbook created off a template", which is why I gave up using templates for anything at all: they just make a copy of the "template" workbook instead
 
4:34 PM
Yup, File | New | Personal and it'll pull up anything from your "personal template" directory.
but, the default template directory is a pain to find so... :/
huh... discovers he has a template from a year ago out there. has no idea why
 
4:53 PM
Worst case save the workbook as read only. Mandates they have to save a copy and can't edit the original.
 
5:25 PM
> This resources were edited/created following Rubberduck recomendations (RESX Manager)
I'll be working in further standardization (same word -> same translation) and maybe you will receive another pull request later.
 
5:42 PM
[rubberduck-vba/Rubberduck] build for commit 2c050ef2 on unknown branch: AppVeyor build failed
BUILD FAILURE!
 
@this Thanks for the link, I'll take a look - I'm actually not too worried about dealing with pointers tbh, my plan up till now was to write function wrappers in native assembler so this is definitely a step in the right direction!
 
@MathieuGuindon FWIW the behavior you get when you select a template extension is that it changes the folder path automatically, which can work against the expectation since I think most typically, we navigate to a folder we want, put in a name, then select the extension then click OK. Since it's the last step before clicking OK, the changing of folder path really messes up the expectation. At least it did for me when I was using templates.
@Greedo OK. I still am not sure how it'll work if the code is ultimately starting from VBA. In Rubberduck's case, it's a WPF dialog that ultimately enters into the VBA codebase, so there's non-basic code in the call stack to handle the End of the world. But if it's originating from VBA, the End could end that stack frame also.... like sawing off the branch you're sitting on.
 
@this I've been thinking about this since you first posted:)
 
@this that imagery is... perfection! I mean, it literally is exactly that =)
 
6:31 PM
Well, unless you're in a Looney Tunes episode (I think) where the sawing off the branch causes the tree and the ground to fall. :)
 
That said, the WinAPI sends messages to the Excel message loop, and so I think it is Excel that actually invokes the callback parameter of the WM_TIMER message. So if that callback parameter goes straight into the VBE typelib and avoids going through any VBA en-route then perhaps it could work
Not sure if that makes sense... Don't fully understand how RD is invoking stuff yet even with the code you linked
 
Possibly. You'll have to find out.
You need to first get the pointer to the hidden interfaces (it's defined in the same class I linked you, at the top).
But to get that, you need a pointer from the typelibs, which you get it using method shown here: github.com/rubberduck-vba/Rubberduck/blob/next/…
 
7:19 PM
Does anyone else use code cleanup Ctrl+K, Ctrl+E?
I've been wanting to know how to have spaces be added to for loops without having to go back and add them manually. Code cleanup does this in addition to several other helpful tasks.
 
[rubberduck-vba/Rubberduck] build for commit d0eb0791 on unknown branch: AppVeyor build failed
BUILD FAILURE!
 
@Duga gotta fix that nixed resource key
 
8:34 PM
[rubberduck-vba/Rubberduck] build for commit 200e6502 on unknown branch: AppVeyor build failed
BUILD FAILURE!
 
8:54 PM
[rubberduck-vba/Rubberduck] build for commit 5d637b1f on unknown branch: AppVeyor build succeeded
 
@Duga - yay
 
9:24 PM
[rubberduck-vba/Rubberduck] erigoni pushed commit f129c51e to next: Spanish translations
[rubberduck-vba/Rubberduck] erigoni pushed commit 2c050ef2 to next: Spanish translation
[rubberduck-vba/Rubberduck] erigoni pushed commit d0eb0791 to next: Detailed Review 1
Restore Rubberduck.Resources/Inspections/InspectionNames.fr.resx

Co-authored-by: Mathieu Guindon <retailcoder@gmail.com>
[rubberduck-vba/Rubberduck] erigoni pushed commit 5d637b1f to next: Fix Typo in InspectionNames (en cs de)
[rubberduck-vba/Rubberduck] web-flow pushed commit 06365566 to next: Merge pull request #5537 from erigoni/next
> Nice work, thanks a lot :)
 
9:58 PM
> Minor changes in the rest of the resources (not only the new keys)
 
10:15 PM
[rubberduck-vba/Rubberduck] build for commit c17416cb on unknown branch: AppVeyor build succeeded
 

« first day (2223 days earlier)      last day (36 days later) »