« first day (588 days earlier)      last day (2592 days later) » 

Duga
Duga
12:01 AM
RELOAD!
[Cardshifter/cardshifter.github.io] 1 commit. 3 additions. 3 deletions.
[Hosch250/VSDiagnostics] 1 commit. 18 additions. 69 deletions.
[rubberduck-vba/Rubberduck] 1 opened issue. 6 issue comments.
[Vannevelj/VSDiagnostics] 6 commits. 3 opened issues. 3 closed issues. 2 issue comments. 256 additions. 142 deletions.
[Zomis/Machine-Learning] 4 commits. 37 additions. 6 deletions.
 
ThunderFrame
ThunderFrame
12:22 AM
@Mat'sMug - So it seems the PIAs in /Lib are supporting more than one version the respective application?
 
Mat's Mug
Mat's Mug
Yeah
 
ThunderFrame
ThunderFrame
Do we need a PIA for Stdole?
 
Mat's Mug
Mat's Mug
Yup
It's there, isn't it?
 
ThunderFrame
ThunderFrame
can't see it in Libs
and while I see a VisioViewer, I don't see Visio?
or PIAs for InfoPath, Project & SharePointDesigner?
 
Mat's Mug
Mat's Mug
We don't have all these apps on our machines, if you have the PIA's you're welcome to add them and PR :-)
Actually we only need PIA's for apps that support a Run method, for unit testing to work
...or for apps for which we want to implement host-specific inspections
Like "implicit reference to ActiveWorkbook"
 
ThunderFrame
ThunderFrame
12:44 AM
How can I tell which application versions are supported by a given PIA?
 
Mat's Mug
Mat's Mug
AFAICT, we can't know. My guess is that it works because they implement the same COM interfaces across versions
 
Hosch250
Hosch250
1:03 AM
@ThunderFrame You can only add them if they are the Office 2007 PIA - otherwise, it won't compile.
If you have Office 2007 installed, you can get the PIA's from a link I posted somewhere.
 
Mat's Mug
Mat's Mug
@Hosch250 right. I remember all the back-and-forth with 2007 vs 2010 PIA's and Access & stdole stuff breaking my build after 1.22
 
Hosch250
Hosch250
You can't install them unless you have Office 2007 installed, though.
 
Mat's Mug
Mat's Mug
@Hosch250 are we breaching a license agreement of some sort?
 
Hosch250
Hosch250
No.
They just don't install unless you have Office 2007 installed.
 
Mat's Mug
Mat's Mug
And RD just hooks up whatever is installed
 
 
2 hours later…
ThunderFrame
ThunderFrame
3:12 AM
"If you embed type information from a strong-named managed assembly, you can loosely couple types in an application to achieve version independence. That is, your program can be written to use types from multiple versions of a managed library without having to be recompiled for each version.

Type embedding is frequently used with COM interop, such as an application that uses automation objects from Microsoft Office. Embedding type information enables the same build of a program to work with different versions of Microsoft Office on different computers. However, you can also use type embedd…
 
ThunderFrame
ThunderFrame
4:06 AM
seems like embedding could work for RD?
 
Mat's Mug
Mat's Mug
yup, that's what we're doing
 
ThunderFrame
ThunderFrame
OK - So the PIAs are only in the source, for prosperity?
 
Mat's Mug
Mat's Mug
lol yeah, looks like it :)
(and so anyone forking the repo could actually build the project ;-)
 
ThunderFrame
ThunderFrame
ah, I see - they're used at compile time...
 
 
1 hour later…
Mat's Mug
Mat's Mug
5:26 AM
@Hosch250 FYI there's a bug in move closer to usage when the field is an object variable (i.e. requires a Set keyword for the assignment)
I get this result: 
    Set
    Dim wbkSecondFile As Variant
wbkSecondFile = Workbooks.Open(strSecondFile)
should be: 
Dim wbkSecondFile As Variant
Set wbkSecondFile = Workbooks.Open(strSecondFile)
 
Mat's Mug
Mat's Mug
5:38 AM
Rubberduck at work:
0
A: Refactor of vba function to reduce bloat and repeated code

Mat's MugIt's not clear what FlagBag might be. If it's a class, then the variable rowFlag is used but never assigned, which could be a bug. If it's a user-defined type, ...consider making it a class, since you're passing it around as parameters. I promised I'd run Rubberduck 2.0 code inspections on your ...

 
Mat's Mug
Mat's Mug
6:35 AM
 
 
3 hours later…
Duck Exchange
Duck Exchange
9:25 AM
0
Q: Inserting and Populating Chart with Excel VBA

Jean-Pierre OosthuizenMy Code uses a data set which has been modified using another script Calculating Time Difference and then inserts and populates a Chart with that Data. Save a Macro enabled WorkBook as Book1.xlsm with a Sheet named Book1. To setup data values for testing copy the data below and paste it to cell...

vba excel
 
 
3 hours later…
RubberDuck
RubberDuck
12:41 PM
@Mat'sMug bad ass!
@ThunderFrame there're actually there so we have a reproducible build. We were suffering issues with the build server and different devs having different PIAs installed.
 
Mat's Mug
Mat's Mug
@RubberDuck lol, thanks! The ad needs 1 more vote to start being served on CR :-)
 
RubberDuck
RubberDuck
Link?
 
Mat's Mug
Mat's Mug
Woohoo! CR's first community ad is up!
 
RubberDuck
RubberDuck
Chronicles?
This one needs more votes. It's a good ad. meta.codereview.stackexchange.com/a/6543/41243
@StackCodeReview just got their first community ad and guess who it is? It's @rubberduckvba! http://meta.codereview.stackexchange.com/a/6542/41243?stw=2 https://t.co/82fEtYSxna
Tweeted by Rubberduck203 on January 15, 2016 at 12:49 PM
 
Mat's Mug
Mat's Mug
1:07 PM
@RubberDuck nice!
 
Tweeting Duck
Tweeting Duck
#CodeReview #VBA - what the ad doesn't say is, it's a #CSharp #OSS project that would love more contributors, too! https://twitter.com/Rubberduck203/status/687980043155468288
Tweeted by rubberduckvba on January 15, 2016 at 1:06 PM
 
Duck Exchange
Duck Exchange
1:28 PM
0
Q: Perform loop through process on all sheets at once

KISHOR BHOIRI have workbook having multiple sheets and having same data on it. Currently I am using macro that .autofilterand copy paste on respective sheets. I am using looping process like:- Sub SCRIPT() Application.ScreenUpdating = False Sheets("SCRIPT").Range("A3:P100").ClearContents Dim ...

vba excel time-limit-exceeded
 
 
1 hour later…
Mat's Mug
Mat's Mug
2:35 PM
What is rubberduck? Is it a tool anyone can use? — VinnyGuitara 32 mins ago
2
 
 
2 hours later…
Hosch250
Hosch250
4:09 PM
@Mat'sMug Make an issue then.
 
 
4 hours later…
Duck Exchange
Duck Exchange
8:15 PM
0
Q: Report Building (Data Retrieval, Validation, Aggregation, Business Logic, Report Building, Visual Presentation)

ZakThis: Is a data table we get from our financial platform with lots of useful information. For reference, "--" is also the string they use to denote empty values. This: Is a spreadsheet I built (and had reviewed here) to track our customers' regular income requirements. The code produce...

array data-structures vba excel
 
Duck Exchange
Duck Exchange
8:47 PM
0
Q: Good or bad practice to give function and query same name?

Martin FI have some parameterized queries in Access 2010. They are often used in VBA functions having the same parameters. In such cases, I give the query and function the same name. For example Public Function get_assignments(e_id As Long, yr As Integer, wk As Integer) As DAO.Recordset Dim db As DA...

vba ms-access
 

« first day (588 days earlier)      last day (2592 days later) »