I want to turn the macro vba into a Macro in LibreOffice Calc (.ods) .
I have not had time to test the code snippets of the links linked above
I need to copy only the values .
I need the macro Do not copy the formulas, only the values, and if possible without the macro buttons .
myObject.SupportsService("com.sun.star.sheet.SpreadsheetDocument")
you can put the following information in your code and then re-attach the file .
follow the informations :
newPath : the new directory path where the copy of the worksheet (new file) will be written is ... C: \ Users \ Padrao \ Documents \ test A \ test B \ test C \
- Code: Select all Expand viewCollapse view
newPath = Left(s, Len(s) - Len(h(u))) & pSubName & "C:\Users\Padrao\Documents\test A\test B\test C"
newPath = Left(s, Len(s) - Len(h(u))) & pSubName & "C:\Users\Padrao\Documents\test A\test B\test C"
print newPath
Users browsing this forum: No registered users and 4 guests