Avoiding Prompts in Macros

I'm trying to create a macro that involves saving a CSV file to a different directory. How do I cut out the manual intervention and allow the document to save without being prompted? And generally, how to I avoid any other prompts?

Thanks in advance

Matt