General Macro Scheduler discussion
Moderators: JRL, Dorian (MJT support)
-
icwicks
- Newbie
- Posts: 7
- Joined: Wed Apr 23, 2003 11:28 am
Post
by icwicks » Tue Apr 29, 2003 8:16 am
Originally posted in the beginners forum but got no response
Hi I need help with the following scenario.
I have a database system which spits out a file every hour. The filename will be different each time (eg file001.xtn, file002.xtn, file003.xtn)
I need to be able to get Macro Scheduler to delete files in folder1 then pick up the new file and place it into folder1 and FTP it to a holding folder on a remote pc. Also I then need Macro Scheduler to look for and Pick up a similar file from the remote in another folder and then delete that file.
I am new to Macro Scheduler and don't know how to write vb scripts...yet!
I hope this makes sense
Many Thanks in advance
-
icwicks
- Newbie
- Posts: 7
- Joined: Wed Apr 23, 2003 11:28 am
Post
by icwicks » Tue Apr 29, 2003 3:50 pm
Don't sweat it guys!!
Obviously MS is too long winded and complicated for simpletons like myself.
I have done exactly what i wanted to do with a free piece of FTP software.
Thanks but no thanks!!
Regards
-
support
- Automation Wizard
- Posts: 1450
- Joined: Sat Oct 19, 2002 4:38 pm
- Location: London
-
Contact:
Post
by support » Tue Apr 29, 2003 3:56 pm
Hey,
Sounds like Macro Scheduler was way too over the top for what you wanted. If you have an FTP requirement and there's an FTP tool that does it then I'd say use that. There's no point reinventing the wheel.
I was going to write and ask for more info to try and help you write a script, because I needed to understand your requirements in more detail, but it sounds like you've found an altogether more appropriate solution.
Good luck!