02-20-2012 08:40 AM
Hi
What im trying to do is Create a program to map one Excel cell to another.
My thinking was to have two embedded excel sheets next to each other.
The user would then click the cell that they wanna link, push a button and write the cells to a text file.
How do i do this?
I have tried to use the embedded ActiveX Excel Control but i cant seem to read or write to it?
Can some one please show me how?
02-22-2012 08:14 AM
Hey Shako,
You should be able to read and write from cells by getting the workbook handle (ExcelRpt_WorkbookOpen or WorkbookNew), getting the worksheet handle (ExcelRpt_GetWorksheetFromIndex or WorksheetNew), and using the read write commands (ExcelRpt_WriteData and ReadData).
Where are the difficulties coming up?
Luke W