docs.microsoft.com/en-us/dotnet/api/… is an example. Just making sure the commented code is what would be written in unmanaged C/C++ vs the managed code below.
so if you set up an say, an external declaration that involves allocating some blob of memoryforits use, golly, you betterdeallocate it when you are done amd deallocate it. Properly
using purely managed code you never even have to think about those plumbing details
but once you use interop or pinvoke. Well, you bettercode as if you were coding in unmanaged cpp
I know what it is well enough to fully understand it.
The only way to reclaim those resources is to close the application and that releases all resources within it's domain for use again.
_Worksheet Interface states: "This is a primary interface in a COM coclass that is required by managed code for interoperability with the corresponding COM object."
What is a primary interface?
Is it just kind-of-sorta like an adapter in the sense that _Worksheet Interface talks with COM and Worksheet Interface talks with .NET?
I'm trying to connect all these dots I've heard about in order to understand the bigger picture and not just be limited to VBA for add-ins. I'd much rather create an add-in using VSTO/C# and keep expanding my knowledge.
hmm... maybe 1/3rd of the way through major rework of the menu \ toolbar system. Many, many things are broken, so I thought I'd run the tests... no red.
I know its kinda UI, which is kinda not testable, but... none?
@IvenBach FWIW, knowing what I know about VSTO, I probably would not use it. Yes it is convenient but the distribution is massively complicated and bloated. It also hides the plumbing details which gets in the way of learning.
' get the clipboard data
' magic code for is for early binding to MSForms.DataObject
With CreateObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
.GetFromClipboard
strData = .GetText
End With
@MathieuGuindon wouldn’t there be any meta discussion for allowing some bots to work for some languages in Stack Exchange which we could have RD as a test.
oh right terms of service so it’s a no no. So that leaves the web page or a fully functional api that something could plug into us for a reasonable response.
System.Windows.Data Error: 2 : Cannot find governing FrameworkElement or FrameworkContentElement for target element. BindingExpression:(no path); DataItem=null; target element is 'DataGridTemplateColumn' (HashCode=17322790); target property is 'SortDirection' (type 'Nullable`1')
System.Windows.Data Error: 5 : Value produced by BindingExpression is not valid for target property.; Value='False' BindingExpression:Path=EmptyUIRefreshMessageVisibility; DataItem='CodeMetricsViewModel' (HashCode=34368455); target element is 'TextBlock' (Name=''); target property is 'Visibility' (type 'Visibility')
System.Windows.Data Error: 6 : 'ObjectSourceConverter' converter failed to convert value '<null>' (type '<null>'); fallback value will be used, if available. BindingExpression:Path=SelectedItem; DataItem='ComboBox' (Name='ChosenFontSize'); target element is 'MenuItem' (Name=''); target property is 'FontSize' (type 'Double') NotSupportedException:'System.NotSupportedException: DoubleConverter cannot convert from (null).
at MS.Internal.Data.DefaultValueConverter.ConvertHelper(Object o, Type destinationType, DependencyObject targetElement, CultureInfo culture, Boolean isForward)
@mansellan - notes on parsing FRM: //VB6 Form Structures - https://msdn.microsoft.com/en-us/library/aa241723(v=vs.60).aspx
// Known Property Values // float - eg: PropertyName=-1.450 'Some Comment // int - eg. PropertyName=-100 'Some Comment // bool - eg. PropertyName=-1 'True - Any non-sero value is evaluated as True, comment is True/False but ignored // string - eg. PropertyName="""Delimited quotes"" included!" 'Some Comment // string - eg. propertyName=$"" '$ type hint is optional, empty strings alre allowed
@mansellan - snippet for reading VBA FRX header, and extracting FRX compound binary format document:
Console.WriteLine("Opening Sample1.frx file...");
FileStream openDocStream = new FileStream(docpath, FileMode.Open);
BinaryReader br = new BinaryReader(openDocStream);
int magic = br.ReadInt32();
int streamSize = br.ReadInt32();
int top = br.ReadInt32();
int left = br.ReadInt32();
int height = br.ReadInt32();
int width = br.ReadInt32();
Console.WriteLine("{0} : {1}", "Magic", magic);
@mansellan - hint: strip the first 24 bytes from the FRX file, in a hex editor, and you can then browse the streams and storages in the resulting compound-document using 7-zip.
@mansellan, obviously the VBA version of FRM files has a binary refererence (filename, offset for the FRX file) but it's unclear how the VBE's parser knows the layout of the header and binary content, other than if the property name is hard-coded into the parser and the VBA VBE just handles it.
But it's unclear how the VB6 VBE parser knows the header size for properties that might be arbitrarily named. For example, if I have a 3rd-party control that must persist a binary property, presumably the VBE must ask that the control serialise/deserialize itself. Maybe it's time to read The object that came in from the code again, to fully understand that mechanism.
I think that's the closest thing to documentation, other than buying the author's old books, that exists anywhere online.
3rd party controls in VBA, are persisted inside the FRX, but I didn't ever get past handling the basic controls. Maybe there are some hints in the OFORMS document and/or the article linked above. BTW, that article should be (is?) linked to in the RD wiki.
@MathieuGuindon / @mansellan IIRC, the RootStorage question I posted on CR, didn't reflect the CreateOnStream method, with a suitably read-only argument. If you run into strange errors while trying to close a RootStorage or Stream, be sure that all of your streams, BinaryReaders and RootStorage objects are opened read-only.
@mansellan TBH, was nice to have the IDE open, but alas energy levels were depleted quickly.
I had a small VBA project, pre-COM-collector, that scraped the Object Browser using send keys. If I can find it, I'll try to post it to GitHub. It's great at extracting the libraries, classes, members, signatures and help texts for a project.
It obviously skips the interfaces, and doesn't know about other things that the Com collector does, but it's useful for, say, extracting all of the name value pairs of an enumeration. And it's a useful way of auditing which members the OB does make visible, and how.
Absolutely! Let's just optimize this smelting layout before I go to bed. - 3 hours later, at the opposite end of the factory: What have I been wanting to do again?
install steam. get a steam account. buy the game on steam (or somewhere else you get a steam key). If bought externally activate the key on steam. Install the Game. Play
Yeah... I've managed to avoid most games over the last couple of years. I tend to get sucked in (which is the goal, I know) and ignore other stuff. A few quick games of MS Solitaire is one thing. Something in depth and absorbing tends to keep me up all hours and, well, that's not always good.
Hey, @this... I've had logging set to Trace for ages. I just discovered that when I installed .4124 (on 12 Nov, I guess), my logging was turned off:
2018-11-12 12:34:28.1496;INFO-2.2.0.4124;Rubberduck.Common.LogLevelHelper;Minimum log level changing from Trace to Off;
@FreeMan Max observed the same thing. Seems to me that when a new version is installed and the config XML doesn't have the attribute, it behaves as if you never edited the logging level.
Interesting, I set it to Trace and was immediately rewarded with this in a freshly created log file:
2018-11-20 08:25:42.0544;ERROR-2.2.0.4175;Rubberduck.UI.ToDoItems.ToDoExplorerViewModel;System.Runtime.InteropServices.InvalidComObjectException: COM object that has been separated from its underlying RCW cannot be used.
Woot! just got my home-use Office purchase email just in time to get the new lappy!
Funny, though, the use of "estimated":
I guess that's the most correct description of pricing, as something's value is really only what the purchaser is willing to pay for it. (Or the value the purchaser sees in the item if forced to pay more.)
I'm getting a false-positive `Object variable '{x}' is assigned without the 'Set' keyword` inspection (#4318). Selecting the `Ignore once` quick fix is now non-functional (i.e. does nothing visible) and generates a stream of errors in the log.
This might be due to the fact that it's a false positive inspection result #4318. There was a fix for #4320 that seems to be working OK, but this one isn't.
Would it be possible to avoid the reparse after applying an Ignore Once quick fix by incrementing a row-count somewhere in the parse tree so that everything is bumped forward exactly 1 row in that module?
It would need to take into consideration that sometimes there may already be an '@ignore on the line modified so it wouldn't increment the row count.
@this also different usage terms. Pro-tip - buy O365 during Black Friday weekend at a discount (it can be a 3rd party seller), apply the code to your account, and if you're confident you'll be using Office 12 months from now, apply more codes, as they stack and you can lock in the discount/tax deductions now - up to 3 years of stacking IIRC.
But yes, the Office Home Use Program is a great perk, while you stay at the company. Some companies offer Office mac, Visio and Project under the same program. And if you've looked at the cost of Visio/Project, they're a really good thing to get through the Home Use Program
Networking question: I have a lame ISP issued DSL modem/router, but I can't get my own to connect to my ISP. So I'm hoping to just disable the DHCP server on the ISPs modem, connect my router to the ISP modem, and enable DHCP server on my router, and reboot both. Do I need to also change the DNS/NAT settings my router, or should those still apply?
@M.Doerner don't forget you'll need a 64-bit host VM too.
@ThunderFrame RE: the question about networking - TBH, I never tried this and it doesn't feel right. The issue is that your modem/router has the output port. I assume it also has 4 other ethernet ports. If you turn it into a dumb switch, how will it know how to route the output port to your router?
I've done it the other way, convert the router into a switch (primarily by turning off the DHCP) so that there was only one router/DHCP server in the network but the routing was always with the one that had the outgoing connection.
I have a script that takes manager names in Sheets("Mgrs") and extracts the employees that fall under each manager in Sheets("Retail Sharepoint File-Merge"). Once it finds the managers employees, it prints the array to a new worksheet and formats it and saves it based on the values I lay out.
O...
Private Sub Txtforename_Change() Dim foo As Range Set foo = [A1] foo.Set Font = [A1].Font End Sub
The `Set` keyword is being inserted just before the assigned variable - which is fine *when the assignment target is a variable*.... it needs to be inserted before the first token of the `LetStmtContext`.
You'd think Ivanka would've learned from Clinton's fiasco.
Man, politicians these days...
Now, when I was a kid... (lol, not really.)
Oh wow. The Kingston Trio is hilarious.
Listening to a song about different groups that are trying to start wars with each other (France/Germany/Poland, South Africa/Netherlands, etc.). And it goes "and I don't like anyone very much!".
The fix is to walk the `Context` up to the parent `LetStmtContext`, determine if a `LET` token is present, then either insert the `Set` token or replace the `Let` token - something like this:
```csharp var letStmt = result.Context.GetAncestor<VBAParser.LetStmtContext>()
> The `NumberPicker` custom WPF control isn't working properly at the moment; the value remains internal to the control and never makes it to the ViewModel property it means to bind to.
This is currently affecting smart concat settings, for which the maximum number of line continuations can't be modified through the settings UI.
@FreeMan There's this simulator called Rubberduck. The reviews I've read about are really positive for it. Tons of achievements you can unlock, and a thriving community. Best part is it's not pay-to-win and you can progress at your own rate.
7
The part I like best is the co-op mode where others can carry you through parts you're bad at.
Range being unqualified is referring to the ActiveSheet. If that's not the With sheet, error 1004 is thrown. This is one of the ~80 code inspections Rubberduck can warn you about. — Mathieu Guindon40 secs ago
@NeepNeepNeep to each his own: Access forms being document modules with a designer managed by the host application rather than the VBE, then having a default instance like MSForms forms, and managed like global state in some magical Forms collection, and then shown with yet another global-magic DoCmd API, gives me similar feelings ;-) — Mathieu Guindon5 secs ago
@DarrenBartrup-Cook In the code-behind for Sheet1, doing Range(Sheet2.Cells(1,1) = 42 throws error 1004. Same in the code-behind for ThisWorkbook, and ditto in a standard module. In the code-behind for Sheet1, doing Range(Sheet2.Cells(1,1), Sheet2.Cells(2,1)) = 42 throws error 1004, but works in ThisWorkbook and in a standard module. You know what, IMO that's knowledge that's dangerous to share. Qualify your ranges, period - then your code will work regardless of where & how it's written. ;-) — Mathieu Guindon14 secs ago
"qualifying ranges isn't always needed" - except, you can never tell just by looking at a SO question
still, #TIL one vs. two parameters changes something. damn that API is borked.
I have a script that takes manager names in Sheets("Mgrs") and extracts the employees that fall under each manager in Sheets("Retail Sharepoint File-Merge"). Once it finds the managers employees, it prints the array to a new worksheet and formats it and saves it based on the values I lay out.
O...
VBA Rubberducking
VBA Rubberducking