Last week I have sent out the ASAP Utilities newletter with information about the two new versions:
ASAP Utilities released its new versions 4.0.5 and 3.10E!
www.asap-utilities.com/asap-utilities-newsletter-2006-11.php
More information about our mailinglist:
www.asap-utilities.com/asap-utilities-mailinglist.php
Hello Kanwaljit,
You are right. Excel should somehow be able to refer to files just as websites do, relative referencing. It will work only if the file is in the same folder but otherwise Excel makes the link to the full path and filename.
http://support.microsoft.com/?id=328440
At this moment I'm working for a project that has this issue too. I will see how I can adept a usefull solution into ASAP Utilities.
After a few searches in the Newsgroups I found out that Laurent Longre's formula package contains a worksheet function that allows you to use relative referencing to other workbooks:
http://xcell05.free.fr/english/index.html
http://xcell05.free.fr/english/morefunc/indirect.ext.htm
I'm now curious if Microsoft has changed this behaviour in Excel 2007.
Kind regards,
Bastien Mensink
Dear Bastein,
Kindly consider release of 4.0.5 as pure XLA file in zip format rather than a XLA/DLL file as a setup
The mixed version is not usable in office…. I am forced to use 3.10E despite having Excel 2003
Best Regards
Sam
Hi Bastien,
Delighted to learn that you are considering the relative referencing option in ASAP utilities. May you succeed. I doubt that no such change has taken place in Excel 2007
Kind Regards
CA Kanwaljit Singh Dhunna
(Chartered Accountant)
India
kanwaljit
Hi Bastien,
May you live 1000 years …!!!! Many a times we need to shift files from one location to another. and Many a times these files include formulae having external references. I always longed for one option which will convert formulae in such a way that they references don't change if we move files and after moving files we can reconvert them to there origianl shape.
Regards
Kanwaljit