Search found 1271 matches

by Zippy
Sep 20, 2018 1:52
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 7106

Re: Where have I gone wrong

Where have I gone wrong -- Some time ago, I'd say, because: you should have taken some time, to educate yourself, before tackling such a complex endeavour, which, without some basic know-how, is "unlikely successful". Looking at the VB.net code and, by comparison your FB code, I get the i...
by Zippy
Jun 30, 2018 21:49
Forum: Beginners
Topic: Number of occurences
Replies: 7
Views: 697

Re: Number of occurences

All at once:

Code: Select all

dim as long txtcount(0 to 255), c
dim as string txt = "Now is the time"

for c=0 to len(txt)-1
txtcount(txt[c])+=1
next

for c=0 to 255
if txtcount(C)>0 then print c,chr(c),txtcount(c)
next
by Zippy
Dec 31, 2016 19:41
Forum: General
Topic: Simple Calendar (Show only one month)
Replies: 28
Views: 2078

Re: Simple Calendar (Show only one month)

This is an example using Zeller's that accommodates leaps. I've today modded the 10yo code for 64-bit compatibility - it should remain 32-bit able but didn't test. 'Perpetual calendar >year 1582 ' '#define MondayStartZ 'function returns dateserial of date declare function printcal(ds as string) as l...
by Zippy
Nov 12, 2016 0:52
Forum: Beginners
Topic: Opening a webpage
Replies: 23
Views: 2019

Re: Opening a webpage

What's the difference between using CHR(34) and the "" inside a string? a = "this " + chr(34) + "that + chr(34) b = "this ""that""" There's no functional difference. chr(34) is easier for me to parse visually. Is this "'' 2 double quotes, ...
by Zippy
Nov 11, 2016 22:16
Forum: Beginners
Topic: Opening a webpage
Replies: 23
Views: 2019

Re: Opening a webpage

This is a solution using quoting: dim as string orgstr, newstr orgstr = "http://www.ebay.com/sch/i.html?_&_nkw=beatles+1962&_sacat=11233" newstr = "http://www.ebay.com/sch/i.html" & chr(34) & "?_&_nkw=beatles+1962&_sacat=11233" & chr(34) ' pr...
by Zippy
Sep 13, 2016 17:48
Forum: Libraries
Topic: Excel Disphelper help
Replies: 253
Views: 49064

Re: Excel Disphelper help

@phishguy Ask me what I know about custom Excel sorts... Nothing. Ask me if I was even aware of custom Excel sorts... NO. I need to see (to have, to possess) the workbook/sheet that goes with your VBA code. And confirm that your VBA code works - this isn't clear from your post. With cursory look; th...
by Zippy
Sep 06, 2016 18:42
Forum: Documentation
Topic: GetMouse Documentation Error @ Clip? (SOLVED)
Replies: 14
Views: 2226

Re: GetMouse Documentation Error @ Clip? (SOLVED)

On Win 10 the mouse wheel is no longer registered on a transparent part of a screen. I have mentioned this before. I had written some code to magnify a bit of the desktop. Win 10 has pretty well stopped getcursorpos --( getmouse from kernell32.dll) -- (it is now dead slow and crash) And no longer c...
by Zippy
Sep 01, 2016 20:23
Forum: General
Topic: remove the values duplicated in the array not efficient
Replies: 13
Views: 988

Re: remove the values duplicated in the array not efficient

fxm wrote:You are never as well served as when you serve yourself.

Even a stopped clock is right twice a day.
by Zippy
Jul 19, 2016 19:04
Forum: Projects
Topic: Excel helper wrapper
Replies: 71
Views: 19083

Re: Excel helper wrapper

@BasicScience Good feedback, thanks. In your experience, at least, the "Global" issue with Office 2016 isn't. Would be good if you will test again if you update Office, and report the outcome. When I say that: res=dhcallmethod(xlApp,"Quit") "reports success"; this means...
by Zippy
Jul 17, 2016 17:23
Forum: Projects
Topic: Excel helper wrapper
Replies: 71
Views: 19083

Re: Excel helper wrapper

@BasicScience I did have the thought (!) that you might not have permissions to update Office on your test system, before I suggested this. But I hope that you can and have updated and the Zombies have been defeated. If not... I have test code that will eliminate the "Global" factor, and d...
by Zippy
Jul 16, 2016 22:13
Forum: Windows
Topic: Do Shell commands work OK in Windows 10?
Replies: 6
Views: 953

Re: Do Shell commands work OK in Windows 10?

@PhiltheBear

The answer is "Yes". It appears to be the same sort.exe in both 7 & 10, based on functionality. And old code I have that shells sort still works on 10. Shouldn't be a problem.
.
by Zippy
Jul 15, 2016 23:35
Forum: Projects
Topic: Excel helper wrapper
Replies: 71
Views: 19083

Re: Excel helper wrapper

@BasicScience I just tried this again. And again have no zombies. Making assumptions (mine, of course): 1. Your OS version probably isn't material. 2. Using fb 1.03.0 probably isn't material. I'm still thinking (!) that this is a versioning problem, that from my perspective the problem was here one ...
by Zippy
Jul 15, 2016 16:22
Forum: Projects
Topic: Excel helper wrapper
Replies: 71
Views: 19083

Re: Excel helper wrapper

RE: lingering excel.exe processes. I've used this code for testing: 'xlhelper.bas test, multiple instances '' Does excel.exe remain after xlquit() & xlrelease() '' Compile as console prog. '' Tested Win10 64bit, Excel 2013/16, FB 1.05.0 (01-31-2016), built for win32 (32bit) ' #include "xlhe...
by Zippy
Jul 09, 2016 20:04
Forum: Windows
Topic: Is there a way to control desktop colours?
Replies: 11
Views: 1207

Re: Is there a way to control desktop colours?

Plasma TVs, which are flat-screen, are subject to burn-in and their power consumption varies with picture brightness. I should say "were" flat-screens, as they are no longer sold. The now-ubiquitous LED/LCD screens do not vary consumption by picture brightness, technically, but the always-...
by Zippy
Jul 02, 2016 20:42
Forum: Windows
Topic: windows run command
Replies: 3
Views: 842

Re: windows run command

Have you tried start:

Code: Select all

dim as string sp="start navw32"
shell(sp)

Go to advanced search