467,154 Members | 685 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,154 developers. It's quick & easy.

Opening Excel from Access so the Cognos Analyst menu shows

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
  • viewed: 1760
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Vishal | last post: by
reply views Thread by wxqun@hotmail.com | last post: by
reply views Thread by wxqun@hotmail.com | last post: by
reply views Thread by peejay750 | last post: by
16 posts views Thread by Phil Stanton | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.