|
Hi,
The situation is like this:
I have created a MCQ test using a excel spreadsheet and I have created a nice macro GUI which will display the "time left" and will save and close the application which the time is up.
May I noe how can I prog the macro to run automatically when the spreadsheet is opened ?
Please advise. Thank you !!
With regards
bk
|
|
|
|
|
Why don't you call the macro in the spreadsheet auto macro called Workbook_Open()?
Therefore it will always be called when the spreadsheet is opened.
|
|
|
|
|
Is it possible to connect to As400 using winsock?
If so can you referrer to the sites and examples.
Thanks
|
|
|
|
|
All,
1)
Why does
Dim mResult as double
mResult = 0.1 * 0.1
return mResult = 0.010000000000000002?
What can I do about it?
Thanks,
Joe
|
|
|
|
|
You cannot trust double nor float results on any language (to be picky, those who use IEEE floating point arithmetic): they are subject to rounding errors.
A full description of the causes can be found on several articles on the web, like here
Search google for, e.g., IEEE rounding errors.
There are quick ways of working this around:
1. round the results
2. don't compare with '=', use a 'between'-like comparison.
3. Use the Decimal data type.
Trying to make bits uncopyable is like trying to make water not wet.
-- Bruce Schneier
|
|
|
|
|
Rounding worked great - thanks.
I'll read those references to get educated - I haven't done very much numeric computing stuff.
|
|
|
|
|
Sir
To create a hook dll people recomending to create a dll in visualc++ and use that in vb.
Is it not possible to create a vb dll for a creating a system wide hook dll for example keybaord hook dll and use the same way as we use dll made from vc++ or delphin software.
Please give me suggestions what are the draw backs in creating a vb dll and what are the constraints we have to consider in creating a dll in vc++ that can be used in vb for the purpose of system wide hook
Thanks in advance
rvvimal
|
|
|
|
|
percyvimal wrote:
Is it not possible to create a vb dll for a creating a system wide hook dll
Nope. Sorry.  But you might look around for a system-wide hook DLL that's meant for use with .NET.
Remember, btw, that you should only use system-wide hooks where absolutely necessary. 
|
|
|
|
|
Thanks sir,
But if you could provide me what are the important things that is necessary for creating a vc++ dll like i didnt understand the address parametes where u need to send the address of the call back function and how the function should be decalared in vc++ etc
then it will be really helpful to me
thanks in advance
|
|
|
|
|
The hook types WH_KEYBOARD_LL, WH_MOUSE_LL, WH_JOURNALRECORD and WH_JOURNALPLAYBACK can be written perfectly well in VB5 or 6.
The others require the hook procedure to be in the dll exports section which is not possible in VB.
'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd
|
|
|
|
|
I want to play quick time video (.mov) file in vb. How can I play ?
When I use microsoft active movie control, It gives me unspecified
error. pls advice if there is any codec required for that.
thanks in advance
sanjeev kumar 
sanjdhi@rediffmail.com
sanjeev
|
|
|
|
|
There are codecs involved. Why not just use the QuickTime Control (QTPlugin.ocx)?
RageInTheMachine9532
|
|
|
|
|
Hi Folks
I have 2 datagrids - don't worry about the contents. When I scroll datagrid1, I want to scroll datagrid2 so that both datagrids have the same row number for the first visible row.
I know how to scroll to, but I have no idea how to get the rownumber of that first visible row in datagrid1.
A code scrap would be much appreciated.
Thanks
|
|
|
|
|
I am programing a windows app (much like my console app talked about earlier in the forums) such as this.
User inputs number
Number is stored into an array
there are commands the user can use to print sort and other such things.
I do not want to use the arraylist function. I want to do this using just using array as such:
Dim array1(3) as string
I'm not sure how to add items to the array. In all my searching I only found information on the Arraylist. If anyone can Point me in the right direction.
"Doko ni datte, hito wa tsunagatte iru." -Lain
|
|
|
|
|
Do you mean to assign objects to the array, simply do this
array1(0) = "Hello"
array1(1) = "world"
If you mean to increase the capacity of the array, use the Redim keyword
Redim Preserve array1(10)
array1(9) = "Bye"
Sig Under Construction. Visit back later.
Support Bone
|
|
|
|
|
I want to assign objects to the array. However I need to do this dynamically as they type information in.
I can't get the code right for the program to add the new string to the end of the array.
|
|
|
|
|
Post a code snippet so we can see what you are doing. The two methods above work perfectly for String types also, so we're not getting all the details we need to know to answer your question.
RageInTheMachine9532
|
|
|
|
|
So you're looking to dynamically increase the size of the array? If so, the earlier suggestion of Redim should work for you. You may want to look at the ArrayList class in the .Net Documentation anyway - the Add method makes it easy to work with a dynamically increasing list, and there are CopyTo and ToArray methods if you need to convert it to an actual Array object.
|
|
|
|
|
redim preserve numarray(size)
numarray(ubound(numarray)) = newobject
size += 1
|
|
|
|
|
Dear Ladies|Gentlemen:
I developed a visual basic program in VB4
on Win3.11 (16 bit)incorporating an API
call to produce a 'siren' effect.
The executible worked fine in the 16 bit
environment but upon running it under
Win98 and Win98se the 'siren' effect
doesn't work! There are no 'run time'
errors... just no 'siren'!
The API is defined in 'general declarations':
Option Explicit
'api for sound.drv (called by subroutine 'racket')
'resides in module.bas
Declare Function opensound% Lib "sound.drv" ()
Declare Function setvoicesound% Lib "sound.drv" (ByVal nsource%, ByVal freq&, ByVal nduration%)
Declare Function startsound% Lib "sound.drv" ()
Declare Function closesound% Lib "sound.drv" ()
Declare Function waitsoundstate% Lib "sound.drv" (ByVal state%)
'The 'siren', named 'racket' is conditionally called from a subroutine:
Public Sub racket()
Dim t, n2, n3
Dim frequency As Long
Dim duration As Integer
t = opensound() 'start freq
again: 'label to repeat for siren effect
'n3 = frequency; here set in a for-next loop
'n2 = duration in 1/10th sec; + _
set here; now = to .3 sec
n2 = 8 'duration;
duration = n2
For n3 = 500 To 1200 Step 50 'freq in a for next loop
frequency = n3 * 65536
t = setvoicesound(1, frequency, duration)
t = startsound()
While (waitsoundstate(0) <> 0): Wend
't = closesound() stops frequency
DoEvents
Next n3
GoTo again
End Sub
How do I make this API work in windows 98 and 98se?
Thank you, Ralph
Thank you, Pedagogy
|
|
|
|
|
You could replace all the above declarations with one to the Beep API.
<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/debug/base/beep.asp">http:
Don't know if it is going to produce the exact same results, but the parameters you are using are the same as Beep.
RageInTheMachine9532
|
|
|
|
|
how can I write uninstaller by vb.net that will unistall my installed program.
tbhattacharjee
|
|
|
|
|
You can uninstall an .MSI (Windows Installer) installed application just by launching the .MSI file with the /x switch:
msiexec /x full_path_to_filename.MSI
RageInTheMachine9532
|
|
|
|
|
I want that when some on will run setup then setup will ask for serial no before installing software
tbhattacharjee
|
|
|
|
|
how can I create a setup.exe in .net that when application will be installed then a presentation of my software will be shown.please guide me in detail.
tbhattacharjee
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
