VB Forum / General / September 2006

IN vb6, Large objects containing large number of objects seems to take
a long time.
So when my codee hits set object = nothing, the process pauses for a
long time while the deallocation completes.

I am rather good at string manipulation. Yet somehow this silly problem
stumped me
In a string, (Not in any text box; just a variable holding the string),
suppose the

I am in need of help in writing values into a Xls(Excel Apllication) File in
Visual Basic.
Can any one give some Examples  how to do this.
Thanks in Advance.

i am rewriting a front-end user menu system for our old DOS applications.  
Once a user is validated they will have a selection of applications and be
able to click a command button that will 'shell' execute one of them.  I
don't want to do this modally (e.g. shell and wait) ...

I would like to know what this function is intended to do.
Many thanks

I am using Visual Studio 2005 IDE, I could not find MSMAPI component in
the Component list of "Add Reference Menu". When I browse to file
"C:\WINDOWS\system32\mapi32.dll" then It gives error that "A reference
to 'C:\WINDOWS\system32\mapi32.dll' could not be added. Please make

formtext = "frmMan"
load Forms(formtext )
But
cmdtext = "command1"

Is this the correct forum for asking a question about vb script?
Thanks
Dave

How do I select a cell or range of cells using row and column values (R1C5)
instead of E1. The Range function only allows the 'E1' type of selection. Is
there a way?
Thx Bart

I can get from my database a Base64 string representation of a PNG
image.  I need to be able to unencode(?) this so that I can render it as
an image via ASP.  Architecture is PostgreSQL -> VB6 -> ASP (none of
this is .Net, all old school).

First of all, this code, i assume, would return a random integer from 1 to 5.
Function D6() As Integer
       Return (Rnd() * 5) + 1
End Function

i have some database
and i want to export it into ms excell
if i export less than 35.000
the code is run like i want

Is there any way to get then name of the control that the mouse is
over on a form even if it is not the activecontrol

I would like to know what book can I get on vb6 that will teach me how to
master the language.  I know one book may not do the job, so expecting
someone to list more than one book.  Also when it come to learning vb6 what
categories would you include like database, api, etc.  I ...

I'm Trying to limit the columns in a listview to the header text.
Is there an easy way of doing this. Perhaps using API ?
Greetings,
Farmer