I've been researching a problem that appears to be related to Windows Vista, and am looking for help/guidance from any Notes <-> Office integration experts out there in Notes community.
When I run the following code within Windows XP, the Excel spreadsheet is opened and maximized on the user's desktop. However, when I run the same code on Windows Vista, the Excel spreadsheet is opened but minimized in the Task Bar.
Const FILEPATH = "c:\Temp\Issues.xls"
Dim o As Variant
Dim oWB As Variant
Set o = CreateObject("Excel.Application")
o.EnableEvents = False
o.DisplayAlerts = False
Set oWB = o.Workbooks.Open ( FILEPATH )
o.Visible = True
I know I can use ActivateApp to resolve this, but that would require updating a lot of existing code. Is there is a setting or a preference in Windows Vista that would restore the behavior users had with Windows XP and prior?
I've registered myself with the Bleeding Yellow site and am connected to the ST community. The people currently logged in is a virtual "who's who" in the Lotus Notes blogging community. I haven't chatted with anyone yet, but its nice to know that there is a site where I can easily reach someone if I need advice.
Thanks to all of those at Lotus911 for making this possible!
NOTE: After registering and looking around the Bleeding Yellow community, I didn't see any instructions for setting up my ST client. (I'm sure that in my excited state I missed that particular page.) Alan Lepofsky has blogged about how to set up your ST client to include the Bleed Yellow community.
Su | Mo | Tu | We | Th | Fr | Sa |
|---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | ||
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 | 31 | ||