(1) From Outlook open a Excel-file, but how can i set focus to Excel?

Home	\| General \| General2 \| Contacts \| Calendaring \| Installation \| Printing \| Addins \| Forms \| Forms2 \| Interop \| VBA \| VBA2 \| BCM \| Team Folders \| Third-party Utils

Go back to group page | Go to next unread message | Fixed font

Subject: Re: From Outlook open a Excel-file, but how can i set focus to Excel?
Author: Ken Slovak - [MVP - Outlook]
Date: 09 May 2008
References: 1

Get the workbook as a Workbook object and call its Activate() method.

Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm

"ExcelLars" <lars.oyangen@hamstad.no> wrote in message
news:e632e00e-4371-4f1e-9e8d-64338ed1799d@m44g2000hsc.googlegroups.com...

> How can I set focus to Excel?
>
> On Error Resume Next
> Set objXL = GetObject(, "Excel.Application")
> Err.Clear
>
> objXL.Workbooks.Open FileName:="H:\Outlook\Prosjekt.xls"

Mark all as read

09 May 2008	From Outlook open a Excel-file, but how can i set focus to Excel?	.ExcelLars
09 May 2008	$\$ Re: From Outlook open a Excel-file, but how can i set focus to Excel?	.Ken Slovak - [MVP - O...

All times are in (US) Eastern Daylight Time (GMT -4:00)