Search found 20 matches

by jear
Tue Nov 10, 2009 1:39 am
Forum: Announcement
Topic: COMatePLUS version 1.2
Replies: 339
Views: 229084

Re: COMatePLUS version 1.1

thanks srod

This code seems to work :)

Edit Nov 12, 2009 21:20 :
But in some cases, IMHO dependent on size and/or complexity of the source workbook, the EXCEL.EXE remains running.
The different forums are quite full with post, describing this problem.

After the ApplObj\Release, there is no ...
by jear
Mon Nov 09, 2009 6:06 pm
Forum: Announcement
Topic: COMatePLUS version 1.2
Replies: 339
Views: 229084

COMatePLUS version 1.1

@Help

How to translate this code snippet to COMate?
ActiveWorkbook.SaveAs FileName:="C:\Temp\xxxx.csv", FileFormat:=xlCSV, CreateBackup:=False, local:=True

My code doesn't work :cry:

Code: Select all

;/ Save excel sheet as .CSV

; code removed, see below

by jear
Sun Aug 19, 2007 4:39 pm
Forum: General Discussion
Topic: Possition of function in source code effects performance!!
Replies: 18
Views: 6351

Another code to play with

#num = 1000000 ; for debugger version
;#num = 100000000 ; for compiled version

Define.s out

Procedure one()
Protected dummy.l
For n = 1 To #num : dummy = n : Next
Delay(0)
EndProcedure

Procedure two()
Protected dummy.l
For n = 1 To #num : dummy = n : Next
Delay(0)
EndProcedure

out ...
by jear
Fri Aug 17, 2007 10:58 pm
Forum: General Discussion
Topic: Get the frame rate of an ASF movie
Replies: 7
Views: 3439

DShow reports 0.03333...... as AvgTimePerFrame. So the video has exactly 30 FPS.
See the video properties detected by the MIPlayer:
(MIP ist part of the MPEG-Inspector , an application written in PB and based on Win DShow 9)
>>> Report of MIP session : 2007-08-17 23:50
>>> 281 registered DirectShow ...
by jear
Sat Jul 21, 2007 12:30 am
Forum: Tricks 'n' Tips
Topic: CSV and Quotes
Replies: 23
Views: 11202

@pdwyer

Solved the same problem this way:

Declare.l CSVLearn(CSV_line.s, Delimiter.s = ",")
Declare.s CSVField(CSV_line.s, Column.l, Delimiter.s = ",")

; ====== TEST CODE ===========

CSVString.s = "string1,string2," + #DOUBLEQUOTE$ + "Lastname, Firstname" + #DOUBLEQUOTE$ + ",string4,string5 ...
by jear
Sun Jun 10, 2007 2:08 pm
Forum: Coding Questions
Topic: ProcedureReturn optimisation?
Replies: 15
Views: 2628

Why not Macro Is()?

Procedure.l IsNumberLessThan100_0(n.l)
If n<100
ProcedureReturn #True
Else
ProcedureReturn #False
EndIf
EndProcedure

Procedure.l IsNumberLessThan100_1(n.l)
If n<100 : ProcedureReturn #True : EndIf
EndProcedure

Procedure.l IsNumberLessThan100_2(n.l)
ProcedureReturn ...
by jear
Thu May 31, 2007 10:22 pm
Forum: Coding Questions
Topic: Anyone tried adding functionality to the Windows Shell?
Replies: 1
Views: 1067

@jonljacobi
The simplest may be to put a shortcut to your exe to the folder "send to".
by jear
Tue Apr 17, 2007 12:25 am
Forum: Feature Requests and Wishlists
Topic: With/EndWith integrated to ForEach/Next
Replies: 13
Views: 4078

What is intended to be the higher abstraction level: ForEach or With?

Code: Select all

Structure Leute
  Name.s
  Vorname.s
  Strasse.s
  PLZ.s
  Ort.s
EndStructure

NewList Leute.Leute()

With Leute()
  ForEach
    \PLZ = "26160"
  Next
EndWith
by jear
Mon Mar 19, 2007 3:34 pm
Forum: Coding Questions
Topic: Strange Movie problem
Replies: 18
Views: 4314

On each system there are different combinations of DirectShow filters installed and registered with different merits.

After install or uninstall of any video related application, the configuration may be changed seriously.

The PB movie features doesn't build a filter graph. This is done by DShow ...
by jear
Sat Feb 24, 2007 10:30 pm
Forum: Coding Questions
Topic: [PB 4.02 Windows] How to get caption color of Frame3DGadgets
Replies: 1
Views: 920

[PB 4.02 Windows] How to get caption color of Frame3DGadgets

How can I get the actual text color of Frame3DGadget's captions.
Depending from the selected XP style, the color changes. I would like to add captions to Frames using normal TextGadgets with the same color as the originals.

Thanks
by jear
Thu Jan 11, 2007 9:28 pm
Forum: Feature Requests and Wishlists
Topic: Just a simple wish about the protected keyword
Replies: 3
Views: 2078

I agree :D

But not only Protected!
Global, Shared, Static... too.
by jear
Tue Jan 09, 2007 12:17 pm
Forum: Feature Requests and Wishlists
Topic: [Implemented] Define multiple Dim and NewList in a row.
Replies: 10
Views: 3203

because 'Define.s' can be used alone to 'preset' all futured variables as .s

Code: Select all

EnableExplicit
Define.s 

a = "a" ; this is a string. 
b = "b" ; this is a string. 
???
by jear
Mon Jan 08, 2007 11:41 pm
Forum: Feature Requests and Wishlists
Topic: [Implemented] Define multiple Dim and NewList in a row.
Replies: 10
Views: 3203

BTW...

Code: Select all

Define.s a, b, c
but

Code: Select all

Global.s x, y, z
causes a syntax error!
by jear
Sun Dec 31, 2006 12:14 am
Forum: Coding Questions
Topic: DateDiff ?
Replies: 12
Views: 3378

This code will return the time difference as string.
; TimeDiffString : jear Dez 2005

;#TimeUnits = "Woche|n,Tag|e,Stunde|n,Minute|n,Sekunde|n"
#TimeUnits = "week|s,day|s,hour|s,minute|s,second|s"

Procedure.s AddTimeUnit(number.l, unit.l)
Protected Result.s, sUnit.s
If number = 0 ...
by jear
Fri Dec 22, 2006 1:12 pm
Forum: Tricks 'n' Tips
Topic: Calculate accurate differences between date/times
Replies: 14
Views: 8172

What's about this code
; TimeDiffString : jear Dez 2005

;#TimeUnits = "Woche|n,Tag|e,Stunde|n,Minute|n,Sekunde|n"
#TimeUnits = "week|s,day|s,hour|s,minute|s,second|s"

Procedure.s AddTimeUnit(number.l, unit.l)
Protected Result.s, sUnit.s
If number = 0 : ProcedureReturn "" : EndIf
If number ...