HTRN Posted June 6, 2019 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?
water Posted June 6, 2019 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 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
HTRN Posted June 6, 2019 Author 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?
water Posted June 6, 2019 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 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
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