Question:
Dear All,
i want to write code in Vb ...for a report
when i going to visual basic editor it shows me two PROJECTS
SAPBEX (sapbex.xla )
VBa PROJECT
i have saved my query in workbook..now wen i click on SAPBEX project it ask me for password
which password i should enter....
giude me through this one...
Regards
Ankur
Answer:
You shouldn't open that one at all, hence the password!!!
I doubt it that SAP will ever give this password to customers...
You should open project VBAPProject and under that you will find one module called SAPBEX and it has a default Sub in it. Actually this should be opened by default if you launch VB from within a workbook
cheers,
El Belgio
Answer:
Dear ALL,
should i write my code in this
Private Sub Workbook_Open()
End Sub
or i have to click on Sheet1 (SAPbexqueries)
i will get this on right hand side
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
should i write in this.....
Regards
ankur
Answer:
Sub SAPBEXonRefresh(queryID As String, resultArea As Range)
End Sub
THAT'S WHERE YOU SHOULD WRITE IT!!!!!!!
if you had followed my earlier explanation you would have gotten exactly in the correct Sub