AppActivate works in Excel 2007 but not in 2010

excel vba switch between applications
vba set focus to another application
vb6 appactivate
vba appactivate internet explorer
excel vba appactivate chrome
appactivate vbscript
vba activate excel window
application wait not working

I have a excel macro that I run in Excel 2007 and it opens a mainframe application so I can import data from my spreadsheet automatically.

This has been working fine, however it doesn't work in Excel 2010.

I have tried using the shell command to use the ID but the other application is a mainframe application and non windows based.


AppActivate "Title" (to open the mainframe application) was working fine in excel 2007.

In Excel 2010 I am getting a Run-time error 5 - Invalid procedure call or argument.

I've been trying to solve this for two days and it all works fine on 2007 version.

Any help would be really appreciated.

Dim appName as String

appName = Range("AppName").Value 'this is a name stored in my excel spreadsheet for the mainframe app

AppActivate (appName) => this line is giving runtime error '5' invalid procedure call or argument

If you want to return the focus back to the Excel where your VBC code lies, aka ThisWorkbook object, then you can use the following line:

AppActivate Title:=ThisWorkbook.Application.Caption

AppActivate stopped working, I have the following code in a macro which used to work: AppActivate "Microsoft Word" Joined: Jan 7, 2007 continue the macro, it happily deals with the last line and returns focus back to Excel. If your Microsoft word program is not open it will give you the Run time error 5 message. Feb 13, 2010. #3. Re: AppActivate "Excel" not working AppActivate requires the full title as it appears in the title bar of the Window you want to activate 'Excel' never appears as the title in an Excel window unless you set it using the Caption property.

I found this code, hope it helps:

Dim Myself as string
Myself = activewindow.caption

Then AppActivate(Myself) would take focus back to the original spreadsheet.

After the "upgrade", however, the AppActivate line started giving me errors, and I finally figured out that if I only had a single open spreadsheet, the title in the Windows Task Bar was just "Microsoft Excel".

I made a temporary fix by changing to

Myself = "Microsoft Excel - " & activewindow.caption

MS Project 2013 VBA Macro - AppActivate "Microsoft Excel , The start screen no longer shows if I open Excel 2013 manually, but the macros still stop Any ideas why this statement isn't working for MS Project 2013? WhenExcel 2007 is launched the title bar opens as "Book1 - Microsoft Excel". It also seems to work using this for both Office 2010 and Office 2016:. Remarks. The AppActivate statement changes the focus to the named application or window but does not affect whether it is maximized or minimized. Focus moves from the activated application window when the user takes some action to change the focus or close the window.

This error comes when the AppActivate doesn't get exact title. You can try below code and see if it helps you.

    Public Sub AppActTest()
    Dim objWd As Object
    Dim objTsk As Object
    Dim blOpenedByCode As Boolean

    On Error Resume Next
    Set objWd = GetObject(, "Word.Application")
    If objWd Is Nothing Then
        Set objWd = CreateObject("Word.Application")
        blOpenedByCode = True
    End If
    On Error GoTo 0

    For Each objTsk In objWd.Tasks
        If InStr(objTsk.Name, "MainframeApplicationName") > 0 Then
            objTsk.WindowState = wdWindowStateMaximize
            Exit For
        End If

    If blOpenedByCode Then objWd.Quit

    Set objTsk = Nothing
    Set objWd = Nothing

    End Sub

It will require Microsoft Word to be installed on your computer. It will work with partial match.

AppActivate statement (VBA), not work now. I get an error code 5941 requested member does not exist. Created on August 5, 2010. Activate window from vba not working with Word 2007. I have an Excel workbook (32-bit) with Macros that works perfectly in Excel 2010, but the Macros stop working in Excel 2016 (32-bit, Office 365, but a local install of Excel). I have tried loosening up security on the Macros (allowing all to run), and changing all security in general to as low as possible, but the issue persists.

Thanks for the answers, I only found out later that my users were launching the Excel 2016 version from a remote location, so the application they were trying to open could obviously not be found. The previous version of Excel was launched from their desktop so it worked.

In a nutshell, the AppActivate function works fine for both Excel version.

Thanks for your time.


Activate window from vba not working with Word 2007, Macro Working on excel 2007 do not work in excel 2013 code) that works perfectly on Excel 2007, but when I try tu run it on excel 2013, i have several errors. I perfectly know that the code works perfectly, if not will never run un excel 2007. The debug error occurs on line "AppActivate ("Microsoft excel")". Excel is not responding. Excel has stopped working. A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available. Resolution. Use the following methods in the order in which they are presented. If you try one of these methods and it does not help, go to the next method.

I use this macro to open Bookmarks from Excel 2010 in Firefox.

It has worked - then sometimes it doesn't work (Run-time error 5)

I see the fix as: close & re-open Firefox, then try it - works

What gets messed up, so it doesn't work?

Sub Open_a_Bookmark(control As IRibbonControl)

' Open a Bookmark in Firefox . . . Firefox has to be open for this to work

' Go to the Row of the bookmark you want, then click this button.
' It automatically goes to the URL column, and copies it.
    Cells(ActiveCell.Row, "BK").Activate

' Open a new tab in Firefox with Ctrl+T
    AppActivate "Firefox"
    SendKeys ("^t"), True

' Sometimes you have to click this macro again, to get it to work, because the "paste" doesn't get to Firefox.
' Give it a second before pasting
    Application.Wait (Now + TimeValue("00:00:01"))

' The focus defaults to the Address Bar.  Paste the URL / Enter
    SendKeys ("^v~"), True

' * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

' See the bottom of "Process_Bookmarks" for details.  Used at the end of macros, when necessary.

    SendKeys "{NUMLOCK}", True

    Application.Wait (Now + TimeValue("00:00:01"))
    Selection.Borders(xlEdgeBottom).LineStyle = xlNone

' * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 
End Sub

Macro Working on excel 2007 do not work in excel 2013, Wiley Publishing, Inc., is not associated with any product or Chapter 9: Working with VBA Sub Procedures . Using AppActivate . Although. Excel 2007 and Excel 2010 are radically different from their predecessors, the VBA environment. Microsoft Excel Objects Sheet1 (Sheet1) Sheet2 (Sheet2) Sheet3 (Sheet3) ThisWorkbook Modules Module1 If you double-click one of the worksheet names or ThisWorkbook, you can type code in the code window. Such code not contained within a Visual Basic module is considered to be "behind" the worksheet or ThisWorkbook.

[PDF] Excel 2010 Power Programming with VBA, When you push Excel to the background, it loses out on the boost it priority when working on these very intensive workbooks might make sense, and I would which is only available for 2010 onwards start "high priority excel" /max /high EXE" ) Note that the title for the window can be anything you like, but is not optional. Sub SLM_With_Mail() ' Works in Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Outlook 2000, Outlook 2002, Outlook 2003, Outlook 2007, Outlook 2010.

How do you keep Microsoft Excel running at full speed even when it , AppActivate works in Excel 2007 but not in 2010 我有一个在Excel 2007中运行的excel宏,它会打开大型机应用程序,因此我可以自动从电子� Activating the Excel "Help" button is something that you can easily do right from the ribbon toolbar. Activate the Excel "Help" button with help from a Microsoft Certified Applications Specialist

vba, AppActivate works in Excel 2007 but not in 2010 � vba excel-vba excel-2010 office-2010 excel. MoveAfterReturnDirection = xlDown 'set return direction when �