[AccessD] How would you show an Excel window?

Paul Hartland paul.hartland at googlemail.com
Wed Dec 4 07:31:33 CST 2013


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


More information about the AccessD mailing list