|
|
|
|
| Author |
|
|
Somewhere in the Midwest
Join Date: Oct 2001
Location: In the barn!
Posts: 12,499
|
Excel Add-in VBA (.xla file) help please
My IT guy isn't much help, but I though some of you guiys here can help.
I got a new laptop and I have an old Excel program with an Add-in. Both were created years ago and will not run on my new machine with Excel 2007. I have problems as described here: You are requested to "search Microsoft Office Online for "VBA Converters" when you try to open or save a workbook in Excel 2007 or Excel 2010 I downloaded the converter adn followed the instructions and no dice. I've put the .xla file in the right place (I've had to do this before) but I keep getting an Add-in that is in the wrong place. It's like the lasted program is assignning location and I and chasing it to replace it or change it's location. Any help guys? |
||
07-12-2012, 11:09 AM
|
|
|
Somewhere in the Midwest
Join Date: Oct 2001
Location: In the barn!
Posts: 12,499
|
So here is my string...
=E15*(G7+14.73)/14.73*520/(460+G8)*'C:\Program Files\Microsoft Office\Office\Library\FPV.XLA'!Fpv(G7,G8,G9,G10,G1 1)^2/1000 I'm trying to point to a file named "FPV.XLA" to return the fpv for values in cell G7,G8,G9,G10,G11. I didn't create the .xla file, but I assume it is not corrupt. In the past when I upgraded machines, I just stored the .xla file in the correct directory and pointed the Excel add-in to that directory and it worked, but now I can't seem to make it work. Help please! |
||
|
07-12-2012, 02:20 PM
|
|
