Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet will not open without Excel Application being open fir | Excel Discussion (Misc queries) | |||
Open an external application | Excel Discussion (Misc queries) | |||
Can Excel open a new application every time you open a file? | Setting up and Configuration of Excel | |||
Open Application Error? | Setting up and Configuration of Excel | |||
Can not open excel files without open application | Excel Discussion (Misc queries) |