excel personal file not working

[toplad]

Hi,

Any ideas for this strange problem that's happening. I've got an excel personal file that works fine (able to run all the macros i have in it) when i open excel normally. However when it's opened by another program that drops some data into the first sheet the macros that are available normally isn't available for use. Its like it forgets to run the personal excel file when its opened this way. Annoying because i wrote the macro to be used with this data dump. Does anyone have any ideas why this might be happening?

 

[Kenneth Hobson]

Is the XLSB in the startup folder?

Debug.Print Application.StartupPath

Run and press Ctrl+G after to see result. Paste into Explorer (Win+E).

 

[toplad]

thanks i'll give that a try tomorrow morning

 

[toplad]

Hi Ken, the personal is in the right location. i'm baffled as to why its doing it

 

[Johnny C]

Have a look in your file associations, under the suffix for Excel files. See if there's any parameters in the start up string and remove them, there may be one that tells Excel to start in a secure mode (which stops macros running)

Also have a look at your trust centre settings, maybe one of those tells Excel to disable any macros when started remotely.

Just an idea or 2, it sounds like Excel is starting up in a secure mode of some sort.

 

[Kenneth Hobson]

1. Just to be sure, make a simple macro in a Module.
2. Is the folder shared with those using it.
3. Last resort and maybe best anyway, make it into an AddIn.