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 ...
Search found 20 matches
- Tue Nov 10, 2009 1:39 am
- Forum: Announcement
- Topic: COMatePLUS version 1.2
- Replies: 339
- Views: 229084
- 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
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

Code: Select all
;/ Save excel sheet as .CSV
; code removed, see below
- 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 ...
;#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 ...
- 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 ...
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 ...
- Sat Jul 21, 2007 12:30 am
- Forum: Tricks 'n' Tips
- Topic: CSV and Quotes
- Replies: 23
- Views: 11202
- Sun Jun 10, 2007 2:08 pm
- Forum: Coding Questions
- Topic: ProcedureReturn optimisation?
- Replies: 15
- Views: 2628
- Thu May 31, 2007 10:22 pm
- Forum: Coding Questions
- Topic: Anyone tried adding functionality to the Windows Shell?
- Replies: 1
- Views: 1067
- 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
- Mon Mar 19, 2007 3:34 pm
- Forum: Coding Questions
- Topic: Strange Movie problem
- Replies: 18
- Views: 4314
- 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
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
- 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
- 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 .sCode: Select all
EnableExplicit Define.s a = "a" ; this is a string. b = "b" ; this is a string.
- 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
- Sun Dec 31, 2006 12:14 am
- Forum: Coding Questions
- Topic: DateDiff ?
- Replies: 12
- Views: 3378
- Fri Dec 22, 2006 1:12 pm
- Forum: Tricks 'n' Tips
- Topic: Calculate accurate differences between date/times
- Replies: 14
- Views: 8172