efc93

Hi All, Just a quick question, on whether anyone has an idea on how to set up a macro that checks the status of files / folders on an external drive, and if the file on the original drive has changed, then this is updated on that external drive. The situation we have is, we wish to backup from a network drive, to an external, USB HDD and without having the throughput of all of the data copying every time, wanted to only copy across the files that have changed. Appreciate any help you can offer ! Cheers, TG

Hi All, Like all of us here, very appreciative firstly of the ME program and secondly this great forum ! - so many great tips - it is great to have resources available like this to make ALL of our lives easier ! My question relates to the 'switch/case' commands - only did a bit of 'C' programming at school, but a lot of VB, am stuck on the best use of the switch / case commands in my scenario : Need to extract data from a text tab delimited file - 15 lines, 5 fields in each. Then need to wash this data through a program, generate a result and come back for 2nd line's data. My problem is how to do this without duplicating. At the moment, am extracting data from ASCII Delimted file and recording all the data, but leaving aside five variables ( T45-T49 ) for 'working' data ie. at the start of each function, copying the next 5 variables to T45-T49, so it can be worked on. My problem is how to do this, without duplicating 15 times, all of the program workings. I have been advise the 'switch / case' set of commands should do this, but am at a loss on how to set it up. As I would need to 'call' a certain group of commands 15 times. Would appreciate any assistance anyone can give - haven't purchased the PGM Functions Library yet, but if this will assist me to complete the above problem, then i will gladly purchase it. Appreciate your help in advance ! TG