Search results

  1. K

    Unable to view a form in design mode in VS2013

    Herman, I'm not sure about that. Some time in the past month or two, this phenomenon has occurred in every one of our 30 .vbproj files that has a form. So we cannot view any of the forms properly now. Thanks. Keith
  2. K

    Unable to view a form in design mode in VS2013

    Hello, I am having trouble doing this currently. Previously, my VS 2013 was configured such that when I double-clicked on a form in a project, the form opened up in design mode, so that I could edit the form properties graphically. I don?t know what setting changed, but currently when I so...
  3. K

    Making a local copy of a Reference-type variable

    Hi there. Thanks for the response. I think you grasped the exact issue I am trying to deal with. The solution sounds messy and, as you say, probably requires a different approach for different object types. This is a nice-to-have feature for me. My goal was to apply the coding standard "Never...
  4. K

    Making a local copy of a Reference-type variable

    Hello, I am trying to do this, without the local copy just being a pointer to the original variable. The original variable is the following received parameter: ByVal Paragraph1 As Microsoft.Office.Interop.Word.Paragraph I want to declare a local variable: Dim Selection1 As...
  5. K

    Finding the value of a target reference within a reference field in Word

    Hello, I have the below loop that iterates through each character in a Word document. (The magic 4 is because I am interested in evaluating each four-character block of text in the document.) I am outputting CurString to the immediate Window and it is working fine until it gets to a field (such...
  6. K

    Question debug step into VB.Net from an Excel VBA function

    Hello, In previous versions of Excel, I have been successful at writing custom "=" functions in cells that called a VBA function (stored in the same .xlsm workbook as the ?=? function) that, in turn, called my Visual Basic Dot Net code. I was able to put a break on a code line in the VBA...
  7. K

    Question Calling Dot Net code directly from a custom Excel "=" function

    Hi Govert, In addition to my above question regarding using Excel-DNA with .xlsx files, I also wanted to ask you whether the Excel-DNA product can be used with Excel 2013? I downloaded Excel-DNA and tried to install it, but as far as I could tell, it does not work with Excel 2013 - can you...
  8. K

    Question Calling Dot Net code directly from a custom Excel "=" function

    Hi Govert, Thanks for your reply. Can I ask whether you need to use .xlsm files to access your own custom Dot Net code via Excel-DNA, or can you use .xlsx files? (I have a strong preference to use .xlsx rather than .xlsm files, because you can't do search and replace operations over a .xlsm...
  9. K

    Question Calling Dot Net code directly from a custom Excel "=" function

    Hello, For some years, I have been trying to convert my Excel VBA functions to Dot Net. The way I currently do this is by calling a VBA wrapper function, which then calls Dot Net code containing the real logic that I am trying to implement in the function. Maintaining VBA wrapper functions...
  10. K

    Question Creating a MatchCollection that only includes “captured” () hits

    === Thank you John, That's exactly what I needed! :) Cheers, Keith
  11. K

    Question Creating a MatchCollection that only includes “captured” () hits

    Hello, When I run the following line, the MatchCollection that is being created includes the underscore. Dim MatchCollection As System.Text.RegularExpressions.MatchCollection = System.Text.RegularExpressions.Regex.Matches(FSOFullPath, "_([A-Z]{5,5})") I am trying to figure out how to capture...
  12. K

    Wanted: "Tracked changes, Accept, Reject, Previous, Next" feature, like in MS Word

    Wanted: "Tracked changes, Accept, Reject, Previous, Next" feature, like in MS Word Hello, I am not sure if I am posting this in the correct location, but, arguably, it relates to the VS IDE, so here we are. I am looking for a product that enables a code reviewer to review, and accept or reject...
  13. K

    Question Solution-level signing certificate

    Hello again, I just read the following in MSDN, which I think is helpful regarding my original question. ClickOnce Manifest Signing and Strong-Name Assembly Signing Using Visual Studio Project Designer's Signing Page
  14. K

    Question Solution-level signing certificate

    Thanks, that's what I thought.
  15. K

    Question Solution-level signing certificate

    Hello, Is it possible to have a solution-level signing certificate, rather than one for each project in a solution? I only use these projects in one solution. We use VS 2012 and Dot Net 4.0. Thanks. Keith
  16. K

    Question Enforcing an accessibility/scope modifier in procedure declarations

    Many thanks. That's what I thought. Happy holidays. Keith P.S. If anyone knows of an appropriate tool for VB, a referral would be appreciated.
  17. K

    Question Enforcing an accessibility/scope modifier in procedure declarations

    Hello, I'd like "Bad" not to compile and "Good" to compile. Is there a switch or a way to enforce this? (It's a bit like Option Strict.) Bad Sub ProcedureName() End Sub Good Public Sub ProcedureName() End Sub Many thanks, Keith
  18. K

    Turning off the multi-select option on a List Box

    Thank you. That's clear.
  19. K

    Turning off the multi-select option on a List Box

    Hello, Is it possible to turn off the multi-select option on a List Box? I want to limit the user to selecting one item. Or...should I be using a different control? Thanks. Keith
  20. K

    Question Assigning the collection returned by My.Computer.FileSystem.GetFiles to a variable

    Hello Hip Turtle! I do understand now, but I need to use that syntax a bit to get used to it. I would have expected something like: Dim value As System.Collections.ObjectModel.ReadOnlyCollection() As String instead of: Dim value As System.Collections.ObjectModel.ReadOnlyCollection(Of String)...
Top Bottom