A macro that can insert FILENAME, sendkeys CTRL ALT T, paste clipboard, and nextline

		Microsoft Office Forums > Microsoft Word > Word VBA
A macro that can insert FILENAME, sendkeys CTRL ALT T, paste clipboard, and nextline

09-14-2012, 02:12 AM

macropod

Windows 7 64bit A macro that can insert FILENAME, sendkeys CTRL ALT T, paste clipboard, and nextline

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,528

Hi kyjac85,

After the 'End With', you can clear the clipboard by adding:

Code:

Dim MyData As DataObject
Set MyData = New DataObject
MyData.SetText ""
MyData.PutInClipboard

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
paste and insert, not replace	userman	Excel	4	06-06-2012 05:15 AM
Problem with the sendkeys in Win7	vidyapakki	Excel Programming	1	05-07-2012 11:10 PM
Insert/Paste Picture into Protected Worksheet	udea	Excel	1	02-06-2012 07:43 PM
How to insert current date into default filename ?	czomberzdaniela	Word	1	12-27-2011 07:18 PM
Macro for automatically adding filename without .doc	RPM7	Word VBA	0	04-29-2010 01:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:13 AM.