|
what is the formula of excel to calculate several numbers and mem temp compare if the sum is equal or not, if the sum is equal then it is variate if not to increase to the next number
|
|
|
|
|
|
thank you
I said as following
789944 45416 664545 6654646 666666 6464664 6668 12369
835360 = 789944+45416 or 789944+664545 or 6654646+12369 or ..........
|
|
|
|
|
Message Closed
modified 3-Jun-20 9:16am.
|
|
|
|
|
Well I already suggested that two years ago, so why are you telling me?
|
|
|
|
|
Well, where else is he supposed to push his spam links? 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
|
Hello everyone, my program works when running(.exe file) and viewing my report on the location where the project is initially created. But when I copy and paste the whole project folder to a USB device..it fails to view the report. (I hope I was clear enough  )
Here is the error I'm having
************** Exception Text **************
System.ArgumentOutOfRangeException: StartIndex cannot be less than zero.
Parameter name: startIndex
at System.String.Remove(Int32 startIndex, Int32 count)
at docutracker.frmReportView1.fillreport1() in C:\Users\josephkikoy\source\repos\DocumentTracker\docutracker\frmReportView1.vb:line 14
at docutracker.frmReportView1.frmReportView1_Load(Object sender, EventArgs e) in C:\Users\josephdegorio\source\repos\DocumentTracker\docutracker\frmReportView1.vb:line 59
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.7.2671.0 built by: NET471REL1LAST
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
docutracker
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Release/docutracker.exe
Can you help me how to resolve this issue?
Best regards,
tacbanon
modified 17-Jun-18 7:08am.
|
|
|
|
|
tacbanon wrote: System.ArgumentOutOfRangeException: StartIndex cannot be less than zero.
Parameter name: startIndex
You have an index to an array or list that is too large or too small. Check the code at the line mentioned in the error message. If necessary use your debugger to see exactly which variable is causing the problem.
|
|
|
|
|
Hi,
I need someone who uses/used Visual Basic to answer a few questions as an "interview" for a class. Respond if willing.
Thanks!
|
|
|
|
|
Willing.
Be carefull what you wish for though 
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Hi
The script shown at the bottom creates a subfolder in "C:\Downloads" and moves files that are within it all into it after I named it .
What it is that I already have subfolders within the folder and when im running command its also merging the subfolders that I have alreay created too.
I may be wrong but believe that the line below is causing the issue but donno what to put in. I think that its tellling it for each object in the folder to merge but as mentioned I only need files merged and not the folders. They just need to be left there and do nothing with them.
Am I right and if so what do I need to prevent it from merging subfolders already created.
Any ideas?
<pre>On Error Goto 0
For Each objFile In objDLFolder.Files
objFSO.MoveFile objFile.Name, strNewFolder & "\"
The original script below
Option Explicit
Const strDLFolder = "C:\Downloads"
Dim objFSO, objWShell, objDLFolder, strNewFolder, objFile
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objWShell = CreateObject("WScript.Shell")
If Not objFSO.FolderExists(strDLFolder) Then objFSO.CreateFolder(strDLFolder)
objWShell.CurrentDirectory = strDLFolder
Set objDLFolder = objFSO.GetFolder(strDLFolder)
If objDLFolder.Files.Count = 0 Then WScript.Quit
Do
Err.Clear
strNewFolder = InputBox("Folder Name", vbLf & "Enter the name of the folder to be created:")
If strNewFolder = False Then WScript.Quit
On Error Resume Next
objFSO.CreateFolder strNewFolder
Loop While Err.Number <> 0 Or Not objFSO.FolderExists(strNewFolder)
On Error Goto 0
For Each objFile In objDLFolder.Files
objFSO.MoveFile objFile.Name, strNewFolder & "\"
Next
objWShell.Popup "All files moved.", 0, "Done", vbInformation Or vbSystemModal Or &h00040000&
objWShell.Run "explorer.exe /select,""" & objFSO.BuildPath(strDLFolder, strNewFolder) & """"
Next
|
|
|
|
|
I have not used FSO, but it is quite possible that the For Each statement returns a full list of all objects, including files and subfolders. You may need to check the properties of each returned object before doing the copy.
|
|
|
|
|
In a vb.net 2010 desktop application, I added an app.config file to the application 2 years ago. I did not so I can point to different directly paths without needing to recompile the application. This change worked at that time.
I have not needed to change the application until recently.
Now I actually have to recompile the application so the app.config file changes will be picked up.
Thus can you tell me what I can do to the application so I can change the app.config file without needing to recompile the application?
|
|
|
|
|
Does you code actually look for a setting in the app.config file? What does that code look like?
|
|
|
|
|
The code in the application looks like the following:
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
frmMain.GlobalForm = Me
Dim strUserName As String = ConfigurationManager.AppSettings("NameofUser")
If strUserName = "ANN" Then
Dim strDirectoryPath As String = ConfigurationManager.AppSettings("File_directory_path")
If Not (Directory.Exists(strDirectoryPath)) Then
Application.Exit()
Exit Sub
End If
Else
Dim strDirectoryPath2 As String = ConfigurationManager.AppSettings("File_directory_path_KARON")
If Not (Directory.Exists(strDirectoryPath2)) Then
Application.Exit()
Exit Sub
End If
End If
The code in the app.config file looks like:
<?xml version="1.0"?>
<configuration>
<system.diagnostics>
<sources>
<!-- This section defines the logging configuration for My.Application.Log -->
<source name="DefaultSource" switchName="DefaultSwitch">
<listeners>
<add name="FileLog"/>
<!-- Uncomment the below section to write to the Application Event Log -->
<!--<add name="EventLog"/>-->
</listeners>
</source>
</sources>
<switches>
<add name="DefaultSwitch" value="Information"/>
</switches>
<sharedListeners>
<add name="FileLog" type="Microsoft.VisualBasic.Logging.FileLogTraceListener, Microsoft.VisualBasic, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL" initializeData="FileLogWriter"/>
<!-- Uncomment the below section and replace APPLICATION_NAME with the name of your application to write to the Application Event Log -->
<!--<add name="EventLog" type="System.Diagnostics.EventLogTraceListener" initializeData="APPLICATION_NAME"/> -->
</sharedListeners>
</system.diagnostics>
<startup><supportedRuntime version="v2.0.50727"/>
</startup>
<appSettings>
<add key="NameofUser" value="ANN"/>
</appSettings>
</configuration>
|
|
|
|
|
It's not entirely clear what you're doing or what you expect.
Any setting you want can be placed into the app.config appSettings section and loaded with an appropriate call to ConfigurationManager.AppSettings("name") to get the setting of that name.
The app.config file is NEVER compiled into the application. It must reside in the same folder as the .EXE that is loading it.
In your code snippets, you try to get settings called "File_directory_path" and "File_directory_path_KARON", but these never show up in the app.config file so the values returned for those names will be null, not any string value.
When you change the setting in app.config, the new setting will be loaded on the next call to retrieve that setting in the code.
|
|
|
|
|
I did not show the values in app.config file for "File_directory_path" and "File_directory_path_KARON",
since I just wanted to show you an example. I know what the code is supposed to do by it is not working. The app.config file will not let me change the values outside of the application. The file is locked.
Once a user signs on to their computer, I try to change the values in the app.config file. The permissions are locked. The network people say that the user and I have all the rights (permissions) that are needed. I open up the app.config file in notepad in the users computer and the values are not saved. Do you know what else could be wrong so I can not change the permissions. I install the application using the old setup and deployment project that is in visual studio.
|
|
|
|
|
If the app isn't running, the only other common possibility is that the executable (and the config file) are under Program Files, which is READ ONLY to everyone on the machine, except admins. If you're an admin on the machine and can't understand why when YOU try to save the changes to app.config, it's because you have to run Notepad as an administrator. (Search for notepad.exe, right-click it, pick Run as administrator..)
If you're putting settings in a file that needs to be written to by your app or even Notepad, put them in a file under C:\ProgramData\appName\...
You can then modify the code to load the settings from that path instead of from under Program Files. See this[^] for examples.
|
|
|
|
|
In the bin directory, there is a runtime config file called 'programname.exe.config'. I do not deploy this when I deploy the application. Do I need to include the 'programname.exe.config' as part of the deployment? if so, when the application is only a user's computer, would I change the 'programname.exe.config' file and/or the app.config file in notepad?
|
|
|
|
|
|
Hello .... Please someone help me out. I want to insert new table in ms word from vb.net application, I use bookmark to define the range but it still give error "the range cannot be delete", below is my code.
Public Sub invoicePrinting1(ByVal strBasePath As String, ByVal userid As String)
Dim oWord = New Word.Application With {.Visible = False}
Dim oDoc As Word.Document = oWord.Documents.Open(strBasePath)
Dim pos, len As Integer
Dim reg As Regex
Dim bookmarkName As String
Dim rng As Object
Dim search As String = "@@Item_List1@@"
Dim dgv As DataGridView = printbox.DGVacct
Dim headers = (From ch In dgv.Columns
Let header = DirectCast(DirectCast(ch, DataGridViewColumn).HeaderCell, DataGridViewColumnHeaderCell)
Select header.Value).ToArray()
Dim headerText() As String = Array.ConvertAll(headers, Function(v) v.ToString)
Dim items() = (From r In dgv.Rows
Let row = DirectCast(r, DataGridViewRow)
Where Not row.IsNewRow
Select (From cell In row.Cells
Let c = DirectCast(cell, DataGridViewCell)
Select c.Value).ToArray()).ToArray()
Dim table As String = String.Join(vbTab, headerText) & Environment.NewLine
For Each a In items
Dim t() As String = Array.ConvertAll(a, Function(v) v.ToString)
table &= String.Join(vbTab, t) & Environment.NewLine
Next
table = table.TrimEnd(CChar(Environment.NewLine))
Clipboard.SetText(table)
' keyword that you want to search
reg = New Regex(search)
' find the text in word file
Dim m As Match = reg.Match(oDoc.Range.Text, 0)
pos = m.Index
' start is the starting position of the token in the content...
len = search.Length
' select the text
rng = oDoc.Range(pos, len + pos)
bookmarkName = "MyBookmarkName"
oDoc.Bookmarks.Add(bookmarkName, rng)
Dim tdRange As Word.Range = oDoc.Range(0, pos)
With tdRange
.Collapse(Direction:=Word.WdCollapseDirection.wdCollapseEnd)
.InsertParagraphAfter()
.Collapse(Direction:=Word.WdCollapseDirection.wdCollapseEnd)
End With
Dim oTable As Word.Tablespoons = oDoc.Tables.Add(oDoc.Bookmarks.Item(bookmarkName).Range, items.Count + 1, headers.Count)
oTable.Range.Paste()
oTable.Range.Font.Size = 9
'make the first row bold, fs 14 + change textcolor
oTable.Rows.Item(1).Range.Font.Bold = &H98967E
oTable.Rows.Item(1).Range.Font.Size = 10
oTable.Rows.Item(1).Height = 20
oTable.Rows.Item(1).Range.Font.Color = Word.WdColor.wdColorWhite
oTable.Range.AutoFormat()
'change backcolor of first row
oTable.Rows.Item(1).Range.Shading.Texture = Word.WdTextureIndex.wdTextureNone
oTable.Rows.Item(1).Range.Shading.ForegroundPatternColor = Word.WdColor.wdColorAutomatic
oTable.Rows.Item(1).Range.Shading.BackgroundPatternColor = Word.WdColor.wdColorGray25
'set table borders
With oTable
.Columns(1).SetWidth(oDoc.Application.CentimetersToPoints(wd(4.3F)), Word.WdRulerStyle.wdAdjustProportional)
.Columns(2).SetWidth(oDoc.Application.CentimetersToPoints(wd(10.5F)), Word.WdRulerStyle.wdAdjustProportional)
.Columns(3).SetWidth(oDoc.Application.CentimetersToPoints(wd(4.8F)), Word.WdRulerStyle.wdAdjustProportional)
.Columns(4).SetWidth(oDoc.Application.CentimetersToPoints(wd(5.0F)), Word.WdRulerStyle.wdAdjustProportional)
End With
'set table borders
With oTable.Range.Tables(1)
With .Borders(Word.WdBorderType.wdBorderLeft)
.LineStyle = Word.WdLineStyle.wdLineStyleSingle
.LineWidth = Word.WdLineWidth.wdLineWidth025pt
.Color = Word.WdColor.wdColorAutomatic
End With
With .Borders(Word.WdBorderType.wdBorderRight)
.LineStyle = Word.WdLineStyle.wdLineStyleSingle
.LineWidth = Word.WdLineWidth.wdLineWidth025pt
.Color = Word.WdColor.wdColorAutomatic
End With
With .Borders(Word.WdBorderType.wdBorderTop)
.LineStyle = Word.WdLineStyle.wdLineStyleSingle
.LineWidth = Word.WdLineWidth.wdLineWidth025pt
.Color = Word.WdColor.wdColorAutomatic
End With
With .Borders(Word.WdBorderType.wdBorderBottom)
.LineStyle = Word.WdLineStyle.wdLineStyleSingle
.LineWidth = Word.WdLineWidth.wdLineWidth025pt
.Color = Word.WdColor.wdColorAutomatic
End With
With .Borders(Word.WdBorderType.wdBorderHorizontal)
.LineStyle = Word.WdLineStyle.wdLineStyleSingle
.LineWidth = Word.WdLineWidth.wdLineWidth025pt
.Color = Word.WdColor.wdColorAutomatic
End With
With .Borders(Word.WdBorderType.wdBorderVertical)
.LineStyle = Word.WdLineStyle.wdLineStyleSingle
.LineWidth = Word.WdLineWidth.wdLineWidth025pt
.Color = Word.WdColor.wdColorAutomatic
End With
.Borders(Word.WdBorderType.wdBorderDiagonalDown).LineStyle = Word.WdLineStyle.wdLineStyleNone
.Borders(Word.WdBorderType.wdBorderDiagonalUp).LineStyle = Word.WdLineStyle.wdLineStyleNone
.Borders.Shadow = False
.Rows.Height = 7
End With
oDoc.Save()
oWord.Quit()
oDoc = Nothing
oWord = Nothing
End Sub
|
|
|
|
|
I'm trying to figure out how to make the Ascending / Descending extension in an Order By statement in a Linq query conditional based upon a menu selection. Here's the query:
Dim fileItem = From files In itemList
Where files.Tag(0) = "file"
Order By files.SubItems.Item(indx).Text
Select files
(itemList is a List of listviewitems)
Any advice is appreciated.
Sometimes the true reward for completing a task is not the money, but instead the satisfaction of a job well done. But it's usually the money.
|
|
|
|
|
|
Not exactly what I was hunting since the menu item isn't a part of the collection. But no big thing. I finally just added code to reverse the collection if I needed it sorted in descending order.
Sometimes the true reward for completing a task is not the money, but instead the satisfaction of a job well done. But it's usually the money.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
