[AccessD] How would you show an Excel window?

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
>