XLSSTART\ does not works when Excel is launched from other application

[Vliegenmepper]

Hi There,

I've created a Macro and placed it into the XLSSTART directory. Everytime Excel is opened the Macro button appears. So far so good.
From within Navision we have an option that converts data to an Excel sheet, this option starts Excel and fills the tables. Problem with this is that when Excel is started from Navision, the Macro button doesn't appear.

Consequently I'm thinking that Excel doesn't refer to the XLSSTART directory when it 's started with an API-call from another application?

Someone know how I can arrange things so that the Macro is available even when Excel is launched via another application?

Cheers,
Kenneth

[Bob Phillips]

You will need to explicitly open it.

--
HTH

Bob Phillips

"Vliegenmepper" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi There,
>
> I've created a Macro and placed it into the XLSSTART directory.
> Everytime Excel is opened the Macro button appears. So far so good.
> From within Navision we have an option that converts data to an Excel
> sheet, this option starts Excel and fills the tables. Problem with this
> is that when Excel is started from Navision, the Macro button doesn't
> appear.
>
> Consequently I'm thinking that Excel doesn't refer to the XLSSTART
> directory when it 's started with an API-call from another
> application?
>
> Someone know how I can arrange things so that the Macro is available
> even when Excel is launched via another application?
>
> Cheers,
> Kenneth
>
>
> --
> Vliegenmepper
> ------------------------------------------------------------------------
> Vliegenmepper's Profile:
http://www.excelforum.com/member.php...o&userid=27273
> View this thread: http://www.excelforum.com/showthread...hreadid=467801
>