It is currently Mon Oct 26, 2020 1:34 pm

All times are UTC + 1 hour




Post new topic Reply to topic  [ 336 posts ]  Go to page Previous  1 ... 18, 19, 20, 21, 22, 23  Next
Author Message
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Fri Mar 20, 2015 7:03 am 
Offline
Enthusiast
Enthusiast

Joined: Fri Feb 20, 2009 9:24 am
Posts: 573
Location: Almaty (Kazakhstan)
thanks a lot :)

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


Top
 Profile  
Reply with quote  
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Fri Mar 20, 2015 10:10 am 
Offline
Addict
Addict

Joined: Sat Feb 08, 2014 3:26 pm
Posts: 944
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:

_________________
(English is not my native language, I use an online translator.)


Top
 Profile  
Reply with quote  
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Wed May 27, 2015 6:31 am 
Offline
Enthusiast
Enthusiast

Joined: Sun Nov 06, 2005 6:07 am
Posts: 162
Location: Perth Western Australia
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

_________________
Regards
Leo


Top
 Profile  
Reply with quote  
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Sun Sep 06, 2015 11:00 am 
Offline
Always Here
Always Here
User avatar

Joined: Thu Jun 24, 2004 2:44 pm
Posts: 5756
Location: Berlin - Germany
Here a fixed version for pb5.40 +, only the COMatePLUS.pbi
https://dl.dropboxusercontent.com/u/308 ... tePLUS.pbi

_________________
PureBasic 5.71 | SpiderBasic 2.30 | Windows 10 Pro (x64) | Linux Mint 19.3 (x64)
Old bugs good, new bugs bad! Updates are evil: might fix old bugs and introduce no new ones.
Image


Top
 Profile  
Reply with quote  
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Sun Sep 06, 2015 11:09 am 
Offline
Enthusiast
Enthusiast
User avatar

Joined: Sat Oct 04, 2003 12:57 pm
Posts: 269
Location: Germany
Thank you very much, Thomas.

_________________
www.falko-pure.de
Win8 Pro 64-Bit & Mediacenter, PB_5.1B7, GFA-WinDOS, Powerbasic9.05-Windows, NSBasic/CE, NSBasic/Desktop, NSBasic4APP, EmergenceBasic


Top
 Profile  
Reply with quote  
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Sun Sep 06, 2015 11:32 am 
Offline
Addict
Addict
User avatar

Joined: Tue Mar 02, 2004 1:20 pm
Posts: 1149
Location: Amphibios 9
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! Image

Greetings ... Peter

_________________
Hygge


Top
 Profile  
Reply with quote  
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Sun Sep 06, 2015 11:36 am 
Offline
Addict
Addict

Joined: Thu Jun 07, 2007 3:25 pm
Posts: 3935
Location: Berlin, Germany
Thank you, Thomas!

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

_________________
Please excuse my flawed English. My native language is PureBasic.
Search
RSBasic's backups


Top
 Profile  
Reply with quote  
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Sun Sep 06, 2015 11:53 am 
Offline
Addict
Addict

Joined: Fri Nov 09, 2012 11:04 pm
Posts: 1785
Location: Uttoxeter, UK
@ts-soft,

Thank you.

_________________
DE AA EB


Top
 Profile  
Reply with quote  
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Sun Sep 06, 2015 12:26 pm 
Offline
Always Here
Always Here
User avatar

Joined: Thu Jun 24, 2004 2:44 pm
Posts: 5756
Location: Berlin - Germany
@Little John

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

_________________
PureBasic 5.71 | SpiderBasic 2.30 | Windows 10 Pro (x64) | Linux Mint 19.3 (x64)
Old bugs good, new bugs bad! Updates are evil: might fix old bugs and introduce no new ones.
Image


Top
 Profile  
Reply with quote  
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Sun Sep 06, 2015 1:56 pm 
Offline
Addict
Addict

Joined: Thu Jun 07, 2007 3:25 pm
Posts: 3935
Location: Berlin, Germany
Thanks again, Thomas!

_________________
Please excuse my flawed English. My native language is PureBasic.
Search
RSBasic's backups


Top
 Profile  
Reply with quote  
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Mon Sep 07, 2015 10:16 am 
Offline
User
User

Joined: Sat Aug 22, 2009 6:49 pm
Posts: 36
Thank you for your work, Thomas!


Top
 Profile  
Reply with quote  
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Tue Feb 16, 2016 2:56 pm 
Offline
PureBasic Expert
PureBasic Expert

Joined: Wed Oct 29, 2003 4:35 pm
Posts: 10589
Location: Beyond the pale...
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. :)

_________________
I may look like a mule, but I'm not a complete ass.


Top
 Profile  
Reply with quote  
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Tue Feb 16, 2016 3:12 pm 
Offline
Moderator
Moderator

Joined: Thu Dec 31, 2009 11:05 pm
Posts: 1112
Location: Gernsbach (Germany)
I'm not at home yet. I upload the file at 6pm-7pm. :)

_________________
ImageImageImageImage Image


Top
 Profile  
Reply with quote  
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Tue Feb 16, 2016 4:01 pm 
Offline
Always Here
Always Here

Joined: Fri Oct 23, 2009 2:33 am
Posts: 6258
Location: Wales, UK
...Berlin or Ibiza time? :D

_________________
IdeasVacuum
If it sounds simple, you have not grasped the complexity.


Top
 Profile  
Reply with quote  
 Post subject: Re: COMatePLUS version 1.2
PostPosted: Tue Feb 16, 2016 4:48 pm 
Offline
Addict
Addict

Joined: Fri Nov 09, 2012 11:04 pm
Posts: 1785
Location: Uttoxeter, UK
@srod,
Thank you, very much.

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

_________________
DE AA EB


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 336 posts ]  Go to page Previous  1 ... 18, 19, 20, 21, 22, 23  Next

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  

 


Powered by phpBB © 2008 phpBB Group
subSilver+ theme by Canver Software, sponsor Sanal Modifiye