Recent content by Emmanuel

Thanks anyways for checking and for sharing the code.

Thanks again. I may be doing something wrong. I get the error screen attached. This is the code modofied with actual folders: Dim intLoop as Integer Dim strFolderPathNames (1 to 3) as String Dim strAnswer as string intLoop(1) = "\\tbstp\R2W\Admin\Watch" intLoop(2) = "\\tbstp\R2W\Admin\Work"...

Thanks. I'll ive this a try. If you have some free time, could you show me the example of the other scenario where the file names are not sequentially numbered like above? I really appretiate you taking the time to reply. Thanks!

I appretiate the explanation, but could you provide me with an example of how to call tha function many times? Also, your examples of the results is exactly what I'm looking for. I may pull some more folders, but I just want to see which ones had files inside of them.

Hi guys, I have the code below that a friend gave me, but I need to change it to check multiple folders. Can you please provide me with some help? I need to do something like an elseif so it can check folders: "\\tbstp\R2W\Admin\Watch" "\\tbstp\R2W\Admin\Watch2" "\\tbstp\R2W\Admin\Watch3"...

Thanks guys. I agree with what you have said here and I guess there isn't much we can do about it. Have a great one.

Tried that. Doesn't work. I get "Type mismatch: 'exists'" error 800A000D This is the code now: dim objFSO, Dir, f1, f, fc, strSourceFolder, strDestFolder, strlOOKFile, strlOOKFolder if exists("\\tbstpabc\D\ftp1\") then 'Constants Const OverwriteExisting = TRUE 'Global variables...

Hey guys, I have this piece of code which works fine to pull the files from the remote server if the server is available. However, this server is taken down several times a week for back up and maintenance. My problem is that when this script runs and the server is down, I just get a "Path not...

Thanks guys. I found the answer. I got it to work by doing this: dim objFSO, f1, f, fc, strSourceFolder, strDestFolder, strlOOKFile, strlOOKFolder 'Constants Const OverwriteExisting = TRUE 'Global variables strSourceFolder = "\\tbstpgw3\D\ftp1\*.FLG" strlOOKFolder = "\\tbstpgw3\D\ftp1\"...

Tried it, but for some reason it does not work. Maybe I'm not incorporating it right. This is the code I have. dim objFSO, strSourceFolder, strDestFolder 'Constants Const OverwriteExisting = TRUE Set objFSO = CreateObject("Scripting.FileSystemObject") 'Global variables Public Function...

He guys, I have a quick question regarding a code I wrote. I need to copy some files from one server to another every day, but some times they script starts running before the files are available and that is causing the script to fail. Could someone help me troubleshoot this code to enable it...

Thank you for your help. Using your code and some other online sources, I found the right combination. For those using Sybase IQ, this is what the code looks like. Select column_name From sys.systable inner join sys.syscolumn on...

Wow, that was quick. Unfortunatelly, it does not work. I tried runnign it and it didn't work. I get the following error. "Error: Syntax error or access violation (State:42000, Native Code: 0)" If it helps. I'm running on Sybase IQ. Thanks for your help so far.

Hi team, I'm looking to get a code that I can use to list the fields inside a table. I am in the process of converting all our tables to views so that I can better maintain it for the users and give it more functionality without the users having to link to many tables. The problem is that some...

I think I got it. Just in case anyone else is asking themselves how this would work in Crystal. This is what you need to use inside your select editor. {your field} in WeekToDateFromSun This will give you the current weeks data. There are a whole bunch of formulas in ther to pull various date...