Hello, I have several text files that are formatted like this: ppt_1988_001 9185.91666667 ppt_1988_002 9198.5 ppt_1988_003 9131.25 ppt_1988_004 7177.33333333 ppt_1988_005 9087.08333333 ppt_1988_006 9093.75 ppt_1988_007 7041.91666667 ppt_1988_008 7041.91666667 ppt_1988_009 7955.58333333 ppt_1988_010 10521...

Working in access 2003 - I want to find a way to copy a table and then paste that table with the same name as a table that already exists in the database. I can't delete the table that is being pasted into and I can't do a make table to the table that I need to paste into. I can manually accomplish...

Hello, I have a directory of workbooks that are have the same layout as the attached example. I would like to reorder the columns as follows: Original Position to New Position (Column Header) A to E (LID) B to P (TA) C to Q (NP) D to F (PD) E to G (LPI) F to R (TE) G to H (ED) H to I (LSI) I to J (PAFRAC...

Hi, Record any changes done in colum A & B. Into Comments. I want help with a macro when i change any data in colum A & B any cell in those colums a new comment has to be created and the change has to be updated within the comment. If there is a comment already existing has to append the data...

Hi Experts! I have a Userform in Excel (2007) with several check-boxes on it. For example, there are 2 categories, each with 5 check-boxes under it. The user needs to check one from checkbox 1-5 (category 1) and one from checkbox 6-10. Upon selection from any of the checkboxes 1-5, say number 2, then...

Hello, I have a directory of one-sheeted workbooks (see attached for an example, sheet name is the same as filename) they have the following column headers: ID GRIDCODE Area SArea Then they have a varying number of rows with values under these headers. I would like to add the following data at the end...

hi all, i'm finding a particular task very hard to accomplish in Excel VBA. I have a formula in range K6 in a sheet called "Aggregate". the formula resembles "=sum(sheet1!K6, sheet2!K6, sheet3!K6) As the sheet that i'm working on is an aggregate view, i need to achieve the following...

Hi, I have a bunch of words within column A. i need to make specific letters a certian colour. i need to find within the words, the letter "n", within the column and colour all n's .ColorIndex = 1 i need to find within the words, the letter "l", within the column and colour all...

Hi, I have a spreadsheet with a number of hidden ranges. The spreadsheet has a sum formula at the bottom of the sheet, however, sometimes i need to see what rows the data is being picked up from. the formula in cell I1059 looks like this : =SUM(I451,I599,I731,I741,I747,I759,I727,I792,I12,I86,I98,I134...

I am trying to automate an excel process to retrieve data from an AS/400 and send the data to a defined email address once the spread sheet is loaded without user intervention. The problem I am encountering is the Workbook_open function sends the email prior to the retrieval of data to the spread sheet...