macro key

R

redburns

Is it possible to make a Macro in Word or Access, or
Excel, to go into a Folder and open a text file, then
append to a Microsoft file? The catch is every day is
other name on the file, but same format.
 
6

'69 Camaro

Macros are too generic to do this in Access, but you may be able to code it
using VBA in Access, depending upon the format of this "Microsoft file" you
mentioned. Appending to some file formats will just corrupt the file, not
add data.

VBA procedures are called Macros in Word and Excel, so a Macro in Access
isn't the equivalent of a Macro in the other two applications. However, the
same caveats for appending to files would apply to VBA procedures in those
applications as well.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)
 
Top