[AccessD] How would you show an Excel window?

Philippe:

I use 

' Make the spreadsheet visible
    objXLApp.Visible = True

To do that.   

Where I create objXLAPP as a new workbook:

' Create Excel Spreadsheet
Set objXLApp = New Excel.Application
objXLApp.Workbooks.Add
Set objXLWS = objXLApp.ActiveSheet

Having DIMmmed:

' Object variables for Automation stuff
Dim objXLApp As Excel.Application
Dim objXLBook As Excel.Workbook
Dim objXLWS As Excel.Worksheet

HTH

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Philippe Pons
Sent: Wednesday, December 04, 2013 4:33 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] How would you show an Excel window?

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