From the copy and paste that excel(i work with excel 2000) implements ,whenever a copy statement is given the excel copies onto common windows clipboard and pastes from it.Excel also maintains the 12 selections in the private clipboard(office clipboard).
My queries are:-
1)From VB will i be able to access this set of selections.
2)Is this selection clipboard common or distinct for each instance of excel.(what i mean here is the instance generated from vb to access excel without using references i.e createobject function is used.)
The reason for the above queries is that if two operations of copy (when programatically this copy macro is called)is done the latest copying action will replace the contents in the common windows clipboard.My aim is to prevent this.Although this is possible through api support from vb (i.e to look for an open clipboard ,this will take time in this loop check),i wanted to know whether this can be avoided ,if it can done from excel itself