[AccessD] CmdRunApp Help

Nope, I use it because it has a programming model, with properties / methods
/ child objects, complete with intellisense.

I do a ton of things like saving email attachments (from the Outlook model)
to specific directories, then using the filesystemobject to get a directory
and use the built-in iterator (for next) to iterate all files in the
directory importing payments, claim number updates and the likes into a
database.  Once I started doing that, I just wrote wrappers around the code
to dim the FSO and instantiate it, plus use a specific command.  Having that
code in place, I rarely use anything else unless the FSO is specifically
disabled on a specific client's net / machine.

I simply asked you to provide code because the gentleman originally asked
how to do this.  I provided an answer with code.  You provided a "why not
use the built-in vb commands".  I can find the built-in commands should I
ever need them, but the original gentleman obviously needed help.  "Why not
use the built-in VB commands" barely qualifies as helpful.

;-)

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Erwin Craps -
IT Helps
Sent: Thursday, December 11, 2003 2:21 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] CmdRunApp Help


Ah sorry John
I conclude with Gustav.
I learned these commands in GW-Basic/Quick Basic or something.

I just presumed you knew these commands and are using filesystemobject
for some specific reasons I'm not aware of.
Like speed, I sometimes have the impression that FileCopy is slower than
dooing a explorer copy.

Erwin

-----Oorspronkelijk bericht-----
Van: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] Namens Gustav Brock
Verzonden: woensdag 10 december 2003 14:23
Aan: Access Developers discussion and problem solving
Onderwerp: Re: [AccessD] CmdRunApp Help

Hi John

> Why not post code as I did?

Ahh John, it's too easy:

    FileCopy sourcefile, destfile
    Name destfile As johnsfile.txt

/gustav

> Why using the filesystemobject and not the regular VBA commands?
> Faster?

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com