Hello,
I use BO reports containg VBA macroes with VB prompts in them. Before the refresh starts these prompts perform various queries on the db and the fill out the BO prompts, and then the dataproviders refresh.
For this we have defined a new connection in the VBA code. I would like to know if there is a way within the report to use the parameters of the connection defined in the universe. This has two good reasons
1. Why create a parallel connection when the report already has one?
2. In the univers you already have a user/password, which you would have to hardcode in a parallel VBA connection
I would like to know if anyone has managed to use within VBA the connection defined within BO itself.
Many thanks,
Toni
(another issue related to it is to be found in the post
Programmers > Languages > VBA Visual Basic for Applications (Microsoft) Forum :
"define a connection in a dll/ocx?"
thread707-752569)
I use BO reports containg VBA macroes with VB prompts in them. Before the refresh starts these prompts perform various queries on the db and the fill out the BO prompts, and then the dataproviders refresh.
For this we have defined a new connection in the VBA code. I would like to know if there is a way within the report to use the parameters of the connection defined in the universe. This has two good reasons
1. Why create a parallel connection when the report already has one?
2. In the univers you already have a user/password, which you would have to hardcode in a parallel VBA connection
I would like to know if anyone has managed to use within VBA the connection defined within BO itself.
Many thanks,
Toni
(another issue related to it is to be found in the post
Programmers > Languages > VBA Visual Basic for Applications (Microsoft) Forum :
"define a connection in a dll/ocx?"
thread707-752569)