View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vince[_3_] Vince[_3_] is offline
external usenet poster
 
Posts: 1
Default Opening and closing text files

I am opening a text file that is tab delimited via VBA
code. After I copy the data that I want to copy, then
select the current active worksheet and paste the data, I
close the text file. When I close the text file, I always
get the message

"There is a large amount of data on the clipboard, do you
want to save the data...yes, no, cancel".

Is there a way to close the file without having to answer
this question each time?

Any ideas would be appreciated.

Vince