Dec 10, 2001 #1 hsummer Technical User Dec 10, 2001 13 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 Mar 24, 2001 3,742 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 Dec 10, 2001 13 US How do I access the clipboard from VBA? Upvote 0 Downvote
Dec 10, 2001 #4 JohnYingling Programmer Mar 24, 2001 3,742 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