HTRN Posted June 6, 2019 Share Posted June 6, 2019 Morning all, I am trying to copy a range from sheet1 in an Open Office Calc File, .ods, to sheet1 in a second .ods file. I understand the example of how to copy from one sheet to another within the same file _OOoCalc_RangeMoveOrCopy($CalcSpreadsheet, "B4:C7", "C2", 1, -1, "Sheet2") _OOoCalc_RangeMoveOrCopy(ByRef $oObj, $sSrcRange, $sDestCell, $iFlag[, $vSrcSheet = -1[, $vDestSheet = -1]]) but was wondering if anyone has been able to make the leap from sheet1 spreadsheet1 to sheet1 spreadsheet2? or is there a different Open Office UDF I should be using? Link to comment Share on other sites More sharing options...
water Posted June 6, 2019 Share Posted June 6, 2019 I do not know the OOoCalc UDF but ... do you get an error message or an return value or does the function set macros @error and @extended? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
HTRN Posted June 6, 2019 Author Share Posted June 6, 2019 <SOLVED>... Sorta. No I do not. BUT!!!! I have worked around the issue. Since there was not option to copy from file to file BUT there was a function to copy from sheet to sheet AND there was also a function to read a file into an array I simply read the file with the range I need as array into a 2nd sheet in the existing spreadsheet and THEN USE "_OOoCalc_RangeMoveOrCopy" to copy that data into the 1st sheet. As an aside, is your handle, "water", a reference to Bruce Lee's famous quote? Link to comment Share on other sites More sharing options...
water Posted June 6, 2019 Share Posted June 6, 2019 (edited) No, my forum name is simply a reference to … water Edited June 6, 2019 by water My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now