Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Codman
  • Content: Threads
  • Order by date
  1. Codman

    Finding table header and row value from a cell within a table

    I have three tables in an Excel worksheet and I wish to return the value of a selected cell. In this example if 5 selected in the top table I want to return the column and row reference in two other cells in the sheet. I have tried Index and MAX formula, but cannot seems to achieve this. Am I...
  2. Codman

    Justify line text Independently

    I have a number of cells, each containing text split over separate lines using Alt-Return. I wish to right justify the top line and centre justify the other but can't seem to get the right control. I don't think this can be done by using Cell custom formatting. not can I see how to do this using...
  3. Codman

    Extract word table cell data from multiple docs to a single excel sheet

    I have many .doc & .docx files, each with a header table (Table 1) in the same format. I need to pull Cell positions C1R1, C2R3 and C2R4 on all documents to a single sheet within an Excel file. Although I can find script that allows me to locate the Excel file in the same folder and pull all of...
  4. Codman

    exporting data from Outlook to Excel

    I have a task of creating a monthly report which shows the following data from outlook messages in a specifc folder. I need to show: - a) The senders address b) The Mail Header c) The reply date and as the messages are always forwarded, the forwarding address. d) The date of each event. I'm...
  5. Codman

    word table references

    I have a word doc with nine tables, some of which are used to show a reference to the filename. As there are other links to a database which need to be brokenon saving/printing, I have done this programatically, but need to retain the filename field in table 1, 3 & 7. No problem if the number...
  6. Codman

    Save Excel without macros?

    I'd like to save a workbook via vba without saving the macros using the following code:- ActiveWorkbook.SaveAs FileName:=Name, FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False If this is not possible, is it...
  7. Codman

    Picture.Insert dilemma

    I have a pice of code that works well to place a .Gif file to a specific location in a spreadsheet. However, I need to change the directory dependant upon a user path and am having some problems. I obtain the path via a user form and dump this to an excell cell, but if I try to reference that...
  8. Codman

    ComboBox dilema

    I have a combobox in which to enter numeric data and transfer this to a specific cell on a sheet. The value is stored in this cell and read back to the combobox when the file is next opened. However, if the file is not closed but a change is required the value passed back from the cell has many...
  9. Codman

    Copy & paste Xl2000 to wd200 with veryhidden sheets

    Realizing that xlVeryHidden Sheets are difficult, if not impossible to access,I have a problem. I can copy a range from Excel to Word with the Xl sheet visible but not when very hidden. However, I can see and manually paste the copied data from the clipboard to word. Is there a way to do this...
  10. Codman

    Table of instances

    Hi, I'm new at vba and have a brain teaser with a table in Excel. I have a table as shown below and assuming that each row is an instance with up to three variable each, (Col 1 being the index number), I need to identify the number of identical instances in total. The table will have a maximum...

Part and Inventory Search

Back
Top