Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
delete files older than 15 days
Hello, I have used the following to delete files older then 28 days just replace with the correct paths and the number of days and you should be good to go. Dim fso, f, f1, fc Set fso = CreateObject("Scripting.FileSystemObject") Set f = fso.GetFolder("E:\Folder") Set fc = f.Files For Each f1... -
Variable use in path names and Query
Thanks , I only had to make a few small changes and it runs like a charm now. I had to move the second Wscript.Argument to the sendmail sub because it was not excepting it as it was. See scrip below. TableName = WScript.Arguments(0) Set OBJdbConnection = CreateObject("ADODB.Connection")... -
Variable use in path names and Query
Tryed the script and it works great, however whant I need to do is have this running in the background with out user input. The idea was to have a small script with the var's kick off the second script that does the work of attaching and e-mailing. Thus I could just write an new startup scrit... -
Variable use in path names and Query
Hello, I am working on a VBS script that will pull a list of email address from a database then email every one on the list with an attached file. I have a working script however I would like to reuse the main portion of it with out having to hard code each script. 'This section reads database...
