| Author |
Message |
mashpotato
Senior Member
Joined: 20 Sep 2005
Posts: 42
Location: Atlanta, GA, U.S.A.
|
 Posted: Tue Sep 20, 2005 4:24 pm
Post subject: I can't use VBA macro (please HELP!!!!!) |
|
|
I'm using a BusObj6.5 client, and I need to edit a report that has VBA macros. When I download the report from our server, BO promts me that I won't be able to run the report since I don't have VBA installed. Is this a download that I can get from BusinessObjects? Please let me know where and how I can install this as part of my BusinessObjects6.5 client. By the way, I installed BO from a shared installation (BO server). Thanks!!!!!
Last edited by mashpotato on Wed Sep 21, 2005 10:14 am, edited 3 times in total |
|
| Back to top |
|
|
srinath2003
Principal Member
Joined: 05 Jan 2005
Posts: 394
|
Posted: Tue Sep 20, 2005 4:33 pm
Post subject: Re: using macro w/ VBA (Visual Basics for Applications) |
|
|
You must insert the BO CD again and then select VBA and install it...
Srinath |
|
| Back to top |
|
|
mashpotato
Senior Member
Joined: 20 Sep 2005
Posts: 42
Location: Atlanta, GA, U.S.A.
|
Posted: Tue Sep 20, 2005 4:43 pm
Post subject: Re: using macro w/ VBA (Visual Basics for Applications) |
|
|
| This (my client BO software) was an install from our BO server. Is there a way for me to download this add-in from BO website, or is our BO admin (the only one /w the cd) my only option? Thanks! |
|
| Back to top |
|
|
srinath2003
Principal Member
Joined: 05 Jan 2005
Posts: 394
|
Posted: Tue Sep 20, 2005 4:54 pm
Post subject: Re: using macro w/ VBA (Visual Basics for Applications) |
|
|
You cannot install from BO Website...Basically, when you install ,it will ask you to select the tools (Reporter,Designer,VBA...) you need to install and selected tools will get installed in your machine....I think,VBA option was unchecked when you installed it...
Srinath |
|
| Back to top |
|
|
Anita Craig
Forum Groupie
Joined: 17 Jun 2002
Posts: 8541
Location: Palo Alto, California, U.S.A.
|
Posted: Tue Sep 20, 2005 5:35 pm
Post subject: Re: using macro w/ VBA (Visual Basics for Applications) |
|
|
Moving from Reporter (for questions about building queries/reports), since this is more of an installation issue.
When you say this was a from a shared installation (BO server) -- do you mean a shared file server, or is this a ZABO installation from a WebIntelligence server?
_________________
Anita Craig Image link
Institutional Research & Decision Support
Stanford University Image link
____________________
Search is Your Friend™ |
|
| Back to top |
|
|
mashpotato
Senior Member
Joined: 20 Sep 2005
Posts: 42
Location: Atlanta, GA, U.S.A.
|
Posted: Wed Sep 21, 2005 8:12 am
Post subject: Re: using macro w/ VBA (Visual Basics for Applications) |
|
|
| I'm reluctant to say anything since I'm not particularly sure, but my best guess is that it's an installation from a webintelligence webserver. Can you ->(ANITA) explain to me what's going on (OR ANYONE ELSE)? |
|
| Back to top |
|
|
Dwayne Hoffpauir
Forum Groupie
Joined: 19 Sep 2002
 *2 *5
Posts: 8630
Location: Plano, TX USA
|
Posted: Wed Sep 21, 2005 8:36 am
Post subject: Re: using macro w/ VBA (Visual Basics for Applications) |
|
|
| mashpotato wrote: | | I'm reluctant to say anything since I'm not particularly sure, but my best guess is that it's an installation from a webintelligence webserver. Can you ->(ANITA) explain to me what's going on (OR ANYONE ELSE)? |
If the installation was done from InfoView ... known as a ZABO installation ... there is a specific step that asks to install VBA support. It's a relatively common occurence that users fail to include VBA support when doing a ZABO installation.
_________________
Dwayne Hoffpauir
Image link |
|
| Back to top |
|
|
mashpotato
Senior Member
Joined: 20 Sep 2005
Posts: 42
Location: Atlanta, GA, U.S.A.
|
Posted: Wed Sep 21, 2005 9:00 am
Post subject: Re: using macro w/ VBA (Visual Basics for Applications) |
|
|
| It is an infoview installation; however, it doesnt provide me that option during the installation. I reinstalled it so that I could check...and no, it's not an option during the installation. What else could it be...? |
|
| Back to top |
|
|
Dwayne Hoffpauir
Forum Groupie
Joined: 19 Sep 2002
*2*5
Posts: 8630
Location: Plano, TX USA
|
Posted: Wed Sep 21, 2005 10:27 am
Post subject: Re: using macro w/ VBA (Visual Basics for Applications) |
|
|
| mashpotato wrote: | | It is an infoview installation; however, it doesnt provide me that option during the installation. I reinstalled it so that I could check...and no, it's not an option during the installation. What else could it be...? |
I have seen occasions where getting VBA support installed has been problematic. There are some manual install procedures floating around, but their success was hit or miss as well. For those rare occasions where VBA install was a problem, it was easier to simply re-image the machine.
The other possibility is a Supervisor restriction. In the Programmability section of the BusinessObjects command restrictions, there is a setting that controls whether VBA is downloaded as part of the ZABO installation. Have you tried on another PC? That would determine whether it is a Supervisor issue, or a workstation issue.
_________________
Dwayne Hoffpauir
Image link |
|
| Back to top |
|
|
mashpotato
Senior Member
Joined: 20 Sep 2005
Posts: 42
Location: Atlanta, GA, U.S.A.
|
Posted: Wed Sep 21, 2005 12:28 pm
Post subject: Re: using macro w/ VBA (Visual Basics for Applications) |
|
|
| Yes, you solved my problem! Thanks! It was the Supervisor setting. After setting it to '1' or enable and redownloading the installation, I was able to work with the VBA macro. Thanks once more!! |
|
| Back to top |
|
|
Dwayne Hoffpauir
Forum Groupie
Joined: 19 Sep 2002
*2*5
Posts: 8630
Location: Plano, TX USA
|
Posted: Thu Sep 22, 2005 8:17 am
Post subject: Re: using macro w/ VBA (Visual Basics for Applications) |
|
|
| mashpotato wrote: | | Yes, you solved my problem! Thanks! It was the Supervisor setting. After setting it to '1' or enable and redownloading the installation, I was able to work with the VBA macro. Thanks once more!! |
Glad to help ... 
_________________
Dwayne Hoffpauir
Image link |
|
| Back to top |
|
|
Anita Craig
Forum Groupie
Joined: 17 Jun 2002
Posts: 8541
Location: Palo Alto, California, U.S.A.
|
Posted: Thu Sep 22, 2005 4:56 pm
Post subject: Re: using macro w/ VBA (Visual Basics for Applications) |
|
|
| mashpotato wrote: | | Can you ->(ANITA) explain to me what's going on (OR ANYONE ELSE)? |
I'm sure glad Dwayne answered you -- I've been swamped and haven't been on much. It's always good to just reply with your question, and hope that someone (not necessarily the previous respondent) can continue the thread -- not one particular participant! 
_________________
Anita Craig Image link
Institutional Research & Decision Support
Stanford University Image link
____________________
Search is Your Friend™ |
|
| Back to top |
|
|
mashpotato
Senior Member
Joined: 20 Sep 2005
Posts: 42
Location: Atlanta, GA, U.S.A.
|
Posted: Thu Sep 22, 2005 9:06 pm
Post subject: Re: using macro w/ VBA (Visual Basics for Applications) |
|
|
I just pointed you out since you seem to be a veteran of BO. I'm certainly glad to know this forum and able to receive help/advise/tricks .  |
|
| Back to top |
|
|
martin_black
Senior Member
Joined: 04 Mar 2008
Posts: 50
Location: Ochil House, Stirling
|
Posted: Wed Jun 02, 2010 6:26 am
Post subject: Re: using macro w/ VBA (Visual Basics for Applications) |
|
|
Is the same option available in BO XI R2 install (include VBA)?
My external PC support team keep re-installing XI without the VBA code, and I've no experience of the install myself to advise them.
_________________
--------------------------------------------------
BO XI R2 SP2 FP2.5 (11.5.8.1030)
MS SQL Server 2000 |
|
| Back to top |
|
|
|
