COMatePLUS version 1.2

[SeregaZ]

thanks a lot

it just virtual flag "saved"? no creation any temp-exel files on hdd?

[Marc56us]

i try to close exel file without save, some kind of force closing.

Add DisplayAlerts = #False before 'Quit' command.
Like this:
ExcelObject\SetProperty("Application\DisplayAlerts = #False")

Code: Select all

XIncludeFile "COMatePLUS.pbi"

Define.COMateObject ExcelObject, WorkBook
ExcelObject = COMate_CreateObject("Excel.Application")

If ExcelObject
    If ExcelObject\SetProperty("Visible = #True") = #S_OK
        WorkBook = ExcelObject\GetObjectProperty("Workbooks\Add")
            If WorkBook
                ExcelObject\SetProperty("Cells(1,1) = 'Hello'")
                ExcelObject\SetProperty("Cells(1,2) = 'from'")
                ExcelObject\SetProperty("Cells(1,3) = 'COMate!'")
                ; --- Wait 3 sec
                Delay(3000)
                ExcelObject\SetProperty("Application\DisplayAlerts = #False") 
                ; -----------------------------------------------------------
                ExcelObject\Invoke("Quit()") 
                WorkBook\Release()
        EndIf
    EndIf
    ExcelObject\Release()
Else
    MessageRequester("COMate -Excel demo", "Couldn't create the application object!")
EndIf 

I found it here (by searching 'Quit' on VBA)
'If you've set the DisplayAlerts property to False, you won't be prompted to save any unsaved data'
https://msdn.microsoft.com/en-us/librar ... 11%29.aspx

[leodh]

Hi All,

Just like to know if anyone has been able to check the Outlook sent box to see if an email has been sent using Comate plus.

I have a written an application that sets up an auto populated Outlook Email and allows the user to add any further text to the email before sending.

If they decide to send or cancel the email, I have no easy way of knowing. I thought if I could check the sent box for emails sent to whomever programmatically, it would allow the program to make the appropriate responses.

If anyone has any examples of how this is done that they could show me It would be great.

Thanks
Leo

[ts-soft]

Here a fixed version for pb5.40 +, only the COMatePLUS.pbi
https://dl.dropboxusercontent.com/u/308 ... tePLUS.pbi

[Falko]

Thank you very much, Thomas.

[Kiffi]

Here a fixed version for pb5.40 +, only the COMatePLUS.pbi
https://dl.dropboxusercontent.com/u/308 ... tePLUS.pbi

Thanks a lot!

Greetings ... Peter

[Little John]

Thank you, Thomas!

According to the PureBasic Team Blog, for 64 bit programs additionally Get/SetWindowLong_() should be replaced with Get/SetWindowLongPtr_().

[davido]

@ts-soft,

Thank you.

[ts-soft]

@Little John

I think, there was a Macro that do it for me but i have it changed!

[Little John]

Thanks again, Thomas!

[ThoPie]

Thank you for your work, Thomas!

[srod]

Purebasic 5.42.

COMatePLUS has been modified to work with PB 5.42. See RSBasic's backup site for the download - though it may not be uploaded yet.

[RSBasic]

I'm not at home yet. I upload the file at 6pm-7pm.

[IdeasVacuum]

...Berlin or Ibiza time?

[davido]

@srod,
Thank you, very much.

Will the new version still work with older versions of PureBasic?
Or will it be necessary to keep both?