GMK

I was wondering why you didn't just select the document but I wasn't going to question it. You can find more VBA info here, if I'm not mistaken.

_Word_DocRangeSet only sets the range. It doesn't select it. $oRange_Actual = _Word_DocRangeSet($oDoc, -1, $oRange_Start, Default, $oRange_End, Default) $oRange_Actual.Select MsgBox(0, "$oRange_Actual", $oRange_Actual.Selection)

If you changed that one line in _OOoCalc_WriteFromArray earlier, you may want to change it back.

setDataArray is supposed to insert both numbers and strings:

I'll have to play around with it at home this evening. In the meantime, is it possible to loop through an array from __SQLQuery2Array and get all the data types to see if it's what you're expecting?

Are you using LibreOffice or OpenOffice and which version, please?

Sorry @Starocotes. I didn't even see your comment until now. Do you have an example--some code that you could produce that shows the issue?

$sDate = 'August 18, 2023' $sNewDate = _Date_Time_Convert($sDate, 'MMMM d, yyyy', 'yyyy-MM-dd HH:mm:ss') If @error Then ConsoleWrite('@error = ' & @error & '; @extended = ' & @extended & @CRLF) Else ConsoleWrite(StringFormat('%s = %s', $sDate, $sNewDate) & @CRLF) EndIf produces August 18, 2023 = 2023-08-18 :**:** I was expecting '**' placeholders for the 'HH' output as well? (Just trying to "break the beta.") Thanks for your time, @Melba23!

Edit: Apparently I don't know what I'm doing like Melba23 does.

OK, I may have found the problem. For If statements like the following: If $aDTC_Data[7][1] & $aDTC_Data[7][2] = "" Then ; Check AM/PM set I replaced the '&' with 'And' If $aDTC_Data[7][1] And $aDTC_Data[7][2] = "" Then ; Check AM/PM set which seemed to fix the problem.

Am I mistaken in thinking that this works as a date converter without time? Global $sDate = 'August 11, 2023' Global $sNewDate = _Date_Time_Convert($sDate, 'MMMM d, yyyy', 'yyyy-MM-dd') If @error Then ConsoleWrite('@error = ' & @error & '; @extended = ' & @extended & @CRLF) Else ConsoleWrite(StringFormat('%s = %s', $sDate, $sNewDate) & @CRLF) EndIf +>Setting Hotkeys...--> Press Ctrl+Alt+Break to Restart or Ctrl+BREAK to Stop. @error = 1; @extended = 8 +>09:15:19 AutoIt3.exe ended.rc:0 +>09:15:19 AutoIt3Wrapper Finished. >Exit code: 0 Time: 1.26

Can't test right now, but try this: #include ".\Required-AU\OOoCalc.au3" ; For Open Office / Libre Office Spreadsheet #include <MsgBoxConstants.au3> Global $fExcelTemplate = @ScriptDir & "\Required\PO.xls" MsgBox($MB_OK, "Open Office", "Starting OO Hidden") Global $oCalc = _OOoCalc_BookOpen($fExcelTemplate, True) If @error Then Exit MsgBox($MB_TOPMOST, "Notice", "Unable to open Book: " & $fExcelTemplate) Global $oCalcWin = $oCalc.CurrentController.Frame.ContainerWindow Opt("WinTitleMatchMode", 2) ;1=start, 2=subStr, 3=exact, 4=advanced, -1 to -4=Nocase SplashTextOn("Wait","Waiting for OO To Start") WinWait("Office Calc") WinActivate("Office Calc") SplashOff() SplashTextOn("Wait","Moving Hidden Window") $oCalcWin.setPosSize(1000, 0, 800, 800, 15) ;x,y,w,h,flag=15 SplashOff() SplashTextOn("Wait","In 3 secs will show OO window") Sleep(3000) SplashOff() $oCalcWin.Visible = True MsgBox($MB_OK, "Open Office", "Click OK to close the sheet") _OOoCalc_BookClose($oCalc)

"I tried below code with no luck.." You'll have to be more specific. Do you get error messages? What happens when you run the code? Where is it failing?

Would a pivot table not work in this situation?

Can you post the specific commands you've tried with parameters? Without having access to the window or being able to recreate the situation, it's difficult to provide much help.