Search results for query: *

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...

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...

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 =...

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...

Using VBA how would I look at a file on the C: and extract the date stamp?

Thanks for your help in advance. I have multiple .txt files in a folder that I would like to move to a different folder if they meet certain criteria. If the txt file is less than 1000 kb then it’s moved to a different folder. Also if the txt file is greater than 36 hours old then this will...

I have the following code: ActiveWorkbook.SaveAs "C:\test\" & .xls" I would like to have the VBA code save the date and time to the file name when the macro is run. For example: “home_4_30_2010_2:45:00 pm.xls” onto the c drive. Thanks in advance!

Thanks for your help in advance. I have a line in a text file for example: c:\program\Files\122310.xlm I would like to capture the 122310.xml in the text file. The only catch this section will change from one text file to another for example now its 122310.xlm the next text file it could...

All, I’m new to using check boxes and buttons. How would you have a list of check boxes(lets say 10) to select from and after selections were made you click on a submit button, this information would be written to an different excel spreadsheet on the C drive. After the information is written...

I have a program that will look through many text files, in a folder, to seek out a specific line and then put it into an excel sheet. I would like to only select one text file from a directory, any ideas? Thanks for your help! The code I have is: Function PickFolder(strStartDir As Variant)...

I’m having trouble with formatting a cell with a time stamp using VBA. What I’m doing is subtracting two cells for example: Cell 1 (1:03:25AM) – Cell 2 (12:45:22PM) What I’m after is the difference in time but when I subtract the two cells I get “######” which is a negative number and showing...

Thanks in advance for any information. In VBA I'm looking to select one or more text files from a directory on the harddrive, search the text files for a specific specific word, for example "Test", then when found that line is put into an excel spreadsheet row. There will be many times this...

I'm not sure if excel can do this but I would like to have an icon, maybe an excel shortcut, placed on the desktop. When this icon is "Doubled clicked" the Date, Time and the computer name is entered into a network excel file in three columns, saved and then closed so the user wouldn't see this...

I'm really new at taking items out of a text file and putting it into excel. I would like to look through text files, sometime 100 or more, in a specific folder and look for the word "Phone" in each file. When this word is found which is located in column two of the text file, I would like to...

So far my code will allow me to select text files and convert them into excel workbooks, one text file = one workbook. There may be times when 20 text files are selected and other times 10. The part I'm stuck with is taking all of the workbooks and combining all of the information into one...

I'm trying to open up an e-mail message from a specific folder in outlook using VBA in excel and capture what is in the body of the message and paste it into a excel spreadsheet. There will be more than one e-mail message to go through and I would like to paste the information into one sheet...

My code can identify a row of information but I would like to add this information to a new sheet. The problem is the rows that are captured on the old worksheet keeping overwriting itself on the new sheet. How can I not overwrite the same row? Thanks in advance! Here is the code: Sub Am()...

I have two columns H and I which have information I would like to put into a bar graph using VBA code. I have tried to use the record button but when I insert that code into the existing code my program breaks. The number of items in the cells will vary between different sheets. Any ideas...

I'm trying to put a border in a group a cells. The rows are dynamic but the last cell in column one always ends with the word "Stop". I would like to put borders in cells located in columns "A" through "H". Thanks in advanced!