@Hosch250 not sure if it's appropriate there but this is what I'm talking about - useful for automatically maintaining RD's GH pages: github.com/lijunle/Vsxmd
since it's a build task, it might actually belong on the RD project, not RD web project
> If Rubberduck DLL's are built for .NET Framework, then Core won't work. If you can re-target them to .NET Standard, then Core will work fine. (We've experimented with this a lot at work.)
> The website will have to be .NET Framework, because Rubberduck is Framework. Standard isn't really a runtime, it's an SDK target, so if you target Standard you cannot use anything from Framework, even if it runs on Framework. (Does that make sense?) Standard doesn't have appropriate AppDomain stuff to do it dynamically, either.
> This "feature" is beyond incredibly dumb. We use Excel to export serial numbers from our reporting application to a spreadsheet so users can manipulate the data as they see fit.
The serial numbers are a mix of pure alpha, pure numeric or alphanumeric mix.
So when they export and there is a long serial number that is purely numeric, it converts those serials to super dumb and unhelpful scientific notation.
There is practically zero desire for this. "Scientists" who might find scientific notation useful account for less than 1% of the total workforce.
Mind, I agree that the feature is dumb. But calling them "scientists" with the scare quotes is a bit too far, I think.
@Hosch250 The only "weird" thing about that is Standard cannot reference Framework or Core, but it can run on Framework and Core.
You can reference Standard from Framework or Core as well.
Anyway, good luck, let me know if you need any help. We just did a huge .NET Core push for work (by 'we' I mean 'I'), so if you want to try to move it to Core, or move part of it to Core, I'm sure I can help out there. (Or with the other stuff.)
"ooh, we're using floats. I guess we should hide them.... Oh, I know! Scientific notation! And I suppose we could chop the leading zeroes while we're at it. Nobody needs it."
Hey Blackhawk - I've tweaked this code a bit and uploaded it on GitHub, and I don't know if you saw Tim Hall's VBA-Blocks, but I think it would be awesome to have a StringBuilder class available through a nuget-like package manager for VBA (and Rubberduck might eventually craft a UI for it, so packages for a project can be add/updated/maintained, all in the VBE). Would be awesome if you could contact Tim to agree with what I've done with your code (or I can take down that repository if you prefer) - LMK! — Mathieu Guindon13 mins ago
there aren't 20 ways to do this: you can't have a Dictionary class that isn't VBA-Blocks' Dictionary class in your project if you're going to use VBA-Blocks' Dictionary package
Is the issue with the changepivottablecache line?
I have tried to this workbook, but I am able to execute the line to refresh the table.
I have looked at several fixes online but none work as expected.
Dim Data_Sheet As Worksheet
Dim Pivot_Sheet As Worksheet
Dim StartPoint As Range
Dim DataRan...
Dim cache As PivotCache
Set cache = Pivot_Sheet.Parent.PivotCaches.Create(xlDatabase, NewRange)
Pivot_Sheet.PivotTables(PivotName).ChangePivotCache cache
^ish
Is there already a feature request for redundant named arguments?
well the thing is that IMO in this case it's perfectly clear & warranted what null stands for, i.e. "don't process the keystroke", and there's no way in hell it could ever lead to a NRE. spending the effort to refactor it all to get a bool instead, would give exactly zero benefit (again IMO), since in case of unexpected/buggy behavior you'd just get a false instead of a null object, and wouldn't be in any better position to know what happened than if you hadn't refactored
I thought Access (for example) was one project per session? The standalone project was just a subset of what vb6 does brought into an expensive office sku.
how you will add the other project does differ from host to host but I think by definition, if an office host can do add-in, it must do multiple projects.
that's why I think that in theory if someone got their grubby paws on the Office developer edition from 2000/2002, and reverse engineered so that we can then compile a new binary file taking in the VBA code, we can then build DLLs that can be loaded by any VBA host using code written in VBA.
@mansellan it can build mta application but itself runs as MTA?
Is the issue with the changepivottablecache line?
I have tried to this workbook, but I am able to execute the line to refresh the table.
I have looked at several fixes online but none work as expected.
Dim Data_Sheet As Worksheet
Dim Pivot_Sheet As Worksheet
Dim StartPoint As Range
Dim DataRan...
VBA Rubberducking
VBA Rubberducking