[AccessD] How would you show an Excel window?

Paul,

Thanks a lot!
It works like a charm!
Philippe


2013/12/4 Paul Hartland <paul.hartland at googlemail.com>

> ah I had a similar problem a couple of years back, can't remember the exact
> code I used to bring the window to the front but have found this link which
> may point you in the right direction
>
> http://www.everythingaccess.com/tutorials.asp?ID=Bring-an-external-application-window-to-the-foreground
>
> Paul
>
>
> On 4 December 2013 13:07, Philippe Pons <phpons at gmail.com> wrote:
>
> > Hi Paul,
> >
> > Yes, the Excel library is referenced, and I have pointers to the Excel
> app
> > as well as to the workbook and to the worksheet.
> > But doing wkb.Activate or sh.Visible=True will not place the Excel window
> > on top of the other.
> > In Excel, you can write Application.Windows("windowName").Activate
> > but I see nothing similar in Access.
> > Any idea?
> > Thank's,
> > Philippe
> >
> >
> > 2013/12/4 Paul Hartland <paul.hartland at googlemail.com>
> >
> > > Philippe,
> > >
> > > Would be useful to see the code your using, but I would imagine if your
> > > using Access to highlight selections in Excel you must have a data link
> > of
> > > some sort to the Excel sheet, couldn't you just make the excel workbook
> > > visible in your code ?
> > >
> > > Paul
> > >
> > >
> > > On 4 December 2013 12:33, Philippe Pons <phpons at gmail.com> wrote:
> > >
> > > > Hi all,
> > > >
> > > > I need your help!
> > > > I have an Access 2010 application that uses data stored in an Excel
> > file.
> > > > The Access app. opens the Excel file.
> > > > The user will do some selections, and then I want he can click on a
> > > button
> > > > to see
> > > > the selections in the Excel worksheets.
> > > > The Access app. can highlight the selection in Excel, but can't show
> > the
> > > > worksheet to the user.
> > > > How would you do that?
> > > > TIA,
> > > > Philippe.
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > >
> > >
> > >
> > >
> > > --
> > > Paul Hartland
> > > paul.hartland at googlemail.com
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
>
> --
> Paul Hartland
> paul.hartland at googlemail.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>