Search results for query: *

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

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

Great! Once again thanks Loomah for your help. [2thumbsup]

Thanks again Loomah, I really appreciate your help. I now have one last little problem: Some of the worksheets contain less rows than others and since I have selected a range (D1:I14) the charts get strange where the rows are less than 14. I've looked into the FAQ's about how to find last row...

Thanks Loomah, that was what I was looking for ... [thumbsup] If I want to get some specific worksheets instead of all, let's say all sheets with sheet names starting with "SA" or "DP" how could I do that?

Hi! I have a Workbook containing several worksheets and would like to loop through all sheets and make a graph of them. The workbook is updated every period of time and the contents may vary for each period (different names for the worksheets and different amount of sheets every new period) I...