I need to support some old data collection that is running on Excel, but I need to get it running on LibreOffice. The following statement works on Excel, but LibreOffice does not want to fill in the cells as wrote. It will fill in individual cells, but not the range. Can someone give me an idea that might help me out? Thanks!
This works:
Data = DDERequest(RSIchan, "HMI_DZ_PVCorr[1],L1,C1")
Range("[NewControlG_EL4.xlsm]Sheet2!B78").Value = Data
This does not:
Data = DDERequest(RSIchan, "HMI_DZ_PVCorr[1],L11,C11")
Range("[NewControlG_EL4.xlsm]Sheet2!B78:L78").Value = Data
If I do this, then it puts all the data in one cell:
Data = DDERequest(RSIchan, "HMI_DZ_PVCorr[1],L11,C11")
Range("[NewControlG_EL4.xlsm]Sheet2!B78").Value = Data
Thanks!
This works:
Data = DDERequest(RSIchan, "HMI_DZ_PVCorr[1],L1,C1")
Range("[NewControlG_EL4.xlsm]Sheet2!B78").Value = Data
This does not:
Data = DDERequest(RSIchan, "HMI_DZ_PVCorr[1],L11,C11")
Range("[NewControlG_EL4.xlsm]Sheet2!B78:L78").Value = Data
If I do this, then it puts all the data in one cell:
Data = DDERequest(RSIchan, "HMI_DZ_PVCorr[1],L11,C11")
Range("[NewControlG_EL4.xlsm]Sheet2!B78").Value = Data
Thanks!