View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Madan Madan is offline
external usenet poster
 
Posts: 3
Default Excel 2007 not in foreground when launched in Vista or Windows 7

Hello,

I used the following code to launch excel 2007 in Vista or Windows 7 through
automation:

Dim objExcel As Object
Set objExcel = CreateObject("Excel.Application")

'Check whether Excel is installed
If objExcel Is Nothing Then
MsgBox "MS Excel is not installed", vbOKOnly
Else
With objExcel
.Workbooks.Open <filename
.UserControl = True
.Visible = True
End With
End If

Excel is launched but does not come to the foreground as it used to be in
Windows XP or windows 2003 server.

NOTE: I found the same effect when i launch Word 2007 in Vista, Windows 7
and Windows 2008 server. Also I tested office 2003 in Vista and i have the
same effect ... It seems that this behaviour is caused by Vista based OS.

Does anyone have the same problem?
Any solution for it?

Thanks in advance!
Madan