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

kyjac85 · #12 09-20-2012, 04:02 PM

Quote:

Originally Posted by macropod

Hi kyjac85,

Sorry, I omitted to mention that you need to set a vba reference (Tools|References) to the Microsoft Forms 2.0 Object Library, if it's not already checked.

You shouldn't arbitrarily add other references, though.

I don't see a Forms reference, only "Feed". I added that one and restarted but no luck. I still get the compile error. It highlights the "Sub insertclipboard()" line in yellow if that makes a difference.

thanks

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