BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

[Deski (XI)] How to remove a VB macro from a .rep (SAP BO XI 3.1)


 
Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
Fina_Rodriguez
Forum Member
Forum Member



Joined: 09 Dec 2010

Posts: 8



PostPosted: Fri Aug 09, 2019 6:15 am 
Post subject: How to remove a VB macro from a .rep (SAP BO XI 3.1)

Hi,
I´m not use at all of using VB macros in Desktop.
Anyone can tell me how to remove a macro from a desktop report?
I suppose that I can remove them just from one report and the same one can still be working in any other. Is it so?
Thanks!!
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6629
Location: Connecticut, USA


flag
PostPosted: Mon Aug 12, 2019 7:45 am 
Post subject: Re: How to remove a VB macro from a .rep (SAP BO XI 3.1)

Go to Tools -> Macros -> Visual Basic Editor (or hit Alt-F11). This will bring up the VBA editor.

Macros will be listed in the left-hand pane under "Desktop Intelligence Objects". Right-click on each one and hit "Remove". You will be asked if you want to export the macro -- you can do this to keep a backup in a text file.

There might also be Class Modules or User Forms in the project panel; you can delete those too (assuming, of course, that you're sure you don't need them).

Macros are part of the .rep file, so yes - you can remove macros from one document without affecting macros in another document.

Some more info here: https://wiki.scn.sap.com/wiki/display/BOBJ/VBA+fundamentals
Back to top
Fina_Rodriguez
Forum Member
Forum Member



Joined: 09 Dec 2010

Posts: 8



PostPosted: Tue Aug 27, 2019 6:00 am 
Post subject: Re: How to remove a VB macro from a .rep (SAP BO XI 3.1)

Thanks a lot but it seems that either I don´t have the rights or I´m doing something wrong.
Attached a screen shot of the way for doing as you said. Is it a rights issue?
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6629
Location: Connecticut, USA


flag
PostPosted: Tue Aug 27, 2019 7:05 am 
Post subject: Re: How to remove a VB macro from a .rep (SAP BO XI 3.1)

I don't think the ThisDocument module can be deleted. Just double-click it to open it, and delete any code that's in it (the right-hand pane).

It might be empty.

You should be able to delete the frmDummie module.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0267 seconds using 17 queries. (SQL 0.0028 Parse 0.0008 Other 0.0231)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo