Before calling CreateObject check if GetObject returns an object. If it
does, see whether the file is already in the Workbooks collection before
calling Workbooks.Open.
the code runs great from outlook and is much quicker with the spreadsheet open
one thing i would like but cant get is to bring the excel spreadsheet to the
front after inseting the data as there is a field i need to manual update.
i have tried all the variations i can think of on MyApp and MyApp.workbook
ie select,show,visible.activate but cant get the spreadsheet to the front
That's how it works as Excel is another process, and the last line of code
executed is always in Outlook, which brings Outlook up to the front. You
could minimize the current Outlook window, or use some Win32 API functions
in order to find the Excel window.
Am Mon, 4 Jan 2010 07:51:01 -0800 schrieb pete the greek:
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.
