Dec 10, 2001 #1 hsummer Technical User Joined Dec 10, 2001 Messages 13 Location US I'm running Excel 97 on NT4. My VBA does not recognize the clipboard or printer objects. Eg., I can't set printer properties. why not? Thanks.
I'm running Excel 97 on NT4. My VBA does not recognize the clipboard or printer objects. Eg., I can't set printer properties. why not? Thanks.
Dec 10, 2001 #2 JohnYingling Programmer Joined Mar 24, 2001 Messages 3,742 Location US The Clipboard and Printer objects are VB objects not VBA objects. VBA is a sub-set of VB. http://www.VBCompare.com Compare Code (Text) http://www.VBSortGen.com Generate Sort in VB or VBScript Upvote 0 Downvote
The Clipboard and Printer objects are VB objects not VBA objects. VBA is a sub-set of VB. http://www.VBCompare.com Compare Code (Text) http://www.VBSortGen.com Generate Sort in VB or VBScript
Dec 10, 2001 Thread starter #3 hsummer Technical User Joined Dec 10, 2001 Messages 13 Location US How do I access the clipboard from VBA? Upvote 0 Downvote
Dec 10, 2001 #4 JohnYingling Programmer Joined Mar 24, 2001 Messages 3,742 Location US This looks promising. http://www.cpearson.com/excel/clipboar.htm go to http://www.google.com search on "vba clipboard access" without the double quotes. http://www.VBCompare.com Compare Code (Text) http://www.VBSortGen.com Generate Sort in VB or VBScript Upvote 0 Downvote
This looks promising. http://www.cpearson.com/excel/clipboar.htm go to http://www.google.com search on "vba clipboard access" without the double quotes. http://www.VBCompare.com Compare Code (Text) http://www.VBSortGen.com Generate Sort in VB or VBScript