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.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
This topic is 8 years and 9 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
Locked
User avatar
ismailc
Posts: 37
Last visit: Tue Jun 09, 2015 12:16 am

Excel Macro take photo code into SSIS VBNet

Post by ismailc »

Hi,

I have excel selection that I would like to take photo then add to email body, In SSIS vb.net 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()

'FAILS FROM HERE
oBook.Application.Selection.Copy()
oBook.ActiveSheet.Shapes.AddShape(, 390.0#, 104.25, 72.0#, 72.0#).Select()
oBook.Sheets("Sheet1").Shapes.SelectAll()

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

Anybody assist, urgently need a solution.
Regards
User avatar
SAPIEN Support Forums
Posts: 945
Last visit: Thu Oct 22, 2015 1:10 pm

Excel Macro take photo code into SSIS VBNet

Post by SAPIEN Support Forums »

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 ***
jvierra
Posts: 15439
Last visit: Tue Nov 21, 2023 6:37 pm
Answers: 30
Has voted: 4 times
Been upvoted: 33 times

Re: Excel Macro take photo code into SSIS VBNet

Post by jvierra »

Your question is vague.

VB.Net? This is a scripting forum.
This topic is 8 years and 9 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
Locked