ScreenUpdating

[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

 

[Alex Dybenko]

to make Excel visible - set excel application object's Visible propert to
true

 

[Guest]

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

 

[Douglas J. Steele]

xlApp.visible = True works for me.

 

[Guest]

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