> The headline of the web page reads "From unit testing to **source control**, from code inspections to refactorings, programming in VBA will never be the same."
However, #3758 triggered the removal of source control (git) from the project - the recommendation is to use the Export feature and then version control the resulting file(s) or structure. Maybe changing the phrase above to read something like: "From unit testing to code export *(allowing source control with your preferred tools)*,
> Hey @GadgetSteve, thanks for reporting this - you're right: the website is terribly outdated, it desperately needs a refresher! I've transferred this issue over to the website's own repository, so it can be tracked and closed when a commit fixes it. Cheers!
@IvenBach I would gladly show you my code :-D But then, you wouldn't sleep for weeks and would have to go to rehab... :-D
2
Hi :-) Last update about merging DLL into EXE files... So in Visual studio, if you upgrade from 2.0 .NET Target Framework to 4.0 .NET Framework, there is a new field in Reference library and that is `Embed Interop Files` and that (to my understanding) embeds only that you used in your project. So I've got instead of 2100KB exe file only 315KB exe file. :-) And it works without needing to merge the Excel dll...
Assuming we do get an answer on how we can create an actual instance of a VBA object, IoC will need to be its own DLL, since it's going to be a runtime thing, rather than an addin thing
@MathieuGuindon yeah; we also will have to work out a host-agnostic way of shipping the DLL with the file. Probably take a page out of Wayne's book and embed the DLL as a base64 string & load it runtime.
or who knows, maybe we can write the IoC in .... VBA.
Thinking about it, if it's just API calls, it's probably the easiest. As long we don't have to subclass.
Dim container As RubberduckIoC.Container
Set container = RubberduckIoC.Container.Create()
container.RegisterInterface("ISomething", "Something") ' strings?
container.RegisterFactoryMethod("Something", "Create")
'..
I was thinking in the sense of create custom keywords --- write VBA+ code which then is transpiled into much more verbose VBA that calls functions, etc.
That way, the shipped product is still a vanilla VBA and will run without any special DLL, etc.
A good example is creating a logger. Right now we new up the logger instance in a bajillion places all over the RD codebase. AOP would mean we just decorate the class and at the build time, the framework automatically insert the code to create the logger for us. Therefore, we have less code at the source code level, but the output is now quite different from what we have at the source code.
Therefore, woes to anyone who try to dissemble the source code as it'll be very fugly after all the AOP insertions
That's why I'm not so enthusiastic about the idea of creating a AOP framework for VBA. It would mean we get to write less boilerplate code, yes, but it ultimately just automate the writing and hide it away. If the poor sap tries to read the postVBA....
since the AOP framework usually are expressed as something... attributes? comments? transpiled language. I don't know if others would agree but I usually see TypeScript as essentially JS's AOP framework
As long you have the framework, it might be more convenient but once shipped, well, have fun figuring out what your shipped code is really doing!
The problem with TypeScript is that you end up basically pretending you're not writing JavaScript but you are still playing with the same constraints you would face when writing vanilla JavaScript. TypeScript just does more for you and hides that in the output.
I'm having a very very difficult time making UsedRange not include a blank row at the end of my data. I've tried deleting every blank row, clearing every blank row, and even stripping the formatting from the entire sheet including my data to make it stop being included. I'm trying to save this sheet as .csv, and if I have a blank row at the end of the UsedRange there will be a ,,,,,,,,,,,, row in the csv file. Any ideas?
Even spotted a FreeMan answer while doing my homework :)
Both VBA and non-VBA answers accepted.
Problem
I'm trying to save a sheet as .csv, but because the UsedRange includes a trailing blank row, I get an unwanted row of commas in the .csv.
What I've Tried
Deleting all rows under my data
Using the eraser tool to Clear All from all rows under my d...
@MathieuGuindon Wait no I didn't - I just did it again and did your way without even thinking about it, so I must have done it your way
@MathieuGuindon Agreed on this
I've never played a video game and not been able to explain a button combo I'm using to someone, but just now for the first time did something in Excel without even being aware I was doing it :P
try removing the .UsedRange calls (I doubt that getter is side-effecting), and further editing to include the expected msgbox output and the actual msgbox output
...then again, a side-effecting property getter wouldn't be completely out of character for a VBA type library
using 5pt Arial Narrow if I wanted to fit everything I want to talk about in 20-30 pages editing it online to make it as large as I need to without fearing for my storage space :)
@MathieuGuindon I don't think that solves the problem. The problem is the need to successfully convert a ITypeInfo into a System.Type object in order to make it usable for Moq
@MathieuGuindon Figured it out, it was the formatting of the actual data range. When I clear the formatting from the data range, Ctrl-Shift-End still covers the range including the blank row, but VBA shows me that the blank row is no longer included in the UsedRange.
@MathieuGuindon I take it back, the doc itself didn't say that, just someone who linked to the doc.
The actual doc only says you may clear the formats but doesn't say deleting rows won't accomplish the same thing. I think the commenter who said that is wrong.
Actual doc comment: "reset that last cell by clearing all of the formatting that may be applied in empty rows or columns between the data and the last cell"
For the record, I am guessing there's something about Thick Box Border that probably affects formatting of adjacent rows silently.
@MathieuGuindon Exactly how I would have phrased it. Someone in the comments suggested that I check the cells for spaces. In my head, I was like "I already nuked them from orbit, don't think that's the problem." (In real life I triple-checked and thanked them for the suggestion)
I honestly don't know if an average Joe Sixpack would have known what a SCUD was prior 90s but during the Gulf war, it was hard to not hear news mentioning it - you'd think it was the bogeyman or something the way they carried on about it.
@rubberduckvba @sadukie For this particular question... not really. However, it's a super cool thing... so definately want to make a note and help others become aware. Do you have a link to it so I can add it to my notes for what I'm collecting to launch http://gotBASIC.com?
VBA is often said to be an event-driven language: a lot of worksheet automation involves executing code in response to such or such workbook or worksheet event. ActiveX controls such as MSForms.CommandButton are trivially double-clicked, and code is written in some CommandButton1_Click procedure. But how does it all work, and can we leverage this event-driven… Continue reading Everything …
Tutorial: Everything You Ever Wanted To Know About Events https://rubberduckvba.wordpress.com/2019/03/27/everything-you-ever-wanted-to-know-about-events/
FWIW: In Access, objects expose several OnXXX members but unlike what you suggest in the article, those aren't methods that raises events but rather define how to handle the event. Left blank, no event is raised. Set to [Event Procedure] string, it will raise the event to all subscribers. Set to "=<someFunction>(), it will execute whatever the named function. That is quite different thing, and AFAIK, an Access-only thing. IDK if worthwhile to note that explicitly.
I would probably add a caveat about passing ByRef parameters, particularly to multiple subscribers; you can't assume that the order of subscriber is deterministic.
Both VBA and non-VBA answers accepted.
Problem
I'm trying to save a sheet as .csv, but because the UsedRange includes a trailing blank row, I get an unwanted row of commas in the .csv.
What I've Tried
Deleting all rows under my data
Using the eraser tool to Clear All from all rows under my d...
VBA Rubberducking
VBA Rubberducking