Switch to Excel in Code

  • Thread starter Thread starter Norbert
  • Start date Start date
N

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.
 
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
 
Back
Top