Search results

I am after a macro that will list all the files and sub folders in folder x and then also list all the files and sub folders that are in the sub folders of x and so it goes on. This is where it becomes extra complicated. For each sub folder of X I want a new work sheet listing the files and...

here's the help file as well smiler44

here you go scott-atkinson i'll upload the help file as well this is the path where the files were kept on my pc "C:\Program Files (x86)\Excel Tool VBA Password Recovery\Excel Tool VBA Password Recovery.xls" smiler44

Gasman, thank you for the formula, its been of great help. I have used it during the week and I can now add it into my spread sheet to use properly. thanks again smiler44

very kind Gasman thank you, I'll study it tomorrow smiler44

sorry Gasman for some reason I did not get an email to say you had replied. A2 + C2 = 09.06.17 but there is a bank holiday on 29.05.17 so new date should be 10.06.17 not 08.06.17 I don't fully understand your formula so cant try to change it B2-A2 = x count number of dates in column E that...

In the attached example only look at the cells highlighted Green ignore the rest and then see the macro referred to. I am at the moment running the macro using the F8 key as need to modify the file to automate it or call it from some other macro in my proper work book There must be a better way...

No worries Gasman, I thought it was me :) In your example you are adding 11 calendar days to 28.05.17 but as 29.05.17 is a bank holiday you need to add 12 and end up with 09.06.17 just as you have done. I understand your example and it is just what I am needing to do. Have you a method for...

I have just found this formula via a Goggle search =B2-A2-COUNTIF(E2:E11,">="&A2)+COUNTIF(E2:E11,">"&B2) it can take note of bank holidays but needs to know the start and end date so it can work out how many calendar days there have been. If B2 could become a number such as 10 or 20 etc...

Gasman, sorry I think we have our wires crossed or I really am missing something. It is not working days I need but calendar days not including bank holidays. May had 31 days with 2 of them in England being bank holidays. So on May 1st if I add 28 days I should get my answer as 31.05.17 I cant...

Gasman, thank you. that thread got rather heated. The result seemed to be a macro for working out the number of working days between 2 dates. I was after a formula to add x number of calendar days to a known date but take into account bank holidays. I hope in did not misunderstand the thread you...

I want to add a number of days to a date and get the new calendar date but also account for bank holidays. cell A1 a date number of days to add bank holidays in cells A3:I3 something like this =WORKDAY.INTL(A1, 90, 7, A3:I3) but this is working days and takes into account the bank...

I'm thinking of getting VB. Net and would like some advice please. I have a project written in Visual Basic version 5. Will VB.net be able to do the same things as VB5? what is the best way to convert a project written in VB version 5 to vb.net? I also have VB version 6 but have never used...

oh, cheers Gasman I never knew that. when I clicked on the zipped file I downloaded nowt seemed to happen. thanks anyway smiler44

found the file I wanted smiler44

I have to add a macro to an xls workbook, I assume it is Excel 2003. The existing VBA code is password protected. Can you recommend something to break the password? I thought I had something to break the code, used it once a few years ago and now cant find it. Would prefer something not zipped...

more searches via Google and getting different bits of code I have come up with this. It filters, copies just the cells I want from the visible cells and pastes to another sheet. I will add a do until loop as I need to go back to sheet1, filter for my next word, copy the data and paste but this...

I want to filter a spread sheet. There may be just one row plus the header of more rows plus the header. I want to copy column A and first visible cell after the header to column C and last used visible cell. so I filter and there are two entries, row 10 and row 99. I want to copy A10 to...

why prompt them, why not just add code to save the file? x = MsgBox(" do you want to save file", 36, "confirm") If x = 6 Then ' yes ' not sure is this code is right dim oSavePath As String path of where you want to save the file ActiveWorkbook.SaveAs...

thanks. i need the code i think as i will run this on different spread sheets. smiler44