Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel 2007 in Win7 - add-in files (xla) not working

Jul 9, 2010 10:39AM PDT

I have Excel 2007 in Vista. I created an excel add-in file for a friend using the xla extension (for older excel versions). It adds steam table functions to use in spreadsheets. It works just fine on my Vista laptop.
I sent it to my friend who installed it in Excel. It shows up as an add-in but doesn't work. Opening VB, the Visual Basic Project shows up but without the module with the functions/code in it. We exported just the module as a BAS file and tried importing it into the VBAProject and after three tries, magically three copies showed up in the VBAProject. Deleting the extras the program's functions worked. Close excel, open it again and poof, no more module/code. Does anyone have any suggestions to get it to stick.

Discussion is locked

- Collapse -
Just a suggestion for a work-around.
Jul 9, 2010 11:03PM PDT

1. Create a function in Excel 2007 itself (no import, just type a short one). Does it stick?
2. If yes, create all functions and copy/paste the contents into them.

Kees

- Collapse -
Suggested Work Around
Jul 10, 2010 1:04AM PDT

Kees,
Thanks, good suggestion. I've sent him an xlsm file with the functions in it.