Macro issues
Enviado: 21 Jun 2018 às 08:14
Hello,
I have converted some excel MACRO's to work in CALC but running in to some issues: Dim oSheet
oSheet = ThisComponent.Sheets.getByName("somesheetname") 1) while this code works when stepping through the code with F8 ... if I save and open my ods file I get an error for each cell that calls the function containing this object??? OpenOffice 4.1.1 BASIC runtime error ... property or method not found: sheets, 2) This error occurs for each cell calling the function and provides no way to ignore all, 3) There doesn't appear to be a way to turn off auto calc when calc opens ... excel has a shift F9 function to force a recalc of a sheet, Am I missing something?
Please help
I didn't find the right solution from the internet.
References:
https://forum.openoffice.org/en/forum/v ... 20&t=77319
Intro Video Production Company
Thank you
I have converted some excel MACRO's to work in CALC but running in to some issues: Dim oSheet
oSheet = ThisComponent.Sheets.getByName("somesheetname") 1) while this code works when stepping through the code with F8 ... if I save and open my ods file I get an error for each cell that calls the function containing this object??? OpenOffice 4.1.1 BASIC runtime error ... property or method not found: sheets, 2) This error occurs for each cell calling the function and provides no way to ignore all, 3) There doesn't appear to be a way to turn off auto calc when calc opens ... excel has a shift F9 function to force a recalc of a sheet, Am I missing something?
Please help
I didn't find the right solution from the internet.
References:
https://forum.openoffice.org/en/forum/v ... 20&t=77319
Intro Video Production Company
Thank you