Hello,
According to my Understanding, You need excel macro and you want to give folder location, file name and entry that you want to append.
When you execute macro then you want following steps
1. Open file automatically
2. Append entry automatically
3. Save file automatically (file will remain open)
AM I RIGHT?
I'm programmer/developer. Expert in macro (Please check my reviews in profile)
Thanks
Warm Regards
Sayli