-
Created Ignoring a Null Values when Sorting
I'm writing a routine where the user can populate up to 8 textboxes with numbers. Since there is potential for these numbers to be unsorted, I want to sort these … -
Began Watching Ignoring a Null Values when Sorting
I'm writing a routine where the user can populate up to 8 textboxes with numbers. Since there is potential for these numbers to be unsorted, I want to sort these … -
Replied To a Post in Check to see if a workbook is open multiple times
Alicera Nz, I may have not be clear enough, so let me restate the issue: The macro that opens "14D Scorecard.xlsx" works perfectly the first time. This same macro further … -
Created Check to see if a workbook is open multiple times
Hi group, I've written some VBA code behind an Excel spreadsheet to check to see if another workbook is open. If it isn't open, I'm having the code open it … -
Began Watching Check to see if a workbook is open multiple times
Hi group, I've written some VBA code behind an Excel spreadsheet to check to see if another workbook is open. If it isn't open, I'm having the code open it … -
Marked Solved Status for VBA to VB.net "Open filePath For Input As #1"
Hello Group, I'm trying to convert some VBA code into VB.net. Here is that VBA code: Open filePath For Input As #1 ' filePath = the text file I need … -
Replied To a Post in VBA to VB.net "Open filePath For Input As #1"
Shark 1, Yes, "Mastering Visual Basic 2010" is by Evangelos Petroutsos. After reading earlier posts and then testing, it dawned on me that the code `LineFromFile = sr.ReadLine()` reads the … -
Replied To a Post in VBA to VB.net "Open filePath For Input As #1"
Rev Jim, I've purchased "Mastering Visual Basic 2010" but I don't see anything that suggests converting VBA code. I've also taken a couple of college courses in VB.net which were … -
Created VBA to VB.net "Open filePath For Input As #1"
Hello Group, I'm trying to convert some VBA code into VB.net. Here is that VBA code: Open filePath For Input As #1 ' filePath = the text file I need … -
Began Watching VBA to VB.net "Open filePath For Input As #1"
Hello Group, I'm trying to convert some VBA code into VB.net. Here is that VBA code: Open filePath For Input As #1 ' filePath = the text file I need … -
Created Publish new VB.net program - Set where to load program
Group, When publishing my first program, I noticed that it put the program in the App folder as opposed to "C:\Program Files\". Is there a way to direct where everything … -
Began Watching Publish new VB.net program - Set where to load program
Group, When publishing my first program, I noticed that it put the program in the App folder as opposed to "C:\Program Files\". Is there a way to direct where everything … -
Marked Solved Status for Remove 'End of Report' Line and format UNIX text
Group, I'm now having to merge several of these text files together. At the end of each of the text files is a line that says "End of Report". I … -
Replied To a Post in Remove 'End of Report' Line and format UNIX text
Shark 1, I got it to work. I did find that the code `readtxt.GetUpperBound(0) - 2` had to be changed to -4. Once I did that it worked exactly as … -
Replied To a Post in Remove 'End of Report' Line and format UNIX text
Shark 1, no luck using your code. It doesn't appear to be doing anything. I was hoping it would drop the last two lines. But it doesn't seem to be … -
Replied To a Post in Remove 'End of Report' Line and format UNIX text
I'm curious: Using the "System.IO.File.ReadAllLines("FileName")" syntax, is there a way to read a specific number of lines? I've determined there are 232 lines in the first file. If I read … -
Replied To a Post in Remove 'End of Report' Line and format UNIX text
I did do this to remove the "End of Report": txtLine = Replace(txtLine, "End of Report", "") Of course it still leaves the line. I'll play with this to see … -
Replied To a Post in Remove 'End of Report' Line and format UNIX text
There is a part two to my issue: There is a blank line between the end of the last line of info and the line that contains "End of Report". … -
Replied To a Post in Remove 'End of Report' Line and format UNIX text
Rubberman, I think your idea is probably a wise one. I'm disappointed I didn't think of it first. I guess I'm in too big a hurry to get this thing … -
Created Remove 'End of Report' Line and format UNIX text
Group, I'm now having to merge several of these text files together. At the end of each of the text files is a line that says "End of Report". I … -
Began Watching Remove 'End of Report' Line and format UNIX text
Group, I'm now having to merge several of these text files together. At the end of each of the text files is a line that says "End of Report". I … -
Marked Solved Status for controls shrink and grow as form size changes
Hello group! I've seen one short discussion of ensuring that the controls within a form will shrink, grown and stay in their proportional position as the user changes the form … -
Marked Solved Status for ListViews - What are the different Views? Can they be Changed?
Hi Group! I suppose this should be titled, "Everything You Wanted to Know about ListViews, but were Afraid to Ask". Here are my questions(s): I've used ListView with "Details". This … -
Marked Solved Status for Sorting in ListView
Hello Group! I've looked around to see if there is specific code in VB.net to do this, but I haven't seen any. I'm using ListView/Detail and want to ensure that … -
Revoked Solved Status for Sorting in ListView
Hello Group! I've looked around to see if there is specific code in VB.net to do this, but I haven't seen any. I'm using ListView/Detail and want to ensure that … -
Revoked Solved Status for Sorting in ListView
Hello Group! I've looked around to see if there is specific code in VB.net to do this, but I haven't seen any. I'm using ListView/Detail and want to ensure that … -
Marked Solved Status for Sorting in ListView
Hello Group! I've looked around to see if there is specific code in VB.net to do this, but I haven't seen any. I'm using ListView/Detail and want to ensure that … -
Marked Solved Status for Windows Forms Control Library Template
Hi group, I'm looking through the book "Mastering Microsoft Visual Basic 2010" by Evangelos Petroutsos. I'm trying to work through a chapter on designing windows controls. In the first step … -
Marked Solved Status for VBA in Excel - Check for Groups
Group, I'm trying to improve a macro in an EXCEL spreadsheet. The spreadsheet has multiple tabs (sheets), some of which have grouped rows in them. My "cleanup" routine needs to … -
Stopped Watching SQL Server..Express..compact Database's.
I am new to VB, and have attempted to load all the free versions of the SQL available. Dispite many go's I still can not make any work. I go … -
Marked Solved Status for vbScript Creating a Clock/Timer
Group, I'm trying to write some code that will read the clocktime. When it hits a predetermined time, I want it to run a routine. I know how to do … -
Marked Solved Status for Using VB to copy from one EXCEL spreadsheet to another
Group, I've got a protected spreadsheet at work that prevents me from creating links or writing macro's to do some repetitive copying and pasting from one spreadsheet to another. I … -
Replied To a Post in Converting counter = My.Computer.FileSystem.GetFiles(folderName) to integer
tinstaafl, thanks for the code and the tips. Most importantly, it worked perfectly! Thanks for the help! Don -
Marked Solved Status for Converting counter = My.Computer.FileSystem.GetFiles(folderName) to integer
Group, I'm counting the number of files in a folder using the following code: Dim counter = My.Computer.FileSystem.GetFiles(folderName) This produces a value that doesn't appear to be either a string … -
Created Converting counter = My.Computer.FileSystem.GetFiles(folderName) to integer
Group, I'm counting the number of files in a folder using the following code: Dim counter = My.Computer.FileSystem.GetFiles(folderName) This produces a value that doesn't appear to be either a string … -
Began Watching Converting counter = My.Computer.FileSystem.GetFiles(folderName) to integer
Group, I'm counting the number of files in a folder using the following code: Dim counter = My.Computer.FileSystem.GetFiles(folderName) This produces a value that doesn't appear to be either a string … -
Marked Solved Status for The Root Namespace for a new VB.net application
I'm making some "cleanup" changes to my 1st VB.net project that I'm publishing. The project has an "Assembly Name". But I've just realized that the Root Namespace has the default … -
Replied To a Post in The Root Namespace for a new VB.net application
OK... I won't change anything with this one. But I will certainly remember this the next time I build one. Thank you everyone. This has been a enjoyable learning experience. … -
Replied To a Post in The Root Namespace for a new VB.net application
This prompts the question then: If I change it now, will I disrupt anything? Would it be best just to leave things alone and do nothing with this first program? … -
Created The Root Namespace for a new VB.net application
I'm making some "cleanup" changes to my 1st VB.net project that I'm publishing. The project has an "Assembly Name". But I've just realized that the Root Namespace has the default … -
Began Watching The Root Namespace for a new VB.net application
I'm making some "cleanup" changes to my 1st VB.net project that I'm publishing. The project has an "Assembly Name". But I've just realized that the Root Namespace has the default … -
Marked Solved Status for Publishing and attaching text files to VB.net program
Group, I've published my first VB.net program (woo hoo!). This prompts me to ask a couple of questions: 1) I'm using a couple of text files to hold some user … -
Replied To a Post in Publishing and attaching text files to VB.net program
Got it! Thanks group! Don -
Created Publishing and attaching text files to VB.net program
Group, I've published my first VB.net program (woo hoo!). This prompts me to ask a couple of questions: 1) I'm using a couple of text files to hold some user … -
Began Watching Publishing and attaching text files to VB.net program
Group, I've published my first VB.net program (woo hoo!). This prompts me to ask a couple of questions: 1) I'm using a couple of text files to hold some user … -
Marked Solved Status for Converting Unfomatted Text into Formatted Text
Hello Group! I am in need of converting a "text" file created by a UNIX based program (it is only semi-formatted) and put it into a more-formatted text (.txt) file. … -
Replied To a Post in Converting Unfomatted Text into Formatted Text
Group, I finally figured it out. Here's the final code: RestranName = "C:\Restran Conversion\IPSDATA\PM00213A\20141210.142601" Dim fileSave As String = "C:\Restran Conversion\IPSDATA\PM00213A\213RT20141210.txt" ' This reads the text file for conversion txtLine … -
Replied To a Post in Converting Unfomatted Text into Formatted Text
Rev. Jim / Minimalist, I'm attempting to convert the code to VB.net. I've got it to write something but it's writing only one line. I'm sure I need to use … -
Replied To a Post in Converting Unfomatted Text into Formatted Text
Rev. Jim, I started to do something like that, but I didn't have much luck with "StreamReader". I'll give your code a whirl. Thanks again! -
Replied To a Post in Converting Unfomatted Text into Formatted Text
Rev. Jim, you're correct and that is my error. Since this program is written in VBscript, I've looked for a way to run this "Convert.vbs" through a VB.net. I've tried …
The End.