How do I name a picture as I paste it from VBA? (ActiveSheet.Past.

Leitey

Posts: n/a

How do I name a picture as I paste it from VBA? (ActiveSheet.Past.

I want to use VBA (and maybe some variation of the ActiveSheet.Paste
command?) to paste the image on the clipboard into Excel under a certain name
i.e. "samplepicture". I have tried "ActiveSheet.Paste.samplepicture" and
"ActiveSheet.Shapes("samplepicture").Paste" but can't seem to find a good
syntax.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't Copy and Paste or Paste Special between Excel Workbooks	wllee	Excel Discussion (Misc queries)	5	April 29th 23 03:43 AM
Can an Excel formula be created to paste a picture in a cell?	bonita0914	Excel Worksheet Functions	2	April 28th 05 06:11 PM
Textboxes and "Paste as picture"	Eric	Charts and Charting in Excel	6	March 5th 05 08:55 PM
insert picture	BillGwyer	Excel Discussion (Misc queries)	1	March 4th 05 06:37 PM
how to paste a picture into the header of spreadsheet in Excel 20.	Excel programming questions	Excel Discussion (Misc queries)	1	February 15th 05 11:33 PM

All times are GMT +1. The time now is 03:36 PM.

Menu

About Us