VBA, Clear Clipboard on file.close

Clear Clipboard on file.close

Author	Message
gina.frazie #1 / 3	Clear Clipboard on file.close I have a VBA script in Word that opens an Excel file, copies info and pastes it into the Word document, then closes the Excel file. When I close the Excel file, I always get a prompt about "..large amount of info on clipboard, do you want to save it?" How can I bypass this message or clear the clipboard using VBA?? Right now, I close the file using: xlbook.close savechanges:=False Thanks in advance, Gina Frazier
Mon, 23 Dec 2002 03:00:00 GMT

Derek Piaseck #2 / 3	Clear Clipboard on file.close Use Clipboard.Empty after you are done pasting. -Derek Quote: > I have a VBA script in Word that opens an Excel file, copies info and pastes > it into the Word document, then closes the Excel file. When I close the > Excel file, I always get a prompt about "..large amount of info on > clipboard, do you want to save it?" How can I bypass this message or clear > the clipboard using VBA?? Right now, I close the file using: > xlbook.close savechanges:=False > Thanks in advance, > Gina Frazier
Tue, 14 Jan 2003 03:00:00 GMT

Jonathan Wes #3 / 3	Clear Clipboard on file.close Hi Derek, Although VB6 has a Clipboard object, Word VBA and Excel VBA don't. This is how to do it in VBA. Dim MyData As DataObject Set MyData = New DataObject MyData.SetText "" MyData.PutInClipboard Regards Jonathan West - Word MVP MultiLinker - Automated generation of hyperlinks in Word Conversion to PDF & HTML http://www.multilinker.com Word FAQs at http://www.multilinker.com/wordfaq Please post any follow-up in the newsgroup. I do not reply to Word questions by email Quote: >Use Clipboard.Empty after you are done pasting. >-Derek >> I have a VBA script in Word that opens an Excel file, copies info and >pastes >> it into the Word document, then closes the Excel file. When I close the >> Excel file, I always get a prompt about "..large amount of info on >> clipboard, do you want to save it?" How can I bypass this message or >clear >> the clipboard using VBA?? Right now, I close the file using: >> xlbook.close savechanges:=False >> Thanks in advance, >> Gina Frazier
Tue, 14 Jan 2003 03:00:00 GMT

Page 1 of 1

[ 3 post ]