How can I change the value of cell B2, which is 10, to become 100? Also, I want it to be applied to a range of cells in the same column, B2:B13. How can I do that?
One more question, can I have different functions in the same spreadsheet using VBA? For example,
Cells B2:B13 the input value * 10
C...
this is just a random thought -- but ought we consider raising the abstraction level a bit more --- instead of writing the entire code directly, we should be able to invoke mini-rewriters that does one thing well.
as an example, have one rewriter that deals with creating, removing or editing a parameter. Another to create the declraation, and yet another for the call site
Then the refactoring would request the mini-rewriters as it needs, and thus we have uniform behaviors across refactorings?
but the idea is that if a refactoring needs 1) change a signature by adding a parameter, 2) update the call site, then instead of specifying all the rewriter operations, it would be doing something like Rewriter.Add(new ParameterRefactor(parameterDeclaration); Rewriter.Add(new CallSiteRefactor(callsiteDeclaration);
I'm sure my quick'n'dirty example can be improved but I think you get my idea -- the refactoring classes themselves shouldn't have to perform the mechanics of rewriting but rather simply specify what code elements needs to be changed and leave the mechanics of specifying the rewrite operations to those updaters/mini-refactoring.
I suppose we can call them "Updaters" since we already have them for attribute/annotations.
@M.Doerner when it comes time to create VB6 implementations of IRequiredBinaryFilesFromFileNameExtractor, I'm not sure that regex will suffice - I suspect (but haven't confirmed) that the set of controls that can emit a binary file reference is open-ended. At that point, would we need to consider extending the grammar with comprehension of component headers?
apologies if this is an obvious question, but... I'm not entirely sure why VB6 would need to (re)import from files for source control... the source files are already on disk. I feel like I'm missing something...
Absent IDE integration as we had previously, I can't see why not? Never tried it, but I can't see any reason why a normal git client wouldn't work for VB6.
IIRC, the .vbp file stores the full path for the included files which makes SC painful. That means for SC to be complete on VB6, one'd have to handle the updating of the .vbp... right? (that is just me asking - I assume that needs to be its own PR anyway)
Thinking about it some more, I'm still not sure what the use-case is for "Replace" in VB6. I get it for VBA, as you'd start with, say, an empty Excel doc and import everything you cloned from SC. But with VB6, the .vbp would also be in SC, so I'm not sure why you'd ever want to zero it out and then add back from the fs?
In theory, these commands shouldn't be necessary for VB6, as the source files, binary-content files and project files are already stored on the filesystem. Unfortunately, VB6 has no awareness of changes made externally. Not only does it not put filewatchers in place, it won't even check the filesystem for changes when compiling. The version in the editor is considered canonical at all times.
one thing before I go though - will need to consider what happens if the .vbp changes externally. Presumably the only recourse there is to unload and reload the entire project...
what would be pretty freakin' awesome is if we could add the missing filewatchers, and give the same "Ignore, Overwrite, Save As" thingy that modern VS does...
VBA Rubberducking
VBA Rubberducking