Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AppActivate Error
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AppActivate Error
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 "Hayeso" wrote: 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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
AppActivate Error
Hi Hayeso,
Try: AppActivate Application.Caption --- Regards, Norman "Hayeso" wrote in message ... 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 "Hayeso" wrote: 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AppActivate runtime error 5 when used with shell cmd | Excel Programming | |||
AppActivate | Excel Programming | |||
Problem with AppActivate. | Excel Programming | |||
appactivate | Excel Programming | |||
appactivate | Excel Programming |