[retailcoder/Rubberduck] Hosch250 pushed commit 44137a34 to next: Partial source control localization. @Rubberduck needs to pull this so he doesn't have merge conflictions.
Also, you have to check all the references and declarations before you return to get the one in the tightest scope, not declarations first, then references.
Because it would return Sub A that contains a reference to Sub B, when your cursor is in the reference to Sub B.
[retailcoder/Rubberduck] retailcoder pushed commit b6b4d5eb to next: fixed NRE in ReorderParametersRefactoring, swapped VBE for IActiveCodePaneEditor in presenter factory constructor; factory now returns null if there's no active selection (IRefactoring
[retailcoder/Rubberduck] Hosch250 pushed commit fb730409 to next: More localizations, @Rubberduck, @ckuhn2013 z-strings need to be translated, @Simon @zomis @Mat @retailcoder
@Harish Your answer was removed for a couple reasons. First, you did not provide a review, and second, you said "Please provide your feedback on my updated code." A self-answer would have perfectly acceptable if you provided it in the form of a review, specifying how your new code was better than your old code; however, you just posted your new code with a comment that it is your updated code. Also, we do not write reviews on answers, but on questions. Because there were no answers to this question, rolfl posted your new code to your question, instead of directing you to post another question. — Hosch2501 min ago
Also, I am getting an error when I try to compile the thing.
> Error 10 The command "xcopy /y C:\Users\hosch\Documents\Visual Studio 2013\Projects\MattsDuckie\Rubberduck.UnitTesting\bin\Debug\Rubberduck.UnitTesting.tlb C:\Users\hosch\Documents\Visual Studio 2013\Projects\MattsDuckie\RetailCoder.VBE\bin\Debug\" exited with code 4.
Sorry for spelling your name wrong, if I change it, I need to run the TLB again, and I'm too lazy.
> Unit testing "works", in the sense that modules and methods can be added, and executed.
The problem is that the `AssertClass` throws an exception whenever VBA code uses it - it *looks* like a registration issue, but everything I've tried so far didn't get it to work.
We may have to fold `Rubberduck.UnitTesting` back into the main dll.
SELECT DISTINCT
dp.DPStream
, sku.SkuNumber
, sku.Category
, CStr(prod.ProductId)
, CStr(prod.WINProductId)
, prod.WINDescription
FROM (StreamSKUs AS dp INNER JOIN SKUs AS sku ON dp.SkuNumber=sku.SkuNumber) LEFT JOIN CategoryProducts AS prod ON prod.Category=sku.Category
ORDER BY sku.SkuNumber;
@RubberDuck easy, could be just my build - I could have sworn Assert worked with just copying the tlb... but now that I think of it, it might not have... ugh. I don't know anymore!
I have this Excel/VBA code and here is what it does
1. I have 3 sheets, where first sheet has two columns that will be used (A,C)
2. 2nd Sheet is just the raw data file that will be imported from external source
3. 3rd sheet is the final output.
4. Column A in the first sheet is "Raw Column Headi...
@Phrancis yeah... but I'd like it not to be because of my code ;-)
this parses:
Dim target As Range
Set target = wsMain.Cells(Rows.Count, dest.Column).End(xlUp)
wsImport.Range(source.Offset(1), wsImport.Cells(Rows.Count, source.Column).End(xlUp)).Copy target(2)
Oh! But they are important! Otherwise, how do we know that you don't have an XY problem?? Anyway, .Net doesn't need the "Trust Access to VB Project..." stuff, so it's possible that accessing it via COM Interop with C++ would work just as well. Worth a shot maybe. — RubberDuck16 secs ago
Worksheet != Workbook
I don't know of any way to create worksheet-local functions.
In VBA to expose functions you need a standard module (.bas) without the Option Private Module option set, exposing a Public Function - that function is usable in every worksheet of the workbook that's containing...
Oh! But they are important! Otherwise, how do we know that you don't have an XY problem?? Anyway, .Net doesn't need the "Trust Access to VB Project..." stuff, so it's possible that accessing it via COM Interop with C++ would work just as well. Worth a shot maybe. — RubberDuck1 hour ago
Maybe a silly question, but why would you need to dynamically create the function to begin with? Why can't you just embed the function before distributing the workbook? — RubberDuck9 secs ago
You mean like this? Michael, I'm afraid that VSTO is the way to go here, whatever your internal policies about loading .Net are, it's the sensible solution and the right technology for the job. Good luck mate. — RubberDuck4 mins ago
> When the user adds a parameter to a reference, ask them if they would like to add the parameter in the method declaration if the parameter does not exist.
Worksheet != Workbook
I don't know of any way to create worksheet-local functions.
In VBA to expose functions you need a standard module (.bas) without the Option Private Module option set, exposing a Public Function - that function is usable in every worksheet of the workbook that's containing...
VBA Rubberducking
VBA Rubberducking