Search results for query: *

Many thanks Skip - that's spot on. As for "from the RIGHT" - well that was just my non technical speak to try and leave out the first "_" on the left - never mind! Many thanks all, really appreciate the help.

Hi, I would like to return a string from between two characters using a formula (no VBA). Problem is I have three characters in the string which are the same so I really want to return from the RIGHT e.g. this is how my strings look: "Test_001_This is a Test_24-08-2011.doc" and I wish to...

Hello? Can anyone out there help please?

Hi - just getting back in to web development after several years (and the last time I did this it was classic ASP help!). Basically using Microsoft web developer 2010 to do a simple search against a db. I have one textbox and one drop down menu (which will be used to choose which column in the...

Superb, worked great and I learned something very useful, many thanks.

Really appreciate that but I'm up against it with time and I don't really know VBA or how to impliment it is there any way to do this with a formula? Many thanks.

Sorry meant to say I need this to be a formula in an Excel cell. Thanks.

Hi, How do I create a formula to return a string from the following (between the last "\"'s)? \Asbestos\Inspection\001_Dscf0026_2009-09-06.JPG\ I want to return: 001_Dscf0026_2009-09-06.JPG Many thanks.

Sorry for the delay. Our network: We have schemes all over the country and they have locally installed printers. We also have Office users who print to network installed printers. When the scheme user logs in to Terminal services they see not only their own printer but everyone else's. Just...

Thanks for the reply however when I untick printers I lose the locally mapped printer which defeats the purpose. Also - the user account only has security "Domain users", when you check each of the proprties of the printers they are all set to allow "Everyone" is allowed to view & print. I...

Hi, Anyone know of a way to hide the printers that are created on Terminal service sessions from terminal service users (other than changing security on each printer as they chop and change a lot)? Basically users are currently able to login and change their printer to print off anywhere in...

Hi, We are running Veeam virtual backup then a Veritas backup. We would like to be able to add a command to the end of the Veeam backup to tell Veritas to run its backup - does anyone know the command to do this please? Many thanks.

Hi - thanks for that but just checked and the folder(s) were spelled correctly - they were all created by copying and pasting from the same "template" or layout of folders so they will all be identically named. Lost to why this is happening then??? Ta.

Does anyone know if there is a limit on how many folders can be copied as the cript seems to die around 124 folders in? Goves the error "cannot find then the file path" but it's been using that file path 124 times previously! Tried it twice and died at same folder both times. Manually...

Works like a dream - brilliant many thanks.

Sorry one last thing - how do I script it so that if it can't find a folder with the three numbers in it that it will skip to try copying the next folder? At the moment it is putting the scheme folder in to the last destination folder it used. Thanks.

P.S. jges - many many thanks for your script - really appreciated.

Amazing what you can do when you put your mind to it eh?! it actually all works!! Can't thank you enough guys, Final script below for those who are interested (although still to do final testing): Option Explicit dim objFSO Set objFSO = CreateObject("Scripting.FileSystemObject") const...

Ok I have the correct folder name being returned and have added it to the variable "destFolderName" how do I add this to the newpath (line of code below) as every time I try to add the "destFolderName" variable to this line it gives the following error: Object required String[name of the folder]...

bit closer - maybe something like this? It's hard when you don't know the language! Set destSubFolders = objTargetFolder.SubFolders for each objSubFolder in destSubFolders if InStr(destSubFolders,schemeNumber) <> 0 then wscript.echo(destSubFolders) end if next