Search results for query: *

What no Star!!! no respect, no respect! [poke]

Don't forget to add the "Timer" reference to your form and set the interval to "1", but of course you knew this right! s-)

that works Mike, had to write it this way in order for it to work.... Dim msg As String MsgBox "Tomorrow and tomorrow and tomorrow" & vbCrLf _ & "creeps this petty pace from day to" & vbCrLf _ & "day,to the last syllable of recorded" & vbCrLf _...

try this Dim Test1 as integer Test1=0 If Test1 = 0 Then Msgbox " The value is zero" End if :-)

Thanks Mike, thats the help i needed.........

Thanks for the quick response MichaelRed , and like you say i am trying to enhance my knowledge of VBA but this one has got me stumped so far..... The result that i am looking for is taking two times and in most cases it is the same day and subracting them to get the time diference between...

Hi All , i need help to subract two diiferent times. I have looked for help with this on other pages but have not been able to find the correct VBA to give me the correct results. I am presentlty taking the time that is put into two different cells and then extracting these and then i want to...

thanks for the try Mike, but for the most part the strings do seperate them selves into there own line when exported to excel. The concetantion happens about 10 lines down for one string and then it carriers on as normal till about 600 lines and so on. I am running this on a 266 PII ,just...

HI All, i am using this code to get text from a file . It works fine on small files. I am trying to read files that are 4400 lines long on average. What happens is once in while this will pickup two strings at the same time and will format the first string but will add the next line on the end...

Thanks alot StewardGW with a little tweaking it works fine. One other question if you don't mind, i started to look at the "File system object " as maybe a better way of doing this, is this a better way and can you us the same MID to break up the strings? Thanks again....... s-)

i did this a year ago and ran into the same problems. I found this link and was able to sort it out. so here it is have fun...... http://support.microsoft.com/support/kb/articles/Q194/9/22.ASP ;-)

Hi All, i am using this code to achieve the results i need to read from one file and then save it to another. This works for me until i save it to the file. What happens is the code works but every once and while instead of reading just one line it will read two lines, it will process the first...

i have been struggling with this code: Open "c:\textout.txt" For Input As #1 ' run the EOF to get all of the files contents Do While Not EOF(1) ' set the contents of the file into the variable "strInputLine&quot...

Correct me if i am wrong , but you already have loaded all of the lines from the file. Just that you only look at the first line of the file in the msgbox because thats what you told it to do. try changing the number in the ( ) to three and see what you get. MsgBox...

Well it has taken some thought but i have been able to wade through the mess and get most of what i need. I just need to figre out how to put spaces in the formula and i think i will have it. Thanks for all the help!

I can figure the opening and closing of the file, just need help on the Parse part of the file to get the results i need.

HI All , i have a file that has all of the text like this: 0216:59:03 am 08/04/01 datadatadatadatadatadatadatadat 0216:59:10 am 08/04/01 datadatadatada6tadatadatadatad i want to change this to another file to look like this: 6:59:03 am 08/04/01 datadatadatadatadatadatadatadat...

why didn't i think of that. thanks it works........

HI All , i am trying to open a file that i have got in a textbox and using word to open the file. I have found how to open word from a file that is in the code like this: objWord.App.Documents.Open "c:\filename.txt" but can't get the the textbox filename to work...

yes, i have done this as well and got the same results. i have brought the form home and redid it. i got it work here and then at work. I did remove the "richtextbox1.seltext" part and it still worked and i also changed the "write " to "print" as the book sugested...