ScreenUpdating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why, when working in Excel from Access with screenupdating = True, do I "see"
the spreadhsheet activity after I open a workbook, but not after I add one?

Is there anything I can do to "force" the Excel App to be visible while I'm
still in Access?

Thanks,
Lee
 
Thanks for the help Alex.

Can you assist with the syntax, please

I've tried
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible
and
xlApp.visble True
and
xlApp.visible = True

Obviously, these are all wrong, as they all produce the dredded Object
doesn't support error.

What's the right way.

Thanks again.
Lee
 
Hey Doug,

No Fair!

When I cut and paste your xpApp.visible = True over my xpApp.visible i= True
it works.

How do you do that?

Thanks. Much appreciated.

Lee
 
Back
Top