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

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,536

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 »

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 03:32 AM.