I have an need to append a text file, created in a macro, to a maste
file. Is there a file concatenate command in VBA that I can use?

By the way, I don't want to have the macro append to the master fil
since there will be several users and I don't want to deal with fil
locking/sharing issues.

Thanks

Rick Kenned

--
RickKenned
-----------------------------------------------------------------------
RickKennedy's Profile: http://www.excelforum.com/member.php...fo&userid=1541
View this thread: http://www.excelforum.com/showthread.php?threadid=27029

"RickKennedy" skrev i melding
...

I have an need to append a text file, created in a macro, to a master
file. Is there a file concatenate command in VBA that I can use?
By the way, I don't want to have the macro append to the master file
since there will be several users and I don't want to deal with file
locking/sharing issues.

Hi Rick

If you want to generate or update a file in a multi user environment then
you just have to deal with it. If not then you're working on another, maybe
virtual, file, and what good is that for.

Best wishes Harald