VB Forum / General / July 2004

I currently do the above using an Excel 5 object library but I really need to start using the Excel 9 (2000) object library.  I've tried doing this simply by changing the reference in the Project References but (not too surprisingly) this doesn't work.  I've read the Knowledge ...

Hi, I have a probrem with TrueDBGrid6.0 and VB6.0.
I've made a data entry application with TrueDBGrid6.0.
It works very well. But I continuously press key "left and right"
while TrueDBGrid has focus,  it spends CPU time (30%).

We are losing memory in a recursive function witch
instanciate and terminate (visual basic 6) com objects
Is there any (win32 api) method to say to the system. "Hey
recover all the free memory"?.

Lets say:
Dim ws as Worksheet
Now, I want to set the whole first column fillcolor to white ("no fill").
How can I do that?

I've gone through the SDK's tutorials and a few other tutorials on the
web too. I can now create geometry, load pre-built objects (.X Files),
use lighting correctly, using textures, and the basic usual stuff like
rotating the world on the axis, etc.

I was looking for a way to dump as much information about an object as
possible. Say, I get a class object I know nothing about, and I'd like to
dump all its public variables and properties.
From what I know, it should be possible with COM objects to obtain the entry

Can not remember how to set the Left Margin when printing the data in a text
box.
Reason for Question.
I have my Left Margin set to

I've got a form with *lots* of controls on it
When the form opens, the form flickers quite a lot - how can I stop this ?
Assume I need to turn repainting off and then on at some point
thanks

Where are the various Int BIOS related functions documented?

I have downloaded alot of samples including Volume.exe from Microsoft web
site and found that they cannot set/get the volume control of Microphone. Is
there any why to set the volume of microphone using VB?
I am using vb6 on windows XP/2k.

POSTED IN
microsoft.public.vb.database.ado  
microsoft.public.vb.database.dao  
microsoft.public.vb.general.discussion

I would like to activate or deactivate a peripheral device
without using the windows device manager
but using a program.
I think VBA can do this, but... how ?

It's not that I can't make it work, It's working fine, but, I just wonder....
Is there a function "WeekNumber" that returns the week number of the year??
Just what   Format(Date, "ww") is doing  !!!
I'm mean, we have   Day(),  Month(),  Year(),  WeekDay(),  WeekDayName()

I have a worksheet object:
Dim ws as Excel.Worksheet
I can read and write from cells (ws.Cells).
Is there anyone who knows a function that inserts a column into a worksheet?

Which is the best tool to distribute a vb6 application?
My app uses ADO 2.7, some DataReports and some Custom Controls.
I'm actually using the Packing and Distribution Wizard from Visual
Studio Tools, but I'm not feeling really confortable with this.