COMatePLUS version 1.2

SeregaZ · **Posted:** Fri Mar 20, 2015 7:03 am

thanks a lot

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

Marc56us · **Joined:** Sat Feb 08, 2014 3:26 pm **Posts:** 986

SeregaZ wrote:

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:

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/library/office/aa168292%28v=office.11%29.aspx

:wink:

leodh · **Posted:** Wed May 27, 2015 6:31 am

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 · **Posted:** Sun Sep 06, 2015 11:00 am

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

Falko · **Posted:** Sun Sep 06, 2015 11:09 am

Thank you very much, Thomas.

Kiffi · **Posted:** Sun Sep 06, 2015 11:32 am

ts-soft wrote:

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 · **Posted:** Sun Sep 06, 2015 11:36 am

Thank you, Thomas!

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

davido · **Posted:** Sun Sep 06, 2015 11:53 am

@ts-soft,

Thank you.

ts-soft · **Posted:** Sun Sep 06, 2015 12:26 pm

@Little John

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

Little John · **Posted:** Sun Sep 06, 2015 1:56 pm

Thanks again, Thomas!

ThoPie · **Joined:** Sat Aug 22, 2009 6:49 pm **Posts:** 36

Thank you for your work, Thomas!

srod · **Posted:** Tue Feb 16, 2016 2:56 pm

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 · **Posted:** Tue Feb 16, 2016 3:12 pm

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

IdeasVacuum · **Posted:** Tue Feb 16, 2016 4:01 pm

...Berlin or Ibiza time?

davido · **Posted:** Tue Feb 16, 2016 4:48 pm

@srod,
Thank you, very much.

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

PureBasic Forum

COMatePLUS version 1.2

Who is online