Open / Run Application using VBA
 

Gurus,
Can someone please tell me what VBA code I would use to open an application
through a macro in Excel. The application I am trying to open will open
another toolbar within Excel (SAPBEX.XLA) and can be accessed through
"C:\Program Files\SAP\FrontEnd\Bw\sapbex.xla". Any guidence would be greatly
appreciated.
Thanks in advance.

Open / Run Application using VBA
 

Hi

Workbooks.Open "C:\Program Files\SAP\FrontEnd\Bw\sapbex.xla"
would do.

HTH. Best wishes Harald

"mnvkngs" skrev i melding
...
Gurus,
Can someone please tell me what VBA code I would use to open an
application
through a macro in Excel. The application I am trying to open will open
another toolbar within Excel (SAPBEX.XLA) and can be accessed through
"C:\Program Files\SAP\FrontEnd\Bw\sapbex.xla". Any guidence would be
greatly
appreciated.
Thanks in advance.

Open / Run Application using VBA
 

Good morning mnvkngs

This sounds like an add-in and needs setting up in Excel. You don't
really need to do this thru VBA 'cos once it's set up it will open with
excel every time.

Go to Tools Add-Ins, Browse and navigate to the xla file and click
OK. This will put it into the add-ins available list. Make sure it's
checked and click OK.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=480944

Open / Run Application using VBA
 

Good morning mnvkngs

This sounds like an add-in and needs setting up in Excel. You don'
really need to do this thru VBA 'cos once it's set up it will open wit
excel every time.

Go to Tools Add-Ins, Browse and navigate to the xla file and clic
OK. This will put it into the add-ins available list. Make sure it'
checked and click OK.

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=48094