Recent content by vgwprja

I am presently selecting pattern = *.txt and it works fine. I need to narrow the scope and select a pattern like this: tovecellio*.txt, it does not seem to find any files even if they are present. Present code: Set objRegExp = New RegExp objRegExp.Pattern = "*.txt" objRegExp.IgnoreCase = True...

I am archiving files located in folder "e:\fromtravelers" (ie folderName = "e:\ftpdata\fromtravelers\") to folder e:\fromtravelers\archive. Files in folder "fromtravelers" may already exist in "archive" and it so I need to replace them with files from "e:\fromtravelers".

Sorry about the confusion. The latests script posted does not work. If the file already exists in the archive folder it gives an error. If file exists in the archive folder I need to delete it prior to moving a new file into same folder. Thank you.

Just making sure I have it correct (I need some error trapping as well): For Each objFile In fileColl If objRegExp.Test(objFile.Name) Then strDest = folderName & "archive\" & newFile If filesys.fileExists(strDest) Then filesys.DeleteFile strDest filesys.MoveFile...

Below script moves files to the /Archive folder. In some cases the file may already exists in archive and if so is there a way to replace? For Each objFile In fileColl If objRegExp.Test(objFile.Name) Then On Error Resume Next filesys.MoveFile objFile, folderName & "archive\" & newFile...

We are getting there, this is an automated script and once I have done the "get" I need to move the file on the remote machine so I do not pick it up again later.

Not sure if we are talking about the same thing (most likely my lack of understanding) At the line objMyFile.WriteLine ("get " & strFilePut) the script picks up a file (whatevere is in the outgoing ftp folder) and does the ftp. I do not now the file name of the ftp file as it has a date/time...

Could I use something like this: objMyFile.WriteLine ("move " & objFile.Name, strFTPServerFolder/backup)

I understand, but how do I get the name of the file I just ftp'ed, this is the one I need to move. Thank you.

I have a FTP script and after the FTP I need to move the file to a backup folder. Not sure how to do this: Option Explicit Dim strFTPScriptFileName, colFiles, objFile, objFSO, objMyFile, objShell, objFolder, strFilePut Dim strLocalFolderName, strFTPServerName, strLoginID Dim strPassword...

I tried this: Dim myDataSet As New Data.DataSet myDataSet = CType(Request.Form("mySqlDataSet"), Data.DataSet) Still got the same error. What is the approach to using a session variable? Thank you.

I have a web page that displays a gridview (page 1). On this page I have a button saying "View Report" (link to page 2) and the intent is to render a new page showing a crystal report with same content as in the girdview on page 1. Not sure how to navigate from page 1 to page 2, here is what I...

Here is the complete code: 'VB Script - Archive FTP Files (pgp format) Dim filesys, file, folderName, objFile, folderObj, objEmail, fileColl, objRegExp, newFile Set filesys = CreateObject("Scripting.FileSystemObject") folderName = "e:\ftpdata\fromtravelers\" Set folderObj =...

I have a script where I loop through a folder and deletes certain files. The 1st loop works fine and file is deleted. On subsequent loops I get error "permisson denied 800A0046". I am running the script under administrator. Can someone help me here? Thank you. If...

Yes, I think that is what I will have to do. Thank you.