AS

 

Hello all,   I need some help to develop a VBScript with macros for ARIS Toolset 7.1. Actually i've inserted the picture, but i can't move it cause the script is not recognizing the command to move pictures.   Follow below this part of the code inside ARIS Toolset 7.1:   Dim picture_left As Object Set picture_left = CurrentSheet.Pictures.Insert("C:\Program Files\ARIS7.1\script\basic\samplePic.jpg") CurrentSheet.Application.Shapes("picture_left").Select CurrentSheet.Application.Range("picture_left").Select CurrentSheet.Application.Selection.ShapeRange.IncrementLeft 0.10 CurrentSheet.Application.Selection.ShapeRange.IncrementTop -190 'CurrentSheet.Outline.AutomaticStyles = False   Machine settings:   OS: Windows 7 Home Premium Processor: Intel Core i3 2.13GHz Memory (RAM): 4Gb System type: 64-Bit   ARIS Version: 7.1.0.478722 Local DB   P.S. 1: I've already tryed the command "MoveTo" and create a new Excel Output Class (without macro), but doesn't work too.   P.S. 2: This script was working fine in the ARIS Toolset 6.1.1.30317 release version, but after it was converted, this part of the code doesn't working fine anymore.   Hope someone can help me.     Kind regards,   Andre Sales São Paulo / Brasil  
by Martin Schröder
Badge for 'Contributor' achievement
Posted on Fri, 01/28/2011 - 12:36

Hello Andre,

which Office or Excel version do you use now?

Which version did you use with ARIS Toolset 6.1.1.30317 ?

Regards, Martin

0
by Andre Sales Author
Posted on Fri, 01/28/2011 - 18:16

Hello Martin,

Follow your answer:

Office: 2007

Yeah, I used this version (6.1.1.30317). After this, the database was converted to ARIS Toolset 6.2.3.50422 and finally to Toolset 7.1.0.478722. Do you have some idea?

Thanks,

Andre

 

 

0
by Martin Schröder
Badge for 'Contributor' achievement
Posted on Mon, 01/31/2011 - 14:00

Hello Andre,

you are using Excel VBA here, not Aris Basic, so my question was what has changed on the Excel end since you said this script was working fine in the ARIS Toolset 6.1?

If currentSheet is a reference to the Excel.Application.Workbook the code seems redundant to me:

CurrentSheet.Application.Shapes("picture_left").Select
CurrentSheet.Application.Range("picture_left").Select
CurrentSheet.Application.Selection.ShapeRange.IncrementLeft 0.10

To get a ShapeRange object it should be sufficient to name the item of the Shapes array (cf. Excel 2007 Help):

With CurrentSheet.Shapes("picture_left").Select
.IncrementLeft 0.10
.IncrementTop -190
End With 

Hope this helps, Martin



 

 

0
by Andre Sales Author
Posted on Tue, 02/01/2011 - 01:31

In reply to by Igor Lobov

Hi Martin,

First of all, thanks for your help.

So, I'm debugging the code, while stopping at the "With CurrentSheet.Shapes("picture_left ").Select", that's the message that the debugger shows: the specified item was not found.

The code continues to run, but does not move the figure.

Have any other ideas?

Tks,

Andre Sales

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock