Macro to determine if word or excel application is being used

		Microsoft Office Forums > Microsoft Word > Word VBA
Macro to determine if word or excel application is being used

FAQ

Mark Forums Read

Thread Tools

Display Modes

04-01-2014, 05:31 AM

Charles Kenyon Charles Kenyon is offline

Windows 7 64bit Macro to determine if word or excel application is being used

Office 2010 32bit

Moderator

Join Date: Mar 2012

Location: Sun Prairie, Wisconsin

Posts: 9,584

Code:

Sub whichApp()
  dim sApp as String
  sApp = Application.Name
  msgBox "Application is " & sApp
End Sub

Have a test for the value of sApp. It will be either "Microsoft Word" or "Microsoft Excel." Or, you could pass sApp as a parameter to your called procedure.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
application wide macro	ronaldo.k	PowerPoint	1	11-21-2013 11:31 AM
cannot start the source application for this object - Excel	charlesmac	Excel	3	08-15-2012 05:22 AM
A word macro application	Hikmetotheron	Word	3	04-26-2011 02:01 PM
Macro to determine attached template	zippyaus	Word VBA	0	03-02-2010 02:05 AM
Excel 2003 will not terminate with application.quit	Peter Schellenbach	Excel	12	03-14-2006 05:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:56 PM.