Support Forums

We are currently experiencing failures on the SAPIEN store and are working hard to rectify the situation. In the meantime, please DO NOT place an order through the store. Instead, please contact us directly at We apologize for any inconvenience.

Excel Macro take photo code into SSIS VBNet

Anything VBScript-related, including Windows Script Host, WMI, ADSI, and more.
Forum rules
Do not post any licensing information in this forum.
User avatar
Posts: 37
Joined: Mon Nov 09, 2009 6:11 pm

Excel Macro take photo code into SSIS VBNet

Postby ismailc » Tue Jun 09, 2015 12:02 am


I have excel selection that I would like to take photo then add to email body, In SSIS I can select & paste but not the takephoto tool

oBook.ActiveSheet.Range(oBooks.Application.Selection, oBooks.Application.Selection.End(-4161)).Select() oBook.ActiveSheet.Range(oBooks.Application.Selection, oBooks.Application.Selection.End(-4121)).Select()

oBook.ActiveSheet.Shapes.AddShape(, 390.0#, 104.25, 72.0#, 72.0#).Select()

'oBook.ActiveSheet.Shapes.Range(Array("Picture 1")).Select()
'oBook.Application.CutCopyMode = False

Anybody assist, urgently need a solution.
User avatar
SAPIEN Support Forums
Posts: 945
Joined: Wed Dec 03, 2014 2:26 pm

Excel Macro take photo code into SSIS VBNet

Postby SAPIEN Support Forums » Tue Jun 09, 2015 12:02 am

This is an automated post. A real person will respond soon.

Thank you for posting, ismailc.

Here are some hints to help you get an accurate and complete answer to your question.

Ask in the best forum:
If you asked in the wrong forum, just copy your question to the right forum.

Anticipate follow-up questions!

Did you remember to include the following?
    1. Product, version and build
    2. 32 or 64 bit product
    3. Operating system, e.g. Windows 7 64 bit.
    4. Attach a screenshot, if applicable
    5. Attach logs, crash reports, etc., in a ZIP file
If not, please take a moment to edit your original post or reply to this one.

*** Make sure you do not post any licensing information ***
User avatar
Posts: 10501
Joined: Tue May 22, 2007 9:57 am

Re: Excel Macro take photo code into SSIS VBNet

Postby jvierra » Tue Jun 09, 2015 12:43 am

Your question is vague.

VB.Net? This is a scripting forum.

Return to “VBScript”

Who is online

Users browsing this forum: No registered users and 2 guests