View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Childs Tim Childs is offline
external usenet poster
 
Posts: 128
Default <Parent of the Clipboard

Hi

Is it possible to determine the source filename of the contents of the
clipboard.

The reason I ask is that I am writing a utility for others to use for
re-arranging data in the clipboard prior to pasting that re-arrangement and
some of the code is dependent on the information gleaned from the
spreadsheet which is sitting in the clipboard.

Put another way:
a) user selects data (from one of three files) - puts it in clipboard
b) user selects destination in different speadsheet
c) user runs procedure which manipulates data (incl code dependent on the
one of three files chosen) and pastes it at the activecell

Any help very welcome.

Tim