Switch to Excel in Code

[Norbert]

Please.
I open an Excel object in Access and write data out to
it. The object is invisible. However at the end of the
process I provide a dialog box giving the user the option
to View the Excel workbook or not.

Is there code to switch to Excel for viewing?

much thanks.

 

[TC]

If objExcel is your excel object, try:

objExcel.visible = true

Does Excel have an Activate method? (I do not have it here to check):

objExcel.activate

Or, check out the AppActivate statement in VBA.

HTH,
TC