Recent content by dodgyone

I eventually decided to use an array, coded the solution then looked in here for any replies. That was the very suggestion. Thanks for taking the trouble to reply.

I have a series of variables in a number sequence. Const strTest1 = "A" Const strTest2 = "B" Const strTest3 = "C" I am using a loop with a counter incrementing it. A simplistic example is shown below. intCounter = 1 Do... Msgbox strTest & intCounter intCounter = intCounter + 1 Loop I...

I have some code which sends an email through VBScript: 'create the email components, attach the zip file etc and send strSchema = "http://schemas.microsoft.com/cdo/configuration/" Set objConfig= CreateObject( "CDO.Configuration" ) With objConfig .Fields.Item( strSchema &...

20080312 1212 ...which later on becomes an archive file name (20080312 1212.txt)

But there are 4 scripts all with the same code and the only alteration has been to change the server name variables. Surely it shouldn't rely on chance if it's doing the same thing over and over?!!

The date formatting works fine and has no bearing on the other code than to name the file that is archived. Cheers for the advice though. I tried staggering the scheduled tasks every 2 minutes and it now works as it should do. WScript has its own process for each task so I cannot see why it...

Does anybody have any ideas? The WScript.Sleep seems to be the cause of the problem. It is set to sleep for 3600000 milliseconds and it all works fine when I run it manually. Surely I can use WScript.Sleep in a scheduled task?

I should of added that the scheduled task runs the performance monitoring part of the script but seems to stop when it reaches the update and edit of the outputted performance monitoring file: '-------------------- 'Performance Log File '-------------------- Dim objFile, objFileCopy...

I have created a series of VBScripts to run performance monitoring and input the data into SQL Server. It all works fine when I run each in turn manually. Whenever I schedule them to run at the same time then it fails. Have I got to stagger these in some way to get it working? Surely it should...

Thanks PHV. Should of known that... Doh!!!

I have a global variable set at the top of the module: Public GLBstrEFOLDERID As String I then have code within Sub AutoOpen() to do this immediately when the document is opened: Sub AutoOpen() Dim strReadLine As String If Dir("\\itax-dmdev2\SOAPDownload\Admin.txt") <> "" Then...

Sorry for sounding stupid but I'm not quite sure what you mean. It's early days for me with using CR. Could you elaborate a little? Thanks...

I have a series of linked tables. In addition to this is a user table which has no correlation or link to the other data at all. Within here I need to get the user name and a security id. I have a function which displays the user name so this data can easily be gathered. But I find having an...

I'm still having difficulty with this one. Any suggestions? Thanks...

The only thing I could come up with is fudging it a little. In SQL Enterprise Manager I created a view joining the two tables together in a standard select query: SELECT dbo.mSessions.eUsername, dbo.mSessions.mSOAPSession, dbo.OTHER.EFOLDERID, dbo.OTHER.Forenames, dbo.OTHER.Surname...