asked on

Using wb.ActiveSheet.Shapes.AddPicture to add a picture from a Unix web server

I am trying to use wb.ActiveSheet.Shapes.AddPicture to add a picture to an Excel sheet that is created from a VBScript that is run through a Unix web server. With an older version I was able to use wb.ActiveSheet.Pictures.Insert and had no problems but that command does not work on the newer version. In both cases the picture was stored on the Unix server, but with the newer version it can't find the picture. Please help!

twalgrave

This is still supported in the newer versions
Here's the format for it in Excel 2000.
Function AddPicture(Filename As String, LinkToFile As MsoTriState, SaveWithDocument As MsoTriState, Left As Single, Top As Single, Width As Single, Height As Single) As Shape
Member of Excel.Shapes

Possibly wb is not defined.

ebloch13

ASKER

I am using the new command and on Win98/old Excel it functions pulling the picture off the Unix Web Server. On 2000 it still functions but it does not pull the picture off the Unix server, it will only pull a picture if I have it loaded on the PC itself and have the filename pointing to that picture not the Unix Web server. Any ideas?

ASKER CERTIFIED SOLUTION

twalgrave

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

FaithRaven

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept twalgrave's comment
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

FaithRaven
EE Cleanup Volunteer