I am using Brio Explorer 5.5 and Excel 2000.
I have added the brioaddn.xla to the proper library and have added it in. The Excel toolbar indicates that Brio is active.
When we execute a line of VBA code to open a query it chokes.
The line is:
OpenBrioQuery stFilename:="Test.qry";
iWindowStyle:=iWinStyle; fNoSplash:=True"
This code works fine with Excel 97.
It seems as if the Brio class is not seen in Excel 2000 VBA version, but it gives code leaders when you edit the code.
Has anyone else met or exceeded this problem?
Tx, m6
I have added the brioaddn.xla to the proper library and have added it in. The Excel toolbar indicates that Brio is active.
When we execute a line of VBA code to open a query it chokes.
The line is:
OpenBrioQuery stFilename:="Test.qry";
iWindowStyle:=iWinStyle; fNoSplash:=True"
This code works fine with Excel 97.
It seems as if the Brio class is not seen in Excel 2000 VBA version, but it gives code leaders when you edit the code.
Has anyone else met or exceeded this problem?
Tx, m6
