Recent content by bodo62

Hello all. I have following code that works pretty fine listing all files of a path (including subfolders). I now need to retrieve only information about last modified file from each folder, or even better, that I can choose files modified fro a specific date range. Can someone help me out...

Thanks Shippwreck, this will put me into track again...

Hi Skip I am importing the data from a Webbpage through Data/Get External Data/Import/ but all the information is on a single table follow link to see what tables I mean http://www.stdf.org/serie/SERIE/outstand/2C.htm

Yes, that might be a partial solution, however I do not always know in which cell the word "AVERAGE" will be, since the second table starts after the first one, but I don't know on which row. What I really need is to find which cell contains "AVERAGE" and then move the found cell to next row.

Hello all. Here is the problem: There is an excel file to which we import 2 tables from a webbsite. The last column in the tables look something like this: A B C D E 1 AVERAGE 2 DATE TIME NAME POINTS 3 15/3/05 09.15...

Is it possible to make Outlook send a message with a specific attachment if a mail with ceratin subject is sent? Ex. I send a mail message with the word "SendMeTheA_report" in the subject field, then a rule should be triggered to send a reply with a file "A_report.xls" attached to the...

Is it possible to make Outlook send a message with a specific attachment if a mail with ceratin subject is sent? Ex. I send a mail message with the word "SendMeTheA_report" in the subject field, then a rule should be triggered to send a reply with a file "A_report.xls" attached to the...

Hi. A have an application that creates different files and saves them into a folder. This can occur on different times during the day depending on what week and week day it is. To avoid checking manually several times a day, I'd like to have excel or word to check the contents of the mentioned...

Great! [thumbsup2] Thanks Skip... that made the trick... I wish you all a nice week-end.

Hello there. I've been trying the whole morning to make it work, but nothing is working. I have got a loop which copies worksheets from a folder to a new workbook, while doing the loop it builds charts for each worksheet. So far so good, now I need a secondary Axis to my charts, but I'd need...

Yes, of course... thanks for all replies. I guess it's time to buy myself a new pair glasses... [glasses] [blush]

Hi. I've got following code in which I want to extract information from a worksheet for a specific chart: I want to get info from D1 to D & last filled row and then I want get info from J1 to N & last filled row, but I also get columns E,F,G,H and I For Each ws In ThisWorkbook.Worksheets If...

No, I did have Option Base 1 in my code too, but it did not work. Using SheetCount = -1 just did the job... Thanks [thumbsup2]

Thanks Loomah... ...but I'm sorry to say it's not working. I get a code 9 error on "Sheets(SheetArray()).Select" [sad]

Hi. I've got a workbook with several worksheets and charts. The charts are based on information from hidden worksheets. I need to select all remaining visible sheets (they are worksheets and charts), and from the group of sheets make a setup for page header and footer as well as printing the...