Search results for query: *

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

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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

Thanks, that's what I thought.

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

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.

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

Thank you. That's clear.

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

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)...