appending filename to each record within a file

gigi46
05-26-2010, 08:10 PM
I am a bit perplexed. Hoping someone can assist me in coding a VBA pgm which would allow the following to occur:

1) ability to select a file from a directory C:\aa20100526.txt. The file name will always be 10 characters long with the last 8 representing the asofdate of the data in that file.

2) then append the last 8 characters of the filename to each record in the each file and then save the file

:confused:

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum