Jump to content
Sign in to follow this  
water

Rewrite of the PowerPoint UDF

Recommended Posts

Thanks for your post.
At the moment I try to get my head around how the object model of PPT looks like. A big picture / overview of the objects/collections and their relation.
Then I will dive in and work with frames, shapes, themes etc.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-07-21 - Version 1.5.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites
  • Combine it / make some functions for VISIO at the same time
    especially when you make automated flowcharts from text its nice if you can have similar functions for visio and powerpoint.
  • Make clear when you just use $oPPT_App= createobject("powerpoint.application") and when to use the udf
    Is it just an abstraction UDF or does it add power over the already accessible powerpoint application
     

 

Share this post


Link to post
Share on other sites

Junkew,

thanks for your post!

  • I think Visio needs an UDF on its own. Some features might be similar but I think it is not sensible to mix PowerPoint and Visio
  • The PowerPoint UDF adds some "power" by doing error handling, setting sensible defaults and wrapping complex operations.
    _PPT_Open tries to connect to an already running instance of PowerPoint. If none exists it starts PowerPoint.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-07-21 - Version 1.5.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

Great :) 


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-07-21 - Version 1.5.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

New Alpha 3 version of the UDF released.
Added function _PPT_PresentationExport: Export the whole or parts of the presentation as PDF or XPS.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-07-21 - Version 1.5.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

Anyone interested in a function to export slide(s) as graphics (JPG, GIF, PNG ...)?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-07-21 - Version 1.5.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

Fine. I'm about to write the function.

You are the graphics guru:
For exporting slides you can specify the width and/or height. The function provides a flag to preserve the width/height ratio.
If the user specifies width and height but with this values the ratio would not be preserved how would you calculate the new with/height to preserve the ratio?
Only use width and ignore height? Calculate if width or height exceed the ratio and use this value to calculte the other value? Something else?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-07-21 - Version 1.5.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

I would use the width value to calculate the height value according to the ratio.

Or you can be more flexible if either width or height is zero then the other value will be calculated accordingly.


Please don't send me any personal message and ask for support! I will not reply!

Selection of finest graphical examples at Codepen.io

The own fart smells best!
Her 'sikim hıyar' diyene bir avuç tuz alıp koşma!
¯\_(ツ)_/¯  ٩(●̮̮̃•̃)۶ ٩(-̮̮̃-̃)۶ૐ

Share this post


Link to post
Share on other sites

New Alpha 4 version of the UDF released.
For details please check the download section of this forum.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-07-21 - Version 1.5.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

If folder Presentation1 is not extisting then the script will fail to create the PNGs.


Please don't send me any personal message and ask for support! I will not reply!

Selection of finest graphical examples at Codepen.io

The own fart smells best!
Her 'sikim hıyar' diyene bir avuç tuz alıp koşma!
¯\_(ツ)_/¯  ٩(●̮̮̃•̃)۶ ٩(-̮̮̃-̃)۶ૐ

Share this post


Link to post
Share on other sites

Thanks for the feedback!
The function will create the directory now. Will be part of the next alpha.
 

; #FUNCTION# ====================================================================================================================
; Name...........: _PPT_PresentationExportGraphic
; Description ...: Export one/multiple/all slides of a presentation in a graphic format.
; Syntax.........: _PPT_PresentationExportGraphic($oPresentation[, $sPath = @ScriptDir[, $sSlide = Default[, $sFilter = "JPG"[, $bKeepRatio = True]]]])
; Parameters ....: $oPresentation - Presentation object.
;                  $sPath         - [optional] Directory where the graphics should be stored. The graphics are named Slide<n>. n is the slide number (default = keyword Default = @ScriptDir).
;                  $sSlide        - [optional] A string with the index number of the starting (and ending) slide to be exported (, separated by a hyphen) (default = Keyword Default = export all slides in the presentation).
;                  $sFilter       - [optional] The graphics format in which you want to export slides (default = JPG). See Remarks.
;                  $iScaleWidth   - [optional] The width in pixels of an exported slide (default = keyword Default = do not change the width).
;                  $iScaleHeight  - [optional] The height in pixels of an exported slide (default = keyword Default = do not change the heigth).
;                  $bKeepRatio    - [optional] If set To True the width:height ratio is preserved (default = True)
; Return values .: Success - 1.
;                  Failure - 0 and sets @error.
;                  |1 - $oPresentation is not an object or not a presentation object
;                  |2 - $sSlide is an object but not a sliderange object
;                  |3 - $sPath didn't exist and returned an error when the function tried to create it.
;                  |4 - Error occurred when exporting the presentation. @extended is set to the COM error code returned by the ExportAsFixedFormat method
;                  |5 - $sSlide is invalid. Has to be "StartingSlide-EndingSlide"
; Author ........: water
; Modified.......:
; Remarks .......: This function only supports a single range of consecutive slides.
;                  The specified graphics format must have an export filter registered in the Windows registry.
;                  You need to specify the registered extension (JPG, GIF etc.).
; Related .......:
; Link ..........:
; Example .......: Yes
; ===============================================================================================================================
Func _PPT_PresentationExportGraphic($oPresentation, $sPath = Default, $sSlide = Default, $sFilter = Default, $iScaleWidth = Default, $iScaleHeight = Default, $bKeepRatio = Default)
    Local $iStartingSlide, $iEndingSlide
    If Not IsObj($oPresentation) Or ObjName($oPresentation, 1) <> "_Presentation" Then Return SetError(1, 0, 0)
    If $sSlide = Default Then
        $iStartingSlide = 1
        $iEndingSlide = $oPresentation.Slides.Count
    Else
        Local $aSlides = StringSplit($sSlide, "-", $STR_NOCOUNT)
        Local $iValues = UBound($aSlides)
        If $iValues < 1 Or $iValues > 2 Then
            Return SetError(5, 0, 0)
        ElseIf $iValues = 1 Then
            ReDim $aSlides[2]
            $aSlides[1] = $aSlides[0]
        EndIf
        If Number($aSlides[0]) = 0 Or Number($aSlides[1]) = 0 Then Return SetError(5, 0, 0)
        $iStartingSlide = $aSlides[0]
        $iEndingSlide = $aSlides[1]
    EndIf
    If $sPath = Default Then $sPath = @ScriptDir
    If Not FileExists($sPath) Then
        If DirCreate($sPath) = 0 Then Return SetError(3, 0, 0)
    Endif
    If $sFilter = Default Then $sFilter = "JPG"
    If $bKeepRatio = Default Then $bKeepRatio = True
    If $bKeepRatio = True And ($iScaleWidth <> Default Or $iScaleHeight <> Default) Then
        Local $iRatio = $oPresentation.Pagesetup.SlideWidth / $oPresentation.Pagesetup.SlideHeight
        If $iScaleWidth = Default Then
            $iScaleWidth = $oPresentation.Pagesetup.SlideWidth * ($iScaleHeight / $oPresentation.Pagesetup.SlideHeight)
        Else
            $iScaleHeight = $oPresentation.Pagesetup.SlideHeight * ($iScaleWidth / $oPresentation.Pagesetup.SlideWidth)
        EndIf
    EndIf
    For $i = $iStartingSlide To $iEndingSlide
        $oPresentation.Slides($i).Export($sPath & "\Slide" & $i & "." & $sFilter, $sFilter, $iScaleWidth, $iScaleHeight)
        If @error Then Return SetError(4, @error, 0)
    Next
    Return 1
EndFunc   ;==>_PPT_PresentationExportGraphic

 

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-07-21 - Version 1.5.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

The Word and Excel object model allow to set the active printer. So the UDF print functions allow to print the document/workbook on every possible printer.
In the PowerPoint object model this features is missing.
Should the PowerPoint UDF should use another way (WSH etc.) to set the active printer so the print function is similar to the Word/Excel UDF?

 


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-07-21 - Version 1.5.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

Thanks water a lot, your UDF is so cool.

Please add some more function about VBA Macros please!

Example:

  •  _PPT_PresentationMacrosAdd : add new macros to current presentation
  •  _PPT_PresentationMacrosDelete : delete one or more macros from current presentation
  •  _PPT_PresentationMacrosRun : run a macros from text in autoit.
Edited by drquochoai

Share this post


Link to post
Share on other sites

Glad you like the alpha version of the UDF :)

Running a PPT macro is a one-liner. A UDF function should be a wrapper to hide complexity. So, like in all other UDFs, a _PPT_MacroRun function will not be implemented.
It is easy to code it yourself as described here: https://msdn.microsoft.com/en-us/library/ff744221(v=office.14).aspx

$oPPT.Run("Name of the macro to run")

Adding/Deleting a macro is a different game and needs to call the VBE (Visual Basic Editor): https://msdn.microsoft.com/en-us/library/ff744221(v=office.14).aspx
The UDF will focus on often used and basic PowerPoint functions. So I fear that VBE is out of scope as well.
But if enough people long for a VBE UDF - who knows?


 


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-07-21 - Version 1.5.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

Thanks water so much for quick reply.

I've read the microsoft document from your link https://msdn.microsoft.com/en-us/library/ff744221(v=office.14).aspx

Actually i need to add one same VBA code to a lot of presentations (the code to check if there are missing fonts in all ppt files):

Option Base 1
Sub MissingFonts()
Dim sfont As Long
Dim PresFonts() As String, MissingFonts() As String
Dim NumFontsInPres As Integer
Dim FontInstalled As Boolean, FontMissing As Boolean
NumFontsInPres = ActivePresentation.Fonts.Count
ReDim PresFonts(CInt(NumFontsInPres))
  For i = 1 To NumFontsInPres
    PresFonts(i) = ActivePresentation.Fonts(i).Name
  Next i
  Set wordapp = CreateObject("Word.document")
  With wordapp
    .Application.Visible = False
    .Parent.System.cursor = wdCursorWait
    For i = 1 To NumFontsInPres
      For Each FontName In wordapp.Application.FontNames
        If FontName = PresFonts(i) Then
          FontInstalled = True
        End If
      Next FontName
      If FontInstalled = False Then
        On Error GoTo FirstFoundMissingFont
        MissFontSize = UBound(MissingFonts())
        GoTo NoError
FirstFoundMissingFont:
        MissFontSize = 0
NoError:
        ReDim Preserve MissingFonts(CInt(MissFontSize + 1))
        MissingFonts(CInt(MissFontSize + 1)) = PresFonts(i)
      End If
    Next i
    .Parent.System.cursor = wdCursorNormal
    .Application.Quit
  End With
  Set wordapp = Nothing
  On Error GoTo EmptyArray
  If LBound(MissingFonts) = UBound(MissingFonts) Then GoTo FullArray
EmptyArray:
  MsgBox "All fonts are installed"
  Exit Sub
FullArray:
  For j = 1 To UBound(MissingFonts)
    FontList$ = MissingFonts(j) + vbCr
  Next j
  MsgBox "The following fonts are missing:" + vbCr + FontList$
End Sub

But i really don't know how, because the .Run function will call the added Macros, but not auto add a new macros.

$oPPT.Run("Name of the macro to run")
; .Run(MacroName, safeArrayOfParams)

I'm so happy if you point me the way how i could do it by myself.

 

 

Share this post


Link to post
Share on other sites

Is this a one-off job?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-07-21 - Version 1.5.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

Simple example to process all presentations in the script directory and write missing font names to the Console:

#include <PowerPoint.au3>
#include <Word.au3>
#include <File.au3>

Global $oPPT = _PPT_Open(False)
Global $oWord = _Word_Create(False)
Global $oWordFonts = $oWord.Application.FontNames
; .Parent.System.cursor = wdCursorWait
; .Parent.System.cursor = wdCursorNormal
; Get a list of all PPT files
$aPPT = _FileListToArray(@ScriptDir, "*.PPTX", $FLTA_FILES, True)
If @error Then Exit MsgBox($MB_ICONERROR, "Error", "No PPT-files could be found!")
For $i = 1 To $aPPT[0]
;   ConsoleWrite("Processing: " & $aPPT[$i] & @CRLF)
    $oPres = _PPT_PresentationOpen($oPPT, $aPPT[$i], Default, False)
    _ProcessPresentation($oPres)
    _PPT_PresentationClose($oPres)
Next
_Word_Quit($oWord)
_PPT_Close($oPPT)
Exit

Func _ProcessPresentation($oPres)
    Local $bFound
    For $oPPTFont In $oPres.Fonts
;       ConsoleWrite("  Processing Font: " & $oPPTFont.Name & @CRLF)
        $bFound = False
        For $oWordFont In $oWordFonts
            If $oPPTFont.Name = $oWordFont Then
                $bFound = True
                ExitLoop
            EndIf
        Next
        If $bFound = False Then ConsoleWrite("Presentation: " & $oPres.FullName & ", Font: " & $oPPTFont.Name & " is missing." & @CRLF)
    Next
EndFunc   ;==>_ProcessPresentation

 

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-07-21 - Version 1.5.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

New Alpha 5 version of the UDF released.
For details please check the download section of this forum.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-07-21 - Version 1.5.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By pat4005
      A tiny UDF that can shoot magic packets at your computers to wake them the heck up. All credits to Olish.
      The only parameter it needs to be specified – is your machine's MAC-address (ip address (the second parameter), at which you will be sending magic packet is generating automatically from @IPAddress1 macro)
      Example:
      _WoL_WakeDevice('001CC0CAED7A') ; the second parameter (if necessery) must be a broadcast address of your local network segment (i.e. 192.168.0.255 for a network 192.168.0.0)  
      _WakeOnLan.au3
    • By MrCreatoR
      This UDF allows to create formatted label using pseudo element RichLabel (RichEdit actually). Formating is set by using special modificator similar to <font> tag in Html.
      Notes: This UDF is a transformation-continuation of related UDF


      Example:
      Download:
      GUIRichLabel_1.2.zip
      Small syntax related fix: GUIRichLabel_1.1.zip
      GUIRichLabel_1.1.zip
       
      History version:
    • By Stormgrade
      Hello,
      I'm searching the UDF GDIpProgress.au3 from ProgAndy
      None of the links in topic
       works
      Can't someone upload it please ?
    • By ozymandius257
      This is probably a very simple question (I hope!)
      I'm looking to use a UDF to access a SQL database, and have found ADO.au3, but I can't seem to work out how to use it.
      I've copied the files ado.au3 and ado_constants.au3 into the folder C:\Program Files (x86)\AutoIt3\Include, then opened SciTe and started a new project.
      But when I type #include<AD - I don't get offered ADO.au3.
      (I know I should be using the folder C:\Program Files (x86)\AutoIt3\UserInclude, but when it didn't work from there, I tried the above).
      What am I doing wrong?
       
    • By BetaLeaf
      What is Rollbar?
      Rollbar provides real-time error alerting & debugging tools for developers. Learn more about it at https://rollbar.com/product/
      Demo: https://rollbar.com/demo/demo/
      Screenshot:
      Instructions: (RollbarTest.au3)
      ; Include RollbarSDK #include "RollbarSDK.au3" ;Turns on ConsoleWrite debugging override. ;Global $Rollbar_Debug=False ; Initialize RollbarSDK with the project's API key. ; Parameters ....: $__Rollbar_sToken - [Required] Go to https://rollbar.com/<User>/<ProjectName>/settings/access_tokens/ for your project. Use the token for post_server_item. _Rollbar_Init("eaa8464a4082eeabd9454465b8f0c0af") ; Write code that causes an error you want to catch, then call ; _Rollbar_Send ; Parameters ....: $__Rollbar_sErrorLevel - [Required] Must be one of the following values: Debug, Info, Warning, Error, Critical. ; $__Rollbar_sMessage - [Required] The message to be sent. This should contain any useful debugging info that will help you debug. ; $__Rollbar_sMessageSummary - [Optional] A string that will be used as the title of the Item occurrences will be grouped into. Max length 255 characters. If omitted, Rollbar will determine this on the backend. _Rollbar_Send("Debug", "This is an debug message. If you received this, you were successful!", "Debug Message") _Rollbar_Send("Info", "This is a test message. If you received this, you were successful!", "Info Message") _Rollbar_Send("Warning", "This is an warning message. If you received this, you were successful!", "Warning Message") _Rollbar_Send("Error", "This is an error message. If you received this, you were successful!", "Error Message") _Rollbar_Send("Critical", "This is an critical message. If you received this, you were successful!", "Critical Message") _Rollbar_Send("Info", "This is a test message. If you received this, you were successful!") ;No Message ; Rollbar_Send's helper functions ; Parameters ....: $__Rollbar_sMessage - [Required] The message to be sent. This should contain any useful debugging info that will help you debug. ; $__Rollbar_sMessageSummary - [Optional] A string that will be used as the title of the Item occurrences will be grouped into. Max length 255 characters. If omitted, Rollbar will determine this on the backend. _Rollbar_SendDebug("This is an debug message. If you received this, you were successful!", "Debug Message") _Rollbar_SendInfo("This is a test message. If you received this, you were successful!", "Info Message") _Rollbar_SendWarning("This is an warning message. If you received this, you were successful!", "Warning Message") _Rollbar_SendError("This is an error message. If you received this, you were successful!", "Error Message") _Rollbar_SendCritical("This is an critical message. If you received this, you were successful!", "Critical Message") ; Usable Example Local $sImportantFile = "C:\NOTAREALFILE_1234554321.txt" Switch FileExists($sImportantFile) Case True MsgBox(0, "Example Script", "An important file was found. Continuing...") Case Else _Rollbar_SendCritical('An important file was missing. Halting... File: "' & $sImportantFile & '"', 'Important file "' & $sImportantFile & '" is missing.') EndSwitch Notes: Please comment your feedback, advice, & suggestions below. While this is only a proof of concept, I will expand its feature set for everyone to use. 
      Right now, it is fully functional but not tested in production.
       
       
      Changelog:
      RollbarSDK.au3
      RollbarTest.au3
      v0.2
       
      v0.1.1
       
×
×
  • Create New...