DDE Support

Aspose.Cells Product Family
1

Hi,

I am having trouble using a DDE formula in my application. I always get an error or the value of the cell gets set to =#N/A. Any help or workarounds would be great. Here is my code...

Dim cells_license As Aspose.Cells.License = New Aspose.Cells.License

cells_license.SetLicense("Aspose.Cells.lic")

Dim workbook As Workbook = New Workbook

Dim worksheet As Worksheet = workbook.Worksheets(0)

Dim cells As Aspose.Cells.Cells = worksheet.Cells

Dim cell As Cell = cells("A1")

'cell.Formula = "=PROPHETX|QUOTE!\'CZ0[DTN:CBOT]?Last\'"

cell.Formula = "=PROPHETX|QUOTE!'CZ0[DTN:CBOT]?Last'"

MsgBox(cell.Value)

workbook.Save("C:\Users\Cletis & Kerri\Desktop\test.xls", FileFormatType.Excel2003)

cell = Nothing

cells = Nothing

worksheet = Nothing

workbook = Nothing

2

Hi,

Thank you for sharing your code. We will look into you problem and get back to you soon.

Thank You & Best Regards,

3

Hi,

Please try the attached version (4.6.0.6), we have supported to set DDE Link.

Thank you.

4

Can you please provide an example of how to implement DDE links without using an .xla?

5

Hi,

We will get back to you for your inquiry.

Thank you.