Create hyperlink of a file into a cell of Excel

Burot

Hi my friends,

Im using NAV 5.0 and I would like do something like that:

When we recive purchase invoices from our vendors, we scan those documents and we save them in pdf format. Then we attach the pdf file to Navision using the "Link" functionally (table 2000000068 Record Link). No problems with that.

Now we want export Report 10705 "Purchases Invoice Book" to Excel. No problem with this, I use the table 370 "Excel Buffer" and functions to export the report.

The problem comes now, we would like insert in that Excel sheet a new column with a hyperlink to the pdf file of the invoice.
I have seen if you write in a cell of Excel:

file:///c:\Directory\file.pdf

Excel understands that is a hyperlink and it works very well, if you push it then the pdf file appears.
I have tried to use T370 "Excel buffer" like this:


rBufferXCL.INIT;
rBufferXCL.VALIDATE("Row No.", 1);
rBufferXCL.VALIDATE("Column No.", 1);
rBufferXCL."Cell Value as Text" := 'file:///c:\Directory\file.pdf';
rBufferXCL.INSERT(TRUE);

but when Navision finishes to export the report, Excel undestands that new column is a text and not a hyperlink

In T370 there is only 3 fields we can use:
"Cell Value as Text"
Formula
Comment

but there isnt a "Cell like hyperlink" so that is the problem

Do yo know how i can create a hyperlink to a file into a cell of Excel from Navision?

Thanks a lot and i beg your pardon for my poor english