Show Access window with Excel Open

C

Candyman

I am posting data to Excel from access. The code Opoens Excel and shows that
application. If the cod ein Access jams how do I view the Access window to
see the error message?

My error message works, but I am still looking at Excel?

Set xlsApp = CreateObject("Excel.Application")
xlsApp.Application.Workbooks.Open TemplateFile
xlsApp.Application.Visible = True
xlsApp.Application.DisplayAlerts = False

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top