Search results for query: *

:-) Thanks very much - here goes Dim PathName As String Dim question Dim filetoopen Dim lastrow Dim fs Dim subfolder Dim FileNameOnly Application.DisplayAlerts = False Application.Calculation = xlCalculationManual Application.ScreenUpdating = False...

MakeitSo Really appreciate your time, it seems i am lacking the skills again to make your answer work, i really am a blagger, i just copy paste and adapt codes from the internet with varying success. Would you mind if i post the full code so you can see why i'm failing to incorportae your code...

Thanks Make It So I will try that out, i fear though that this macro would be incredibly slow if the drive / path / folder has couple hundred / thousand files in it. Do you know a lateral way round this problem by any chance Many thanks

Hi guys thanks for the responses guys, i've not managed to get further on either track...Excuse my lack of skills but i couldn't understand quite how to work it and if it could be incorporated in a macro in VBA. And to Walker Evans, thanks, i've tried testing on just a path with xl files in the...

Hello I am looking for some help using the BuiltinDocumentProperties object. I am trying to adapt it into a directory index macro. What the macro currently does is use FoundFiles to basically create an index of whatever path you want it to. I then want to offset and list various info on the...

thanks to all apologies on the security aspect nie

Hello i recently bought a pc but do not have the admin rights. It is xp and i have managed to download a version of MS VB express 2008. Using VB is there a way to create a new user then add to admin group or am i barking up the wrong tree entirely here. I am a familiar low skilled user of VBA...

ah thats working now thanks v much

thats great thanks - i'm definately getting there now - only problem is that you can overwrite with this one. but i'll attempt to modify thanks

xlbo Hello - i have tried your code but cannot get it going - keep getting error surrounding the priorvalue line?? Thanks for the help btw

AnotherHiggins Hello, i've usde your code and it works perfectly but - the only prob is that it displays the message when you make any worksheet change as well as deletion, i thought it would be quite simple to tweak but have thus far failed. any thoughts? thanks N

Looks good - thanks guys - haven't been ablr to try out yet but i have faith THanks

i'll give it a go thanks

Hello thanks, can't think of an action that covers off the delete on the keyboard side of things, as usual i suspect it may be my lack of ability to think laterally that is hindering me here. I want to avoid the protection route as other than deleteing the user needs to have full use of the SS...

Hello I have created a .xls for multiple users; it seems that some users have accidentally delted data from the SS in the past, is there a way i can have maybe use a userform that warns users when any data is about to be be deleted and request a confirmation, this would include using delete on...

Thanks very much for your help - apologies for the delay in responding - i managed to create a version adapted from one someone at work sent me.

Hello Thanks for your help - IT blocked the download on the first and the 2nd link wouldn't load for some reason.

blocked by my work IT stuff

Hello can anyone give me a code for Excel VBA that will give me a complete index list of all files on a drive (e.g. my C) Thanks in advance Nie

thank you v much you have cracked it! thats the prob with my VBA knowledge - very patchy and self taught. Thanks a million So in summary to anyone who ever refs this in future i used the below code to send a message and bypass outlook security prompt (NB make sure you have 'Microsoft...