AppActivate Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The following line of code works when I use Excel 2003 SP1 but when I try to
use it in Excel 2003 SP2 then I get an "Invalid Procedure Call" Error

AppActivate (Application.Name)
 
Fixed it myself.

The issue has to with the difference between the Excel Application name and
what appears In the Excel Title Bar. The Application Name is "Microsoft
Excel". The Text in the title bar is "Microsoft Excel - MyWorkbook.xls"

I worked around it by changing the code to read
AppActivate (Application.Name) & " - " & thisworkbook.name
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Application Name differences between Excel 2003 and 2007 3
AppActivate syntax and question 2
Excel 2007 Macro w/ AppActivate = Run-time error '5': Invalid procedure call or argument 4
AppActivate problem 3
AppActivate syntax - help needed 1
Why doesn't this work on other computers? 2
AppActivate for IE not working 3
Excel VBA and Sendkeys Office 2003 under XP vs Office 2007 under V 4

Back
Top