-
Replied To a Post in Converting Unfomatted Text into Formatted Text
Minimalist, the code works perfectly! All is good! Excellent! Thank you, thank you, thank you! Happy Holidays! Don -
Replied To a Post in Converting Unfomatted Text into Formatted Text
Minimalist, I've inserted "msgbox stringfolder" as line 6 in the script. Yes, I really have 150 separate folders where this program will be inserted. I know that sounds odd. However … -
Replied To a Post in Converting Unfomatted Text into Formatted Text
Minimalist, Yes, the icon in the folder looks identical. I did save it in the actual folder where it is to work as "convert.vbs". "ANSI" was selected. I've removed "Sub … -
Replied To a Post in Converting Unfomatted Text into Formatted Text
Minimalist, be sure to see the questions above. I've copied your script into Notepad and saved it as "convert.vbs". I double clicked it to run. Nothing happened. I tried inserting … -
Replied To a Post in Converting Unfomatted Text into Formatted Text
Minimalist, I've not run a VBscript in this manner before (in fact, only recently did I learn there was such a thing as VBscript). Does this mean that a copy … -
Marked Solved Status for File Name Wildcards
Group, In a post in VB 4/5/6, I question how to open a file with a wildcard as the file extension ([https://www.daniweb.com/software-development/visual-basic-4-5-6/threads/488809/accessing-a-file-with-a-ever-changing-name](null). That worked fine for VBA. However I'm trying … -
Replied To a Post in File Name Wildcards
Bingo! tinsaafl, you're the man! Thank you, thank you, thank you! Don -
Replied To a Post in File Name Wildcards
tinsaafl/Minimalist, I've made the changes you've suggested and have run the following: Dim RestranName As String() = System.IO.Directory.GetFiles("C:\Restran Conversion\IPSDATA\PM00213A\20141210.", "*") It's not finding the file. If I type in the … -
Replied To a Post in Converting Unfomatted Text into Formatted Text
Rev. Jim, I don't see anything in your code that will direct it to where the original file will be found or where the new, "Save As" file will go. … -
Replied To a Post in File Name Wildcards
Minimalist/tinstaafl, I've discovered this code causes an error message on a line further down in my code. It says: Using SR As New System.IO.StreamReader(RestranName) The variable "SR" has the error. … -
Replied To a Post in File Name Wildcards
Minimalist, what is the comma for (`Dim dirs As String() = Directory.GetFiles("C:\Restran Conversion\IPSDATA\PM00213A\", "*.*")`)? I would have assumed you would use and ampersand there. I see another teaching moment! Thanks … -
Marked Solved Status for Loop read text line by line into multiple textboxes
Group, I'm taking a text file that is storing ID numbers in a single column that looks like this: 123 3050 3971 I'm looping through the text file line for … -
Replied To a Post in Loop read text line by line into multiple textboxes
Rev. Jim, you indeed have the right idea. I'm going to use it. It's perfect. I knew there was a better way to write this. Thanks for the advice! Don -
Replied To a Post in Converting Unfomatted Text into Formatted Text
Rev. Jim, Thanks for the above. To answer you first question, the file is indeed a text file (this is a presumption as the file is created by a UNIX … -
Replied To a Post in File Name Wildcards
I failed to mention that the file, "20141216.042615", was produced via a UNIX based program (I believe, but not completely sure). -
Replied To a Post in Loop read text line by line into multiple textboxes
Group, there are actually a total of 20 ID's. Consequently I have 20 textboxes. Since I last updated, I've also created 20 labels. I've done this as I want to … -
Created File Name Wildcards
Group, In a post in VB 4/5/6, I question how to open a file with a wildcard as the file extension ([https://www.daniweb.com/software-development/visual-basic-4-5-6/threads/488809/accessing-a-file-with-a-ever-changing-name](null). That worked fine for VBA. However I'm trying … -
Began Watching File Name Wildcards
Group, In a post in VB 4/5/6, I question how to open a file with a wildcard as the file extension ([https://www.daniweb.com/software-development/visual-basic-4-5-6/threads/488809/accessing-a-file-with-a-ever-changing-name](null). That worked fine for VBA. However I'm trying … -
Replied To a Post in Loop read text line by line into multiple textboxes
ddanbe, Your suggestions make sense. I should have thought of inserting the data directly into the textboxes. I'm not sure using If and Else is needed. It's going to be … -
Created Loop read text line by line into multiple textboxes
Group, I'm taking a text file that is storing ID numbers in a single column that looks like this: 123 3050 3971 I'm looping through the text file line for … -
Began Watching Loop read text line by line into multiple textboxes
Group, I'm taking a text file that is storing ID numbers in a single column that looks like this: 123 3050 3971 I'm looping through the text file line for … -
Replied To a Post in Converting Unfomatted Text into Formatted Text
Rev. Jim, As always, thanks again for the help. However I want to make sure you understand that I don't want to use EXCEL at all. I'm thinking that there … -
Replied To a Post in Converting Unfomatted Text into Formatted Text
I meant to attach the file called 213Restran in the last note. I'm doing it here. I think now you'll see the quotes on various lines. -
Replied To a Post in Converting Unfomatted Text into Formatted Text
Minimalist, my apologies. The second file had been altered and I forgot about that. I looked at the 19KB file and it appears to be formatted correctly.... Which surprises me. … -
Replied To a Post in Converting Unfomatted Text into Formatted Text
Minimalist, Keep in mind that this won't be a comma delimited file. I've attached two text files to show you how it comes across and what it needs to look … -
Marked Solved Status for Accessing a file with a ever changing name
Hello everyone! Is there a way in VBA to find a file name that has an unknown portion to it? Let me explain: Our computer system is UNIX based. It … -
Created 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. … -
Began Watching 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 Accessing a file with a ever changing name
Minimalist, I've done some testing. The wildcards work perfectly! Thank you!! -
Replied To a Post in Accessing a file with a ever changing name
I may not be as clear as I should be: The code I'm writing is in VBA. I'm actually writting this behind some EXCEL documents. So the actual code you're … -
Created Accessing a file with a ever changing name
Hello everyone! Is there a way in VBA to find a file name that has an unknown portion to it? Let me explain: Our computer system is UNIX based. It … -
Began Watching Accessing a file with a ever changing name
Hello everyone! Is there a way in VBA to find a file name that has an unknown portion to it? Let me explain: Our computer system is UNIX based. It … -
Created 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 … -
Began Watching 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 … -
Marked Solved Status for Run Time Error '9' Subscript out of Range
Group, I've created a large spreadsheet with a fair amount of code behide it. Historically it has run well and with no issues. However it has started giving me a … -
Replied To a Post in Run Time Error '9' Subscript out of Range
Danny, Wow!! I love the thought process. Clearly you can see that, based on my limited programming skills, I've not completely understood the things that can be done via the … -
Replied To a Post in Run Time Error '9' Subscript out of Range
ddanbe, yes, the workbook is open when the code is run. For what it's worth, I've since re-run the reports from our server, opened them, saved them to my hard … -
Replied To a Post in Run Time Error '9' Subscript out of Range
ddanbe, There are only 4 sheets in the workbook. For what it's worth, I'm rerunning the data (which creates these spreadsheets that are to be "activated"). I'm now going on … -
Created Run Time Error '9' Subscript out of Range
Group, I've created a large spreadsheet with a fair amount of code behide it. Historically it has run well and with no issues. However it has started giving me a … -
Began Watching Run Time Error '9' Subscript out of Range
Group, I've created a large spreadsheet with a fair amount of code behide it. Historically it has run well and with no issues. However it has started giving me a … -
Replied To a Post in vbScript Creating a Clock/Timer
tinstaafl, I've begun looking through the guide and it's some help. I've attempted the following code, but it's pausing for several seconds and telling me it's "Not Responding". Then it … -
Created 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 … -
Began Watching 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 Scraping Text from a Screen
Hello group! I need to scrape data from the screen of an open application. It will be used as text, so it will need to be converted into a string … -
Replied To a Post in Scraping Text from a Screen
cgeier, the name of the program we use is called 'SecureCRT' (http://www.vandyke.com/products/securecrt/). I'm not sure if this is Java (although I'd bet $2 it is). You might be able to … -
Replied To a Post in Scraping Text from a Screen
cgeier, I don't meant to be cryptic. My apologies for appearing that way. The desire to automate this screen scraping is due to the fact that we are having to … -
Replied To a Post in Scraping Text from a Screen
cgeier, I'm not sure what to call the application that I'm using. The program in reference most likely is an old "green screen" product and may be UNIX based. I'm … -
Edited Scraping Text from a Screen
Hello group! I need to scrape data from the screen of an open application. It will be used as text, so it will need to be converted into a string … -
Created Scraping Text from a Screen
Hello group! I need to scrape data from the screen of an open application. It will be used as text, so it will need to be converted into a string … -
Began Watching Scraping Text from a Screen
Hello group! I need to scrape data from the screen of an open application. It will be used as text, so it will need to be converted into a string …
The End.