#E = DDE_POKE('EXCEL','[BOOK1]SHEET1',$_R + $_C,$_FIELD)
This seems to work well when I have when I have just opened Excel and Book1 is the active work book. If Excel is already open and Book1 no longer available then this command obviously does not work.
I would like to create a new active work book and name it 'Joseph' for example so my command will look like...
#E = DDE_POKE('EXCEL','[JOSEPH]SHEET1',$_R + $_C,$_FIELD)
instead. I have tried to use DDE_EXECUTE but have had limited success. I can create a new work book which is automatically named 'Bookn', using the command:
#A = DDE_EXECUTE('EXCEL','system','[new]')
but I can't seem to save it to another name. Does anyone know how to do this? I tried using:
#A = DDE_EXECUTE('EXCEL','system','[save as(c:\temp\JOSEPH.xls]')
Can anyone help? Does anyone have the full list of commands and syntax for DDE_EXECUTE for Excel? Where can I find this? I have looked everywhere on the internet to no avail.
Thanks in advance...