Runnng excell 2003 from access 2000

[Patrick]

I am using access 2000. When I open an excel file (ver 2003) (there is an
add on called "@aglance") this add on is displayed in the menu system of
excel when i open excel in normal mode (ie run the program from windows).

However, when i open excel using msaccess via vba, this add on does not
appear an an option in the menu for the excel (actual file not yet open,
just excel). a macro within the excel file requires that the add be present.
but no matter what i do i cannot seem to get the add on to appear when i
open excell from access.


any thought welcome


pat


any help greatly appreciated



Pat

 

[Tom van Stiphout]

On Mon, 17 Nov 2008 22:56:00 -0800, Patrick

How are you opening Excel? I'm guessing using CreateObject. This may
be one of those rare cases where you want to Shell it, followed by
GetObject for more Automation.

-Tom.
Microsoft Access MVP