philfer
12-31-2007, 12:30 PM
I am using the below to prompt the user to select files which I will then import into excel
Application.FileDialog msoFileDialogFolderPicker
It is all working fine but I want to capture if the user at any time presses "cancel" The filedialog loops a few times with different prompts.
I want to capture a cancel and then delete all the data that has been imported so far so that when they press import the next time there is not any data in the sheets.
I tried If .Show = -1
But it went all funny on me
Help!
Application.FileDialog msoFileDialogFolderPicker
It is all working fine but I want to capture if the user at any time presses "cancel" The filedialog loops a few times with different prompts.
I want to capture a cancel and then delete all the data that has been imported so far so that when they press import the next time there is not any data in the sheets.
I tried If .Show = -1
But it went all funny on me
Help!