Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-13-2016, 04:57 PM
Guessed's Avatar
Guessed Guessed is offline Paste Special produces different result, VBA vs. Menu Item Windows 10 Paste Special produces different result, VBA vs. Menu Item Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,997
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default


Ahh. Another thing to try is exchanging the constant for its integer value.
wdPasteBitmap = 4 <-- this is word constant
ppPasteBitmap = 0 <-- This is a powerpoint constant

Using these constants when the code is running in other programs is often problematic. Try
Selection.PasteSpecial DataType:=4

This page tells you the possible datatype integer values
https://msdn.microsoft.com/en-us/lib.../ff197265.aspx
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste Special produces different result, VBA vs. Menu Item Paste Special and PDF zrpearson Word 3 05-07-2014 04:17 AM
Paste Special produces different result, VBA vs. Menu Item Paste Special: Copy and Paste Formatting Only? tinfanide Word 6 03-06-2013 12:21 AM
Outlook 'actions' menu item moved to the left? galgewater Outlook 0 07-30-2012 07:05 AM
Paste Special produces different result, VBA vs. Menu Item range.insertfile produces diff result between word 2010 and 2007 rsmedley Word 1 02-15-2012 10:48 PM
How to add a file menu item and invoke an EXE? simplyarun PowerPoint 0 07-21-2011 01:59 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft