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...
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...
Hi Paul,
You're correct, I can't expect a macro to pull data fro tables that differ, hence my reference to "Old School" (manual data retrieval). It was worth asking the question though as the impossible is sometime a stretch that can be achieved ! :)
Hi Skip,
The data for the customer name and address is text in single cell and that's okay as I only want this cell plus the email and telephone number. The res t of the data is required for my task. Hence I need complete data from three separate cells.
Hi Paul,
This code crashed when tying to read the table. I looked into this to find two issues; the first was no data in the cell, the second was a difference in some of the template layout I wasn't aware of.
In the case of no data, this stalls the whole process, so if on document 3 of 100 I'd...
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...
Hi CMP
Still have problems I'm afraid I've included your code and additions as below. When I step through to the lines starting " Set objFolder =......." the code skips to the debug.print line and I get the error message in the immeadiate window of "-2147221233 The operation failed. An...
Hi CMP,
I tried changing the names to: -
a) Public folder names. Ours starts "All Public Folders") with sub folders as "Quotes"
b) Changed the name to "Inbox" and then "France" as folders in my mail box.
If I step through the code as in a) the code jumps to the debug.print line after it...
OK, I entered the code in an Excel module and although it creates a column label and the code seems to loop, it doesn't give any data. Did you anticipate me putting the code in Outlook? If so, I get an error message on the line statring Dim wksOutput As Worksheet.
Cod Man
Hi Guy's,
I tried the File export approach but could not find a field that shows the forward address or date. I assume this is not available using this function, or is it that I've missed it??
I also tried the outlookspy program and although this gives lots of objects and I can find the To...
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...
Hi Macropod,
I hear what you saying, and that makes sense. However, to complicate matters I only wish to preserve some of the fields! I'm pulling customer names and adresses from a database as external links, and also have {FILENAME} as a field in the header of each table. I want to break the...
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...
Hi Stella,
I tried this and managed to get it to work with sheet names NOT conjoined with an underscore. It works with both xlvisible and xlhidden sheets but does not copy xlveryHidden which is all well and good. The problem I have now is that although the vba Module folders are not copied, nor...
Hi Tomreid,
I noticed that I missed quote marks off two of the file names. Unfortunately this didn't make any diference. Still looking for that magic bullet!!
Pete
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.