We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

DDE Support

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

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

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

Thank You & Best Regards,

Hi,

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

Thank you.

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

Hi,

We will get back to you for your inquiry.

Thank you.