Recent content by gjsala

Here is what I have so far. What I'm trying to accomplish is: 1. I have more than 100 text files to look through 2. Once the "A" tag is found and the number is less than 500, as explained above, then I would like to copy that text file into an excel worksheet labeled "1". 3. If there are...

Andrew, I'm using Excel VBA to read through the text files. I will post more of my code in a bit. Thanks!

I'm using Excel VBA to read through text files and the problem I'm having is capuring numbers after tags are identified. Below is what a sample of the text file: A 1550.9 330.0 B 44.0 45.0 The tag is the letter "A" in the text file then I want to capture the number 1550.9. The...

Skip, Thank you very much! It work like a champ!!!

Hi. I would like to search through many excel workbooks in a specific folder on my computer. My objective is to look at a specific tab (for example “Test”) in each workbook and copy the same two cells (B5 and B6) to a master Workbook starting with cells A1 and B1. This macro would create a...

Andy, Thanks for your help. I did figure out how do delete the files without going to the trash.

Andy, Another idea is to create a new folder, put the files that I want to put into that new folder then delete the file bypassing the trash can. How would I do that? Thanks!

I would like to permanently delete files from one folder on the c: drive off the c: drive. I have been using the following code to move files between folders but I would like to automate the process. Thanks for your help in advance! Sub MoveFiles() Dim strFolderA As String Dim...

I'm looking to sum many excel cells together with the following code but instead of adding the cells together it only appends the numbers and giving a huge number for example 8.71201E+37 instead of 1507. What else can I use? Thanks in advance! Do While Cells(r + 1, 2) <> "" tmp1 =...

Gavin, Thanks for the response. When I ran this macro this is what happened: (1/20/1 - 3:18:43.23 P #VALUE! #VALUE! (1/22/1 - 5:05:06.43 A #VALUE! #VALUE! Is there some formating that has to be done in columns C and D? Thanks!

How would I be able to figure out how many hours are between these times stamps: (1/20/11 - 3:18:43.23 PM) and (1/22/11 - 5:05:06.43 AM)? Thanks.

Skip, How would I change it to return Days(numeric) between the two days? Thanks!

I have the following code but I keep getting a "Invalid procedure call or argument". Can you please tell me what I'm missing? Thanks! Sub datediffFuction() Dim pdate1 As Date, pdate2 As Date Dim strDateString As String pdate1 = Cells(5, 1) pdate2 = Cells(4, 1) strDateString =...

I would like to get the difference in time from the following time stamps: (1/20/11 - 3:18:43.23 PM) and (1/22/11 - 5:05:06.43 AM) using VBA. I have used a text to column to take out the date and used military time to subtract the difference but the problem lies when I have a time stamp of...

The files I'm looking at are not excel(or office) files. What would be the difference in code?