I do feel inclined to downvote this, but will refrain from doing so. The problem is you don't have a concrete problem here. You have shown us VBA code and said "I want to do this in .Net instead", but not presented us with a particular problem you've run across in the process of porting your code. As it stands, this question is far too broad. Go give it a shot first. Come back when you run into a particular issue that you don't know how to solve. — RubberDuck5 mins ago
Your answer solved the question OP asked. His acceptance of the other answer indicates that wasn't the question he meant to ask... — FreeMan11 secs ago
Huh, doing this busted it: this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
I just copy/pasted the icon from Rename.resx to my resx.
> Error 21 The name 'resources' does not exist in the current context C:\Users\hosch\Documents\Visual Studio 2013\Projects\Rubberduck\RetailCoder.VBE\UI\Refactorings\ReorderParameters\ReorderParametersDialog.Designer.cs 148
Oh, got it.
> System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(RenameDialog));
Here's the deal...In trying to get past my fear of Class Modules in Excel VBA, I decided to create a class that is an array, then add functions (methods) for adding elements, sorting an instance, etc. Those are things I keep re-writing in normal modules as functions/subs but hope use of classes...
@Hosch250 remember the ArgListContext? calling the .arg() method will give you a ReadOnlyList<ArgContext> where each item is a parameter, presumably in the order they were parsed, so left-to-right.
your refactoring should have a Target which should be a Declaration with a DeclarationType of either Procedure, Function, PropertyGet, PropertyLet, PropertySet, Event, LibraryProcedure or LibraryFunction
This is a fun one!
I wrote some code to automatically get the next revision letter for a file by looking at the existing letter. It works, but I think there is room for improvement as far as simplifying it or making more efficient.
Our revision scheme follows ASME Y14.35, which specifies the f...
cool. the hard part will be to get the references' ArgsCallContext, and reorder each individual ArgCallContext accordingly there, again using a TokenStreamRewriter
assume Target.References has all references; if it doesn't, the bug is in the identifier resolution code.
Private Function UNCpath(ByVal DrivePath As String) As String
Dim nwork As Object
Dim NDrives As Object
Dim i As Long
Set nwork = CreateObject("WScript.Network")
Set NDrives = nwork.EnumNetworkDrives
For i = 0 To NDrives.Count - 1 Step 2
If NDrives.Item(i) <> vbNull And InStr(1, DrivePath, NDrives.Item(i), 1) > 0 Then
UNCpath = Replace(DrivePath, NDrives.Item(i), NDrives.Item(i + 1))
Exit For
End If
Next
End Function
The variable names lngX, strX, strY, and strZ are 75% Hungarian and 25% useless. I don't have a good idea of what their purpose is. You don't have to write a comment telling me that you are declaring variables; the Dim keyword is obvious enough.
You've used recursion to solve this problem, whic...
var identifier = _view.Target.Context;
var proc = (dynamic)identifier.Parent;
var argList = (VBAParser.ArgListContext)proc.argList(); // off the top of my head - refer to the grammar to confirm the correct member to call
Our whole production database server died suddenly, it appears. Nothing is working now, all having ODBC connection failures. Good thing it's TTQW. And good thing I'm not a DBA right this moment ;)
System.IndexOutOfRangeException: Index -1 does not have a value.
at System.Windows.Forms.CurrencyManager.get_Item(Int32 index)
at System.Windows.Forms.DataGridView.DataGridViewDataConnection.OnRowEnter(DataGridViewCellEventArgs e)
at System.Windows.Forms.DataGridView.OnRowEnter(DataGridViewCell& dataGridViewCell, Int32 columnIndex, Int32 rowIndex, Boolean canCreateNewRow, Boolean validationFailureOccurred)
at System.Windows.Forms.DataGridView.SetCurrentCellAddressCore(Int32 columnIndex, Int32 rowIndex, Boolean setAnchorCellAddress, Boolean validateCurrentCell, Boolean throughMou…
Here's the deal...In trying to get past my fear of Class Modules in Excel VBA, I decided to create a class that is an array, then add functions (methods) for adding elements, sorting an instance, etc. Those are things I keep re-writing in normal modules as functions/subs but hope use of classes...
This is a fun one!
I wrote some code to automatically get the next revision letter for a file by looking at the existing letter. It works, but I think there is room for improvement as far as simplifying it or making more efficient.
Our revision scheme follows ASME Y14.35, which specifies the f...
The variable names lngX, strX, strY, and strZ are 75% Hungarian and 25% useless. I don't have a good idea of what their purpose is. You don't have to write a comment telling me that you are declaring variables; the Dim keyword is obvious enough.
You've used recursion to solve this problem, whic...
VBA Rubberducking
VBA Rubberducking