Search:
Type: Posts; User: MrPumper
Search:
Search took 0.02 seconds.
-
-
I believe I have it thanks to paul from an earlier post of mine.
Not sure what the $ and {} do. but it gives me the correct answer.
oSheet.Range($"G{m}") = $"= G4 - G{n}"
-
I have been using this formula
oSheet.Range("G" & m) = "=G" & n & " - G4"
It works, but now I want to change the order and subtract the variable cell from a static cell.
This is what I tried...
-
Thanks OptionBase1, I have tried every combination except this one. It works as I wanted.
Looking back it was very simple.
-
The first 2 lines of code works, the last 2 lines with the variable n does not.
LOoking for help on using the SUM formula.
The Form1.lblRecords.Text gets no higher than 50
Dim m As String...
-
Yes jmcilhinney I agree that is what I am doing.
-
Thanks sapator that also works, here is my code
oBook.SaveAs(My.Computer.FileSystem.SpecialDirectories.Desktop + "\Handicaps.xlsx")
Thanks for your help
-
I think I found my answer.
oBook.SaveAs(Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory) + "\Handicaps.xlsx")
-
Visual Basic Net 2017 I have this file location code.
oBook.SaveAs("C:\users\pisto\OneDrive\Desktop\Handicaps.xlsx")
This is OK for the computer I wrote this for but on another...
-
Thanks for all those kind words, I appreciate it.
I am not new to programming I find anything written by Microsoft is difficult to understand.
My first programming experience was in the 1980's...
-
All I did was ask a simple question!
-
I do have some history in programming. I started when Basic was just Basic, Microsoft first Visual Basic, VB6, VB Net.
I only program occasionally for something to do, not as a profession. My...
-
Thanks that's a good explanation. You probably get my question over and over again.
I think then my best bet is to look to the forum for some answers then make my own notes for what I am doing,...
-
I have seen words like these:
Enumerable.Range
IEnumerable(Of String) In lines.Split(84).ToArray()
<Runtime.CompilerServices.Extension>
Environment.NewLine
String.Join
I have bought books...
-
Thank you all, I now have my solution
-
Yes, I have an extra line.
I added this if
If (RALN = np - 1) Then Exit For that takes care of it for now but I will need to fix it properly.
For RALN = 0 To (np - 1) Step 84 'ADDING 84...
-
The exception was thrown on this line:
StringLine &= PlayerArray(RALN + pa)
The bounds of the array is 0 to 3108
I am new at this I don't know what a System Index is, that's one of the...
-
I load the text file into an array then create the CSV file.
Run the program but it throws an Exception "SystemIndexOutOfRange: Exception unhandled Index was outside the bounds of the array"...
-
WOW I completely missed what JMC suggested it did the trick. I can't thank all of you enough for staying with me.
Now I will study it further to understand what it is doing.
Thank You
-
Shaggy Hiker
You are correct, after commenting out it was fast.
What is your suggestion?
-
I forgot to describe the CSV file size so here it is.
The CSV file has 36 lines with 44 fields in each line
-
jmcilhinney
The part of my code that is slow, is when I covert a CSV file to a Sequential file.
Here it is.
Using MyReader As New...
-
Project uses Windows Forms and part of the code takes about 7 seconds to complete, that is a long time for a user to wait.
Is there a way to have a message stay on while the code runs then...
-
I have been trying all your suggestions but so far have not gotten it to work probably because I am not sure of how to use it but I am and will keep trying.
I have been looking up how to use...
-
I am now using this:
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles btnSortHandicaps.Click
Dim procID As Integer
procID =...
-
Here is what I have used and it works.
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles btnSortHandicaps.Click
Shell(My.Application.Info.DirectoryPath +...
-
Great, I am using that now. Thank You
-
That's what I was looking for, Thank You.
-
How do I know how many lines are in a sequential text file?
Or how to read the file one line at a time so I can count the lines in the read.
-
I am a part time programmer for personal fun. I would never gotten it.
I still don't understand what it does but will be studying it to see if I can understand each line.
Thanks .Paul for your...
-
I need to change the first field of each line of a CSV file.
I have searched a lot of info but can't out it together so I have no code to show.
Here is the CSV file it's name is scores2.csv.
...
-
Because the Form is set in size and will always be printed on Landscape 11 x 8 1/2 and maybe someone else can use the code.
I have shortened the code to this:
Private Sub...
-
Thank you paul, I am getting closer to understanding it.
Early in the code the physical printed page was set to 1100 x 850 (8 1/2 x 11 landscape) and the form was larger than that
so the If...
-
After using msgbox I find that e.MarginBounds refers to the bmp rectangle that fits on the paper size not the actual form size. I guess that's what paul was trying to tell me.
Where did that get...
-
Thanks to your help I have seen that things like like MarginBounds.Top or Left or Right etc is nothing more than a default of 100,
and that it refers to a rectangle(I had already concluded) that...
-
paul, what you are saying is e.MarginsBounds.Width and e.MarginsBounds.Height is the size of the paper I am printing on.
Then what is e.MarginsBounds.Top? I mean how was it calculated? There is...
-
I found this code somewhere in my google search and it works very nicely.
Private Sub btnPrintForm_Click(sender As Object, e As EventArgs) Handles btnPrintForm.Click
'Print Form Fit to...
-
Thanks paul, this is what I am looking for. There is enough info here to keep me busy for a long time trying to absorb it all so I can pick the right process for my programs.
I am sure I will...
-
There appears to be many different ways to deal with reading, writing, checking if a file exist etc.
Is there a good tutorial that deals with all of those ways?
-
I found my own answer. https://docs.microsoft.com/en-us/dotnet/core/deploying/single-file
Near the bottom "Publish a single file app - Visual Studio"
|
Click Here to Expand Forum to Full Width
|