By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,156 Members | 989 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,156 IT Pros & Developers. It's quick & easy.

Opening Excel from Access so the Cognos Analyst menu shows

P: n/a
I have an Access application that needs to open an Excel workbook
which has Cognos links in it. When I open the Excel workbook with the
Cognos links in it using Excel, the Cognos Analyst menu is there.
However, when I open the Excel workbook from Access VBA by creating an
instance of Excel using Set objXL = CreateObject("Excel.Application")
and then using objXL.Open to open the Excel workbook, the Cognos
Analyst menu is not there. I found that if I use the Shell command to
open Excel and the Excel template file, then the Cognos Analyst menu
is there, but now I need to know how to set the objXL object variable
to the Excel instance I opened with Shell.

Jun 14 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.