VBA in BEx

[Former Member]

Hi All,

Can someone let me know how the VBA is used in BEx. Also, any documents to learn VBA relating to BEx would be really helpful.

My mail ID: <b>James.Helsinki@hotmail.co.uk</b>

Best Regards,

James.

[Former Member · Accepted solution]

Hello James,

Please go through this link

http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a55f9e09411d2acb90000e829fbfe/frameset.htm

Regards,

Praveen

[Former Member]

Please send the Same document to me also i have some assignments on VBA i want to jump from one query to another by clicking on the Command button... if any know about this please send...

my mail id : naga.jagadeesh@gmail.com

Thanks & Regards,

Naga T Jagadeesh

[Former Member]

Hi all,

Can you guys send me the doc for VBA in BEx

anil2k2k@yahoo.com

thanks a lot in advance

Anil

[Former Member]

James/Peter

Could you kindly email me the documents as well.

My emal address is jimi.ogun@googlemail.com

[Former Member]

James,

Another example

when I execute the query in Analyzer, the value `#' is displaying in place of `BLANK' value.

I want to show it as `BLANK/SPACE' instead of `#'

The code is below:

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

If queryID = "SAPBEXq0001" Then

resultArea.Select

'Remove '#'

Selection.Cells.Replace What:="#", Replacement:="", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, MatchByte:=True

'Remove 'Not assigned'

Selection.Cells.Replace What:="Not assigned", Replacement:="", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, MatchByte:=True

End If

' Set focus back to top of results

resultArea(1, 1).Select

End Sub

-Doodle

[andrea_previati]

Hi

You can enhance your workbook functionalities with VBA MACRO . Follow these steps:

A) Create a workbook with 1 queries in it.

B) Go to Tools - Macro - Record Macro - SAPBEXonRefresh

C) Go into VB Editor (ALT+F11) and type your code

One example:

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

With resultArea.Resize(1, 1)

.Offset(-10, 0) = "Last Calculated at:"

.Offset(-10, 0) = Now

End With

End Sub

You can find many code examples in other SDN posts...

Hope it helps

Andrea

[Former Member]

Hi All,

Thanx for all ur replies. I want to learn writing VB Macros. Can some one suggest me the best way to do that. Also, I would be grateful if some one can send me some documents on this...

Many thanx in advance...

Best Regards,

James.

[Former Member]

Hello James,

Please go through this thread.

Regards,

Praveen

[Former Member]

Hi James,

One of the Word documents that I sent (How to automate BW reports in Excel.doc) starts at a very low level, and assumes that you know nothing about VBA and very little about Excel. Start with this document.

You will find a section titled "The General Subject of Automating Excel Workbooks", followed by a section titled "What if You Do Not Know VBA?". In the latter section is reference to the 2 books that I have found most helpful:

1. Microsoft Excl 97 Visual Basic Step-By-step, by Reed Jacobson; ISBN: 1-57231-318-8; Pages: 368

2. Excel 2003 Power Programming with VBA, by John Walkenbach, ISBN: 0-7645-4072-6; Paperback; 1056 pages; January 2004

The first is the best book for beginners. Although new objects, properties and methods have been added since Excel97, none have been deleted. So, all of the information in this old book is still relevant. Many other books are available, but I have not found a better book for beginners. This book is out of print, but you can find new and used copies still.

- Pete

[Former Member]

Hi!!!

Peter, can you send me "How to automate BW reports in Excel.doc" to mail ID: radiohead84@yandex.ru

Thanks in advance!!!

[Former Member]

Dear Peter,

please can you send me the doc "How to automate BW reports in Excel.doc" to my email (stefan.kaifer@hartmann.info), too?

Thanks

Stefan

[Former Member]

Hello All,

Is there any chance someone can e-mail the Word.doc file too? The name of the file is "How to automate BW reports in Excel.doc".

Thank you!

James.Leone@Sandoz.com

[Former Member]

Hi all,

Can you guys send me the doc for VBA in BEx

thanks a lot in advance

sreedhar_neelu@yahoo.com

thanks and regards

Neel

[Former Member]

Hi Peter,

could you please send me the doc "How to automate BW reports in Excel.doc" to my email:

pieri.stefano@centrica.com

Many Thanks

Stefano

[Former Member]

Hi Peter,

Could you send me the document "How to automate BW reports in Excel.doc"

Because we are working with 3.01 I have to make a vba solution in Excel to broadcast workbooks via outlook.

I myself do have experience in programming vba.

please sent this to my emailaccount j.j.huizinga@rn.rabobank.nl.

Jacob

[Former Member]

Hi Peter,

Can you pls send me the materials and guide how to start off with VBA coding....

I have aggresive deadline given to me by team lead.....

So pls quickly assist me with this.....

Maximum Points Assured

Thank you for the same......

my mail addresses:

aravindakshan@gmail.com

digivind@gmail.com

With Regards,

Aravind

[Former Member]

Hi James,

There are two, related, but different types of integration between VBA routines that you write and the BEx add-in:

1. The BEx add-in can trigger your own VBA routines; or,

2. You can control BEx add-in functions from your own VBA routines.

I have sent Zip file containing some examples and explanations.

For "type 1" integration, if you are using Excel 2002 or later, your users' Macro security settings must be set to allow access to Visual Basic project (see "Trusted Publishers" tab of Macro security dialog box).

- Pete

[Former Member]

Hi Peter,

can you send me the documents you mentioned in this thread?

mailto:michael.cloos@lhsystems.com

Thank you very much.

Kind regards

Michael Cloos

[Former Member]

Hi Experts,

Can you pls send me also the documents writing VBA codes for BEx reporting.

My email Address is

digivind@gmail.com

Thank you

[Former Member]

Hi Peter,

Can you pease send me the materials and guide how to start off with VBA coding?

You help will be highly appreciated.

my mail address:

sunnyb786@hotmail.com

Regards

Sunny