LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Problems with add-in after upgrading from Excel 2003 to 2007

Hello!

I have developed an Excel add-in for a customer. The add-in enables
users to retreieve data from a database by using WorkSheet formulas.

The User writes in a cell
=Quote('31/12/2009';'MSFT')
and Microsofts stock quote shows up.

Some users in the company does not have the add-in installed.
When using Office 2003 and opening up a workbook using the formulas,
they were still able to see the values in the cell, provided that just
clicked no when asked to update external links.

After uppgrading to Office 2007 users without the component are no
longer able to see the quotes, even when they don't update links.
Instead #VALUE is displayed.

In the cell the formula has changed to
='C:\Program Files\QuoteManager\qm.xla'!Quote('31/12/2009';'MSFT')

This is where the add-in is installed normally.

Why doesn't it work anylonger?

The workbook is still saved as xls, not xlsx!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Run-time error 1004 since upgrading from Excel 2003 to 2007. PJ Excel Programming 1 July 23rd 08 11:55 PM
Add Ins and upgrading from 2003 to 2007 Robert Excel Discussion (Misc queries) 1 February 14th 07 03:38 PM
ACCTINTM problems after upgrading to Excel 2003 Andrew Edwards Excel Worksheet Functions 1 February 26th 06 01:48 AM
Upgrading Problems: Excel from 2000 to 2003 Larry Juker Excel Worksheet Functions 2 November 2nd 04 06:50 PM
Excel upgrading = code problems Frank Kabel Excel Programming 0 May 20th 04 04:19 PM


All times are GMT +1. The time now is 01:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"