Automate task w/VBA ?

From: DizzyD (DizzyD_at_discussions.microsoft.com)
Date: 02/21/04 

Date: Sat, 21 Feb 2004 15:14:23 -0800

Hi all,
Perhaps one (or more) of you wizards can assist me with
automating a daily tasks. Here's the deal - Every day I
ftp a batch file to a partner company, they break that
batch up into individual files ( usually 50-100). Thru a
script they deposit these files back into a pre-defined
folder on my server - however, they add a bunch of
characters to each file name. I copy all these files into
notepad, strip these characters and manually count the
total files received. I don't mind doing the copy and
paste function into Notepad, Word, Excel or whatever and
from there I like some VBA to perhaps do a string function
(?) to strip all but the last 6 characters of the file
name and total the number of files. Example below...

I ftp:
Batch AL021504.txt ( includes 50 files)

I receive the next day:
BVDX100001.txt
BVDX100002.txt
BVDX100003.txt
BVDX100004.txt
BVDX100005.txt

and so on for the remaining 45 files..

Currently I copy all 50 into Notepad, crop the BVDX and
the .txt extension and manually count the number of files.

Is there some VBA magic I can use to help me crop and add ?

I hope I explained the requirements??

As always - thanks in advance !!! ;-)

Relevant Pages

  • Re: Depoly Text Doc to 400 PCs
    ... I have generated a batch script already,using excel to ... send to the default share on XP machines. ... >> FTP scripted command. ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: XP Serial Number Questions
    ... That was my original thinking too but now that you have corroborated my ... how can I ever be sure that the key for the OEM Win XP I ... So you have 2 groups of characters. ... >> might be a installation CD batch number. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Automate task w/VBA ?
    ... batch was received. ... >I'm not sure what you're using Notepad for??? ... >> paste function into Notepad, Word, Excel or whatever ... >> Currently I copy all 50 into Notepad, crop the BVDX and ...
    (microsoft.public.word.vba.general)
  • Re: Another FTP opinion" Simple FTP 2.0
    ... but my main reason for liking WS-FTP is the batch ... I have batch files that, with one mouse click, extract all ... Perhaps I am seeking the wrong type of ftp client, ... quickly find a GUI ftp I liked, I just used a shell script with a Here ...
    (comp.infosystems.www.authoring.html)
  • Re: Revolver Issue
    ... What this tells me is that your FTP batch must operate in the "z/OS UNIX" ... environment since only there can /etc/hosts be in the search order for the ...
    (bit.listserv.ibm-main)