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
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'"
workbook.Save("C:\Users\Cletis & Kerri\Desktop\test.xls", FileFormatType.Excel2003)
cell = Nothing
cells = Nothing
worksheet = Nothing
workbook = Nothing