Guys,

I have this code ....

filename = InputBox("Please enter a filename", "Export Filename") & ".xls"

However, if the user hits cancel my code still continues. How can I only capture the string if the user hits OK and the string is not blank ?

Bob