Any way to tell if running .ppa or .ppam

[Robie]

Hi

Is there any way to tell if I am calling a routine when .ppa is load or .ppam?
For example, for .ppa I would be calling Auto_Open/Auto_Close but obviously *not* for .ppam. In the .ppam file I am adding a custom tab.

Basically, I am trying to avoid specific code/modules for two version of the addins. Otherwise, I would separate modules for .ppa and .ppam.

The idea is to put something like

Code: Select all

if '.ppa is loaded'
      run the ppa specific code
else
      run the ppam specific code
end if

Thanks
Robie

[HansV]

I'd use separate modules.

[Robie]

I'd use separate modules.

Thanks.