View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] TRomuk@gmail.com is offline
external usenet poster
 
Posts: 2
Default Paste object from sheet to catalogue (using VBA).

Hi,
(sorry for my english)

ActiveSheet.Shapes("Object 1").Select
Selection.Copy

I use this code to select and copy object (file: myfile.bat) from
sheet, I paste this file into sheet using Paste-Object-Path...

How can I paste selection object into other catalogue (for example: "D:
\Myfile\") using VBA, some kind of CTRL+V in VBA?

Thanx for help.
P.