View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
wimblejon wimblejon is offline
external usenet poster
 
Posts: 6
Default Excel to Powerpoint pastespecial date problem

Nick (and others),

Quite correct, I was using 'wdPasteEnhancedMetafile', but changing it
to 'ppPasteEnhancedMetafile' made no difference!
I can only assume this problem is (yet another) 'feature' of the MS
interface.

I've fixed it myself - but only via a frig!

I turned the dates on the sheet into text before creating the graph,
thus fooling VBA into ignoring the date format.

Many thanks for your help.