I have an Excel 2003 workbook which I want to publish as an example of how to use a set of accompanying addin functions.
It has cells with comments which are not computed:
'This will convert from latitude/longitude to OS references:
'=osref(datum,latitude,longitude)
and examples which are computed.
=osref(84,C1,D1)
Unfortunately, the examples get changed to
='c:\phil\Application data\Microsoft\addins\osgb.xla'!osref(84,C1,D1)
when I uninstall the addin and/or migrate it to another system which destroys portability.

I've posted this problem with no response (thanks for looking anyway) so plan B was to write a function to strip out the offending junk (there maybe several in a single cell) and use it to re-write every cell with a formula in it. I then call this during the install process.

Unfortunately, when I read the cells I cannot distinguish between the comments and the real formulae. In its simplest form:

Please Login or Register  to view this content.
This is stripping out the initial single quote from any comment cells.
Why is this and how can I identify these comment cells?

Generating this addin sounded so straightforward!

Regards
Phil