|
I'm actually a certified professional programmer and have been developing VB/VBA solutions since VB 2....I just never delved into Excel addins so asking those who have done so seemed likea good place to start before working on a potential major change. Asking for insight from those who have gone before isn't necessarily a sign of someone who doesn't have a clue. 
|
|
|
|
|
Some of us, including myself, start our development lives in VBA/VB/Excel/Access and that is why I assumed you were a power user. So I would recommend moving to c# (many more examples on the web than VB) and database (SQL Server) and moving the solution out of Office tools to a professional platform.
Using Office as anything but a productivity tool is always going to give you grief. I have only met 1 professional Excel developer in the last decade and I was not impressed his ideas were rigid and his tools were inflexible.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
"
Will users need to install anything locally? "
Yes. I've some experience creating and deploying VSTO's. These addins are installed manually. The few ones I made were Controls (visual components with graphics in it) and some Excel Basic function extensions. You can define a Basic function in a VSTO. The sheet - or template - contains the basic code calling the VSTO. Buttons can be defined, to let the Excel create a graphics control on the sheet that is defined in the VSTO.
It works for 365. But this is not without pitfalls. The validity of a VSTO depends on the Excel version installed. If you want to use VSTO, see you standardize your users on one version of excel, before trying to distribute your VSTO. Once your VSTO is installed, it can be replaced by a newer version if needed, by manually uninstalling it, leaving Excel, entering Excel again and install the new version of the VSTO.
So, bottom line: nstead of these 130 sheets, your will worry about all these PC's that need to install your addin. An addin is not like a template on a share. It is NOT updated automatically of you correct errors in your VSTO code ! So in short, I'm afraid VSTO is not the solution to your problem. If you really want dynamic code support, use scripts instead, like Powershell or C-script. You could use Excel interop to generate sheets..
Anyway in the end this will give a version maintenance mess. What would be a solution.. is making an inventory of what you trying to visualize in these sheets, devise a data model, implement a database for all data involved. Then export views from that database and (only) visualise using VSTO. From Excel, you can access the database directly and queries are stored in the templates. Your data should reside in a central place, not in 130 Excel sheets.
And yes alas.. this is an expensive project.
|
|
|
|
|
I am observing an issue with serializing/deserializing an object using CultureAwareComparer on .Net 4.6 .
On a system with .Net 4.6, I am able to serialize into a Soap XML having
<a2:CultureAwareComparer id="ref-15" xmlns:a2="http://schemas.microsoft.com/clr/ns/System">
<_compareInfo href="#ref-22"/>
<_ignoreCase>true</_ignoreCase>
<_options>IgnoreCase</_options>
</a2:CultureAwareComparer>
but when deserializing the same on a different system having .NET 4.6, I am seeing an error 'Member name 'System.CultureAwareComparer _options' not found.
Any suggestions on what could be causing the issue?
|
|
|
|
|
Did you first try de-serializing it on the same machine where it was serialized?
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
Can a SOAP xml have ids that are not sequential?
For example, in below snippet, I have id = "ref-19" followed by id = "ref-21", is this acceptable?
<soap-enc:array id="ref-19" soap-enc:arraytype="xsd:int[2]">
<item>0
<item>0
<soap-enc:array id="ref-21" soap-enc:arraytype="xsd:int[2]">
|
|
|
|
|
That has nothing to do with SOAP. That's an application thing. It's up to the application you're calling that determines if out-of-sequence ID's are acceptable.
SOAP is just a message formatting specification.
|
|
|
|
|
I have figured out that when you base a program on Core3.1 or .Net5 you do not have all of it available to you. There are at least 2 switches you have to set to true in the csproj file: UseWPF and UseWindowsForms. Are there others? Most important, how do you know which features are turned on and which are turned off?
So many years of programming I have forgotten more languages than I know.
modified 16-Feb-21 10:29am.
|
|
|
|
|
Sounds like an alternative to the "project type". I expect (guess) you might be able to accomplish the same thing based on the references you add ... which requires knowing what dll(s) a given feature uses.
Previously, there was no explicit WPF window "class" library (project), but you could build one with the appropriate references included.
I have used Windows Forms chart controls in a WPF app; that would imply setting both switches (if they're not mutually exclusive).
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
I have discovered on other .Net calls you need both switches. Still, I think there is a lot of overlap put do not know for sure. When you look at dependencies in Project Explorer, both switches show up as the same thing.
So many years of programming I have forgotten more languages than I know.
|
|
|
|
|
This is an update of the question:
I have figured out that when you base a new project on Core3.1 or .Net5 you may not have all of objects available to you. There are at least 2 switches you have to set to true in the csproj file: UseWPF and UseWindowsForms. Are there others? Most important, how do you know which objects are turned on and which are turned off?
Go to Object browser. This is a massive list of objects. It does show what rev of framework or core most objects are in. It does not show what switch it is under. Look up a class in Microsoft docs. Again you can get an idea of the version but no mention of the switches in csproj.
These switches are in MSBuild. The only thing I can find on them are at:MSBuild properties for Microsoft.NET.Sdk.Desktop - .NET | Microsoft Docs[^]
I know it may be a difficult question. I tried posting it on StackOverflow. I never get an answer and someone keeps marking it down. There is no comment as to why. Eventually it gets closed and hidden. I have heard that StackOverflow can be arrogant. I never understood why until now.
So many years of programming I have forgotten more languages than I know.
|
|
|
|
|
It depends on what you type on the "dotnet new" command line.
If you do "dotnet new wpf", the WPF option in the csproj file is already turned on for you. The same goes for "dotnet new winforms".
It sounds like you're doing something different on the "dotnet new" command line and having to make changes to the csproj manually to convert it to a different project type.
If you want to see the list of project templates, just type "dotnet new -l".
modified 22-Feb-21 20:49pm.
|
|
|
|
|
As part of a solution we have a project that started from the Class Library template. It does not have any screens but does have some custom controls and other things that required the UseWPF and UseWindowsForms switches be turned on. There is really no template set up for this.
So many years of programming I have forgotten more languages than I know.
|
|
|
|
|
Weird, but OK. I know I know nothing of your project, but I probably would have split that up into two separate libraries, one for each type of project, but I understand there are reasons I don't know about.
There is no list of configuration "switches" (UseWPF or UseWinForms) used in csproj files that I can find anywhere.
The last-ditch effort to find those would probably be to create a new project of each template type and go look in their csproj files for what's being used.
|
|
|
|
|
i need instruction for creating simple game in .Net Core C#
|
|
|
|
|
You're not going to get any with such an incredibly vague "question".
You didn't specify anything at all about the kind of game you want to build, the rules, interaction, ..., NOTHING AT ALL.
...and you expect an answer?
The only one you're going to get is Google for ".NET Core C# game tutorials".
|
|
|
|
|
"I'm thinking of a number between 0 and 9 ..."
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
1. Learn C#
2. Learn .NET Core
3. Create a design
4. Develop the code from the design.
|
|
|
|
|
I am a great fan of Imagelistview but one thing still evades me and that is the vertical scroll value and programmatically changing it rather than using the system vertical scrollbar due to cosmetics. You can use the EnsureVisible command to bring any item into the controls view but it lacks the feel of smoothness and control. If you let the control display the normal system scrollbars then you can use them to scroll through the imagelistview smoothly. What I want to be able to do is change the VerticalScroll value without using the mouse but I cannot find any command syntax that allows you to change it or read its current value.
Any help welcome, I have asked on the devs forum but remains unaswered.
|
|
|
|
|
|
Dear All
I am sanding string to my instrument through tcpip socket protocol. String received at instrument correctly. I received string back from instrument also. but when i convert string in to hex value i get multiple Zero after my ETX (03)hex value.. can some one help me. code for your ref. is
Dim PORT As Int32 = Txtport.Text
Dim client As New TcpClient(Txtip.Text, PORT)
Dim stream As NetworkStream = client.GetStream()
' Translate the passed message into ASCII and store it as a Byte array.
Dim data As [Byte]() = System.Text.Encoding.ASCII.GetBytes(sndstr)
stream.Write(data, 0, data.Length)
' Txtrt.Text = sndstr
' data rec.
Timer1.Enabled = True
Dim Bytes As Integer = -1
Dim Buffer(1024) As Byte
Dim Message As String = ""
Dim ClientStream As System.Net.Sockets.NetworkStream = client.GetStream
Do While Bytes <> 0
Bytes = ClientStream.Read(Buffer, 0, Buffer.Length)
Message = System.Text.Encoding.ASCII.GetString(Buffer)
If Message.IndexOf("QE") <> -1 Then
' Found the end of the message...
Exit Do
End If
Loop
' Message = Message.Trim(Message.Trim(Chr(0)))
Txtrt.Text = Message
Dim ba() As Byte
Dim hexval As System.Text.StringBuilder = New System.Text.StringBuilder
ba = System.Text.ASCIIEncoding.ASCII.GetBytes(Message)
For i As Integer = 0 To ba.Length - 1
hexval.Append(ba(i).ToString("x2") & " ")
Next
RECEIVEDDATA.Text = (hexval.ToString())
I Rec. data 02 61 61 10 31 03 00 00 00 00 00 00 00 00 till the size of buffer
my end of msg. is 03 how to remove all 00 after value 03
modified 1-Feb-21 23:50pm.
|
|
|
|
|
Hi
Currently in my local machine, after i develop my net core Web API， i built an image and run my Web API in docker container
Then i open a Web browser and default to http://localhost:4200/api
I having a question
Let say i want to deploy my Web API image to other production machine and run as container as well, and i want to redefine my Web API Access URL, example
http://my-sample-web.com/api/
How can i do that's?
Is it to set it in my apps settings or in my docker file?
Hi, I would feel glad to be a membership of CodeProject, I know the site could help developer much
|
|
|
|
|
Hello, I have a request for help with how to format a text box with numbers with 3 digits with two decimal places. but will not advance until a decimal point is placed, this works with one box. but i would like to implement this on 14 text boxes in a group box. so i don't have to duplicate the code 14 times.
Private Sub RollTemp_BOTTextBox_KeyPress(sender As Object, e As KeyPressEventArgs) Handles RollTemp_BOTTextBox.KeyPress
Dim keyChar = e.KeyChar
If Char.IsControl(keyChar) Then
'Allow all control characters.
ElseIf Char.IsDigit(keyChar) OrElse keyChar = "."c Then
Dim text = Me.RollTemp_BOTTextBox.Text
Dim selectionStart = Me.RollTemp_BOTTextBox.SelectionStart
Dim selectionLength = Me.RollTemp_BOTTextBox.SelectionLength
text = text.Substring(0, selectionStart) & keyChar & text.Substring(selectionStart + selectionLength)
If Integer.TryParse(text, New Integer) AndAlso text.Length > 3 Then
'Reject an integer that is longer than 16 digits.
e.Handled = True
ElseIf Double.TryParse(text, New Double) AndAlso text.IndexOf("."c) < text.Length - 4 Then
'Reject a real number with two many decimal places.
e.Handled = True
End If
Else
'Reject all other characters.
e.Handled = True
End If
End Sub
The Text Box will have like 123.67 in it. But if you enter 123 it doesn't let you put another number in and advance until you put the (.) in and then allows you to put another number in.
Thank you
|
|
|
|
|
You can always reuse the same event handler for the different textboxes. What I would do is rename this event handler so it doesn't refer to the control by name and then point each of the relevant controls KeyPress events at this event handler. As the sender refers to the textbox that raises the event, you can refactor the method to avoid using Me.RollTemp_BOTTextBox by casting sender to a TextBox type.
|
|
|
|
|
Would you give an example please, i am not following your explanation. Would be grateful.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
