MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Avoiding Prompts in Macros


Posted by Matt on February 14, 2002 2:47 AM

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


Posted by DK on February 14, 2002 3:40 AM

Application.DisplayAlerts=False