You probably won't be able to do this without using the Windows API. One way would be to use the API (not VB) GetFocus function to the the Excel handle (hWnd) then use the API SetFocus function to reset it just before executing the SendKeys function.
Hi Eric
The problem here is the MessageBox! Do you have to use it?
(To check this, change the MsgBox lines to something quick and dirty like "Caption = ...". No beep now when a key is pressed but the vk message is being received... at least on my system.)
-Ian
Hi
A quick-and-dirty solution to this is to parse the Ambient.DisplayName property. It will return the name of the usercontrol as it appears on the form [e.g. MyUsrCtrl(13)]. You can parse the index value and store it in Property or variable which can be used in any way you wish. There are...
Try the following:<br>
<br>
Const SR = 0<br>
Const GDI = 1<br>
Const USR = 2<br>
<br>
Declare Function pBGetFreeSystemResources Lib "rsrc32.dll" Alias "_MyGetFreeSystemResources32@4" (ByVal iResType As Long) As Long<br>
<br>
This returns the free System, User and GDI...
Randie<br>
<br>
The problem you are goind to have here is the the number of permutations (which is calculated using n!) rises VERY rapidly, e.g. a three-letter word has 6 permutations, a six-letter word has 720 and a nine-letter word has 362,880. Calculating them is simple but how do you want...
I am assuming that if you have four COM ports that there are two on-board the motherboard and two on an add-on card. I'm also assuming that you are running Win9x.<br>
<br>
For the on-board port, go into the CMOS setup when booting (on most machines hold down the <Del> key while booting)...
Sorry it took soo long to get back to you - <br>
With Win98SE you may as well use the software that comes with it. I've parttitoned bootable drives as big as 13Gb with it without problems. If you want a single partition, simply put you CD in the CD-ROM and switch on. The installation routine...
Alt255<br>
<br>
Over the years I have discovered the following rule of thumb (not quite Moore's Law but it has held for about ten years): If you upgrade across one generation about 10% of the old equipment will fail, if you upgrade across two generations the failure rate goes up to 50%. We...
What do you mean by configuring the ports? Change setting in the BIOS or on the IO-card? Change settings from within a program or operating system?<br>
<br>
-Ian
What operating system are you going to use? Each version of Windows has it's own limitations in terms of partition sizes and so forth. For example, if you are using NT4 you will have to use a version with SP4 or above (as these contain the update ATAPI v1.3 driver which van handle drives with...
Although you can use a standard 40-pin IDE cable on a DMA-66 drive/controller combination, to get the full performance increase you need a DMA-66 controller, a DMA-66 Hard Drive AND a DMA-66 IDE data cable. Although this cable looks just like a standard 40-pin IDE cable, cutting it up will...
Could you give some more details about your setup, e.g. What OS, any recently installed software, etc. Often problems like these are caused by some totally (apparently) unrelated problem. It sounds as though something is corrupt - probably in the registry. I would suggest uninstalling...
One thing to make sure of is that you've DECLARED CopyMemory as a SUB and not a FUNCTION. Declaring it as a function is usually instant death - often to the IDE as well!<br>
<br>
-Ian
I seem to remember seeing code for RCDs on Planet Source Code. Try doing a search under "Formula" - That seemed to be the common thread in the titles. If you have no luck, email me. I wrote one as an intellectual exercise many years ago. I could probably dig up the code and send...
You're absolutely right, RustyG.<br>
<br>
There are some some other factors to take into consideration though. Firstly, the PictureClip control looks like a wrapper for BitBlt & StretchBlt and, as can be expected, the really nice bits were ignored. Secondly, the use of "sprites"...
Hi beck<br>
<br>
Here is a simple little Sub to get you started<br>
<br>
Sub CalcSpeed(sngStart As Single, sngStop As Single, sngStep As Single, sngDistance As Single)<br>
Dim sngFricFact As Single<br>
<br>
Cls<br>
For sngFricFact = sngStart To sngStop Step sngStep<br>
Print...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.