LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default how to add picture to worksheet from url in Excel 2007

In Excel XP or Excel 2003, we can add picture to worksheet from url, besides
from file. There are two functions that can do the job:

1. ActiveSheet.Pictures.Insert Filename:=strUrl
2. ActiveSheet.Shapes.AddPicture Left:=10, Top:=10, _
Width:=100, Height:=100, _
Filename:=strUrl, LinkToFile:=msoFalse, SaveWithDocument:=msoTrue

However, in Excel 2007, both of the above functions don't work. I'm not sure
if the same function is taken away from Excel 2007, or if some settings are
not set properly.

thanks for any help

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do I embed a picture in excel 2007 Bob from ATK Excel Discussion (Misc queries) 0 September 21st 09 01:31 PM
Copy Picture in Excel 2007 Bob Myers Excel Worksheet Functions 5 December 21st 08 11:03 PM
Insert a picture - Excel 2007 dan Excel Discussion (Misc queries) 2 April 9th 08 09:48 PM
picture graph in Excel 2007 K -- mom of 3 Charts and Charting in Excel 1 April 27th 07 01:20 PM
How to extract a picture from an Excel worksheet into a picture fi SARANJAI Excel Discussion (Misc queries) 10 June 12th 05 05:00 AM


All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"