Removing Excel promits from a macro
Posted by Angie on January 24, 2001 3:13 PM
I am writing a macro that will split text from a database file in to a formatted excel spreadhseet. I can write the macro so that it works, but excel keeps asking me questions (like do i want to clear my clipboard). Is there anyway i can program a response in to the macro so that it doesnt ask me these questions (for example i never want to keep the clipboard info, so it just enters 'no' rather than me having to).