VBA syntax to make a selection in a popup window when closing a file...

[chuggins143]

I've recorded a small macro that opens a text file, copies a specified range of values, closes the file, and finally pastes the values in my excel spread sheet... problem I'm running into is when the macro goes to close the file, a pop up window comes up that asks if I want to keep all of the data on the clipboard. My macro will pause until I manually hit yes or no on the pop up. Is there a way to have it automatically hit "yes" everytime?

I found in another thread and tried "Application.CutCopyMode = True", but that didn't work...

Thoughts?

Thanks!

Chad

 

[timfritsch]

Before closing the file, try Application.DisplayAlerts = False. After file is closed, reset with Application.DisplayAlerts = True


Tim

 

[chuggins143]

Works perfectly!

Thank you sir!

Chad

 

[timfritsch]

Thanks for the feedback - you are welcome. Happy to help.


Tim