ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Paste object from sheet to catalogue (using VBA). (https://www.excelbanter.com/excel-programming/421214-paste-object-sheet-catalogue-using-vba.html)

[email protected]

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.


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com